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

Domain

Data Modeling

Difficulty

medium

Seniority

L5

Problem

We're a retail chain with 500 stores. Every transaction at every register flows into our data warehouse. We need a dimensional model for sales analytics, sliceable by store, product, time, and promotion. Can you 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 grades it automatically.