Loading...
Online Retail Star Schema
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
- mid
Problem
We're a mid-size online retailer selling about 50,000 SKUs. The BI team needs self-service dashboards to analyze sales by product category, customer segment, geography, and time period. We also need to track inventory levels by warehouse. Design the dimensional model.
Practice This Problem
Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it instantly.