SELF-GUIDED BA PRACTICE Packages available · Access after confirmed paymentSee packages ↗

Business analysis glossary

Fact Table

What it is

A fact table holds the measurable events of a business process, one row per event at a defined grain, such as one row per order line, payment or appointment. It contains numeric measures and keys that link to dimension tables describing who, what, when and where.

Why it matters

Getting the grain of a fact table right decides which questions a report can answer and whether totals are correct. Analysts must agree the grain with the business, for example per order or per order line, before designing measures, otherwise numbers get double counted.

Example

The analyst defines the grain of the returns fact table as one row per returned item. Each row has the refund amount, the quantity and keys to the date, product, reason and warehouse dimensions. Because the grain is per item, the return rate by product can be calculated directly.

Used in these guides

CHECK BEFORE CONTINUING

Keep your work safe