Problem
You need a reporting model for visualization use cases that turns raw source data into consistent, governed facts and dimensions. The model should support dashboard performance, stable business definitions, and historical analysis without exposing raw operational complexity to report authors.
What this tests
- Dimensional modeling for facts, dimensions, grain, and surrogate keys
- ELT design for staging, intermediate, and mart layers
- Data quality controls for referential integrity, freshness, and schema stability
- Orchestration of model builds, dependencies, retries, and backfills
Reporting context
Assume the output is consumed by the Synechron visualization layer and common BI tools. The key challenge is designing a model that is easy for analysts to use while staying maintainable as source systems and business logic evolve.
You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.
