Star schema or one big table: which does your new dashboard need?

The BI tool keeps writing clumsy joins.

Intermediate to advancedRead 6 minDoing: an hour, mostly checking with whoever asked for the dashboard6 steps

What you'll have at the end

A written call, star schema or one big table, with any grain-mismatched column pre-computed and labeled non-summable, for the specific dashboard it's sized for.

Before you start

You need

A specific new dashboard request with its list of required numbers, and access to (or a design for) the fact and dimension tables those numbers would come from.

Not covered

The SQL or dbt code that actually builds either model, and migrating an existing table from one shape to the other.

Leans on

6 steps

Where to go next

Fix a warehouse total that's doubled

when a total already looks wrong today, rather than during a planning decision, this diagnoses which join is inflating it

Make two departments' revenue numbers agree with one conformed customer dimension

for the moment a second team actually shows up wanting these same numbers, the flip trigger this recipe warns about

Checked 25 Aug 2026

Part of the Data Warehousing cookbook