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

L5

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.

Summary

A working system. Now redesign it so the analysts can actually use it.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.