The 4 Types of Dimensions (Data Modeling 101)

Building a data warehouse as a data team is rarely straightforward. 

Each company has unique nuances and weird business logic to work around.

And when it comes to data modeling...

Designing your Dimensions will be a critical step.

But it's also something that causes teams a lot of stress.

Get it right, and your data model (and analytics as a whole) will run smoothly.

Get it wrong...

And you'll be spending more time fixing issues and feeling frustrated.

So what I want to talk about today are the four most common types of Dimensions that you'll run into:

This includes:

1. Role-playing
2. Conformed
3. Junk
4. Degenerate

The goal is to help you better understand the differences and common ways they are used.

That way you can build your own warehouse more effectively.

And ultimately, deliver more impact to the business through the data you present.