eCommerce Track Overview

This track simulates common retail analytics work from dataset exploration to KPI delivery.

You will practice:

• revenue and order metrics
• return-adjusted performance
• customer repeat behavior
• fanout-safe KPI modeling

• joins and grouped aggregations
• CTE basics
• ratio calculations with NULLIF for safe denominators

1. eCommerce Star Schema
2. Meet the E-commerce Dataset
3. Data Quality Audit
4. eCommerce Graded Drills (Easy → Hard)
5. eCommerce KPI Assignments
6. RFM Customer Segmentation
7. Conversion Funnel Analysis
8. eCommerce Case Study Capstone

Milestone A: explore the dataset, pass the data quality audit, then pass all easy drills and at least one medium drill.
Milestone B: pass at least one hard drill, then complete the KPI assignments.
Milestone C: complete the RFM segmentation and funnel analysis, then finish the capstone with fanout-safe query logic.

Exit criteria:

• pass at least 80% of graded checks across the audit, drills, assignments, segmentation, and funnel pages
• complete capstone and explain your metric tradeoffs