E-commerce Analytics

This track simulates common retail analytics work from dataset exploration to KPI delivery. You will practice: revenue and order metrics ret...

This track uses a simplified retail/eCommerce model. New to dimensional modeling? Read Star Schema Basics first. It explains facts, dimensio...

Before you write a single KPI query, meet the data. Analysts who skip this step ship wrong numbers with confidence. The routine is always th...

This dataset is clean, and your job is to prove it. Each audit below returns counts of violations, and the contract is that every count is z...

These drills build practical eCommerce analytics skills with increasing complexity. Scoring suggestion: pass all easy drills pass at least o...

Assignments mirror common retail analytics questions. KPI focus: completed-order revenue (recognized revenue) repeat purchase behavior AOV b...

Marketing wants to stop sending the same email to everyone. The classic fix is RFM segmentation: score every customer on three behaviors and...

The growth lead is preparing a board slide and has two questions: where does the shop lose people on the way to a purchase, and is that gett...

Case brief: A merchandising lead wants a monthly country view of order performance and a clear read on how net revenue is trending month ove...