Your question is Model a Drill-Down Dashboard. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
You are building the data model for an analytics dashboard used by business users to move from high-level KPIs into detailed records. The same dashboard must support multiple drill-down levels, cross-filtering, and consistent totals across every view. The main challenge is choosing a model that keeps the dashboard fast, avoids double counting, and stays easy to extend as new dimensions are added.
How would you structure the data model behind a dashboard that needs to support multiple drill-down levels and filters?