Chapter 3.5: Measuring Inventory & Supply Chain Efficiency
Discover how to calculate key supply chain metrics like Inventory Turnover, Fill Rate, and Service Level using SQL. Turn data into...
#data-analysis (6 articles)
Discover 6 articles about data-analysis. Learn from posts and documentation.
Chapter 3.4: Advertising & Marketing — SQL-Based KPI Engineering
Learn how to engineer core marketing KPIs using SQL from raw event data in BigQuery.
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...
Chapter 1: Unlocking eCommerce Success
Join me as I launch a comprehensive data analysis of TheLook, a realistic eCommerce platform.