Loading interview...
Sales Analytics Star Schema
A medium Data Modeling mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Data Modeling
- Difficulty
- medium
- Seniority
- mid, senior
Interview Prompt
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.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your data modeling solution with real code execution
- Get instant feedback and a hire/no-hire decision