What the Script Remembers

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

mid

Problem

Sanofi's commercial analytics team wants a warehouse for prescription fills across the US, where brand managers slice volume and revenue by therapeutic class and manufacturer while field teams roll the same numbers up through prescriber territory and region. Drug attributes like formulary status and packaging change over time, and an analyst pulling last quarter's numbers must see each fill against the attributes that were in effect on the day it was dispensed. Design the model that serves both the therapeutic-class rollups and that point-in-time accuracy.

Practice This Problem

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