Facts and dimensions

A fact table contains the events or measures to analyze (sales, orders), with numeric values and keys. A dimension table describes the axes of analysis (product, customer, date, region). You analyze the facts by slicing and filtering them through the dimensions.

Example

Facts: sales lines. Dimensions: Product, Customer, Date.

Related concepts

The whole glossary