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 Science (7 posts)
A collection of projects showcasing expertise in data analysis, machine learning, statistical modeling, and business intelligence using Python, SQL, Tableau, and advanced analytical techniques.
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.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...
Chapter 1: Unlocking eCommerce Success
Join me as I launch a comprehensive data analysis of TheLook, a realistic eCommerce platform.