AI engineering glossary · Data engineering
What is fact table?
Fact table: The central table of a dimensional model that records measurable business events, such as sales or clicks, as rows with numeric measures and keys pointing to dimensions. It is usually the largest table.
Fact table: an example
Each row is one order line with quantity, price and keys for date, customer and product.
Related terms
More Data engineering terms
Where you learn it
Fact table is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.