Syntha Lab RU

Star schema

Star schema: a reporting model with a fact table (sales, stock, receipts) at the center and dimensions around it: date, product, store, supplier, promotion (the Kimball approach). It lets any standard report be built from the same blocks.

Forecast and data

Open interactively →

Formula

Fact × dimensions = any standard report

How to read

Suppose a sales fact with 5 dimensions yields a report by store, category, week or supplier without new tables. The same dimensions across all facts make reports comparable; different reference lists break reconciliation.

Where it is discussed

Topics

Calculations

Documents

Other terms in the group

Open interactively →