Loading...
The Retail Tables That Need a New Home
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
- senior, staff
Problem
You are given an existing transactional database from a retail operation covering orders, customers, products, stores, and employees. The analytics team cannot write performant queries against this structure. Redesign it as a dimensional warehouse that supports reporting on sales performance, product mix, and customer behavior.
Practice This Problem
Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it instantly.