Before I started using a Mac as my main computer, I would often find myself using Microsoft Access to do some data analysis for a one-off project. Now that I'm using a Mac, I needed to find a tool to do what I used to do with Microsoft Access. In my search I came across …
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 …
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, …
John Levandowski 