Loading interview...

Online Retail 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

Interview Prompt

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.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your data modeling solution with real code execution
  4. Get instant feedback and a hire/no-hire decision