Chapter 4.2 Clustering in Action: Product & Customer from TheLook
How K-Means, DBSCAN & Hierarchical clustering reveal hidden patterns in customer behavior and product performance. Full analysis w...
#ecommerce-analytics (7 articles)
Discover 7 articles about ecommerce-analytics. Learn from posts and documentation.
Chapter 4.1: How Demographics Influence Customer Behavior
The analysis demonstrates a robust statistical methodology using z-tests and GLM modeling to evaluate cancellation rates across de...
Building Marketing KPIs from Raw Event Data Using SQL
Learn how to engineer core marketing KPIs using SQL from raw event data in BigQuery.
Chapter 3.3: Calculating Customer Experience KPIs
Analyze key metrics like delivery time, return rate, and OTIF to assess customer satisfaction and logistics performance.
Chapter 3.2: Sales & Profitability — Beyond Revenue
Learn how to calculate total sales and gross profit from eCommerce data using SQL.
Chapter 3.1: Data Cleaning & Prep for Reliable Insights
How I cleaned and prepared the TheLook dataset—handling missing values, duplicates, and ensuring data integrity for accurate KPIs.
Chapter 2: Exploring the theLook eCommerce Database
A data analyst's hands-on exploration of the theLook eCommerce dataset in BigQuery, revealing how to understand an unfamiliar data...