🗄️Fact Table
The table of events you count, such as sales. It holds numbers and keys.
Think of it like
It is like a pile of till receipts. Each one is a sale, with an amount and a few codes.
Example
Each row of fact_sales has a date key, a shop key, a product key, a quantity and an amount. It grows by a million rows a day.
Why it matters
Most business numbers are sums over a fact table. How it is built sets what you can ask.
Definition
Common mistake
Key takeaways
- 1One row, one event. Each row is something that happened.
- 2Numbers to add. Amounts and counts live here.
- 3Keys to describe. Keys point to dimension tables.