The Sales Architecture
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
- L4
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.
Summary
Numbers are easy. Making them queryable at scale is the real job.
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