Star Schema

Dimension Table: 7 Best Practices

A dimension table is one of the 2 primary building blocks of a dimensional data model. The other primary type of table is the fact table. This post will describe 7 best practices for designing a dimension table. What is the purpose of a Dimension Table A dimension table is the primary way to filter …

Continue reading Dimension Table: 7 Best Practices

Star Schema

What is Dimensional Modeling

Dimensional modeling is a data modeling technique in data warehouse design. Dimensional models use facts and dimensions to describe data for the business. Facts are typically numeric values that are additive (can be aggregated). Dimensions are descriptive elements used for grouping, labeling, and filtering facts. In the schema below: units_sold is a fact date, store, …

Continue reading What is Dimensional Modeling