Interview Guides
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?
