Design a rollup table for a sales OLAP cube

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain

Data Modeling

Difficulty

medium

Problem

Design a rollup table for a sales OLAP cube. Create a sales_rollup table that stores pre-computed aggregates at multiple granularity levels (day, month, year) using a granularity column.

Practice This Problem

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