Loading...
Sales Analytics 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, senior
Problem
Our BI team needs a dimensional model to analyze sales performance. We sell physical products through an online marketplace. Analysts need to slice revenue by product, seller, customer, geography, and time. The current OLTP database is normalized and queries are too slow for dashboards. Design the star schema.
Practice This Problem
Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it instantly.