Build a Reporting Star Schema

HardPipelines00:00

Practice interviewer

In session

5 left

00:00

Your question is Build a Reporting Star Schema. 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 need to log in / sign up to chat or submit.

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.