POS Sales Data Warehouse
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
- L5
Interview Prompt
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.
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