Dimensional Modeling

Dimensional modeling structures analytical data around measurable business events and the descriptive dimensions used to understand them.

Fact tables hold events and numeric measures. Dimension tables describe entities such as customers, products, locations, and dates. The model is optimized for understandable and efficient analytical queries.

Important design decisions include grain, conformed dimensions, slowly changing dimensions, surrogate keys, and additive versus non-additive measures.