Define the grain for a subscription analytics fact table

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

Define the grain for a subscription analytics fact table. Each row should represent one subscription-month (one row per subscriber per month). Include the dimension keys and monthly metrics.

Practice This Problem

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