Every Line Counts

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant feedback.

Domain

Data Modeling

Difficulty

medium

Seniority

L5

Problem

We run a retail chain of 500 stores, and every item scanned at every register lands in the warehouse. Analysts need to slice sales by store, product, calendar, and the promotions that fired, rolling up from a single receipt line to region, department, and fiscal period. Design the star schema.

Summary

Every beep at the register. Coupons, returns, all of it.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and checks it automatically.