The 4 Common Types of Dimensions | Data Modeling 101

Why It Matters

Proper dimension selection streamlines warehouse architecture, cuts storage costs, and ensures consistent, cross‑functional analytics, directly impacting business decision‑making speed and accuracy.

Key Takeaways

• Role‑playing dimensions let one table serve multiple date roles.
• Conformed dimensions provide a single, consistent reference across fact tables.
• Junk dimensions combine low‑cardinality flags into one reusable table.
• Degenerate dimensions store high‑cardinality identifiers directly in fact tables.
• Choosing the right dimension type optimizes storage and query consistency.

Summary

The video walks through four frequently encountered dimension types in star‑schema data modeling—role‑playing, conformed, junk, and degenerate—explaining when and why each should be used.

Role‑playing dimensions reuse a single table for different roles within the same fact, such as a central dim_date linked to order, ship, and delivery dates, saving storage and ensuring consistent definitions. Conformed dimensions are shared across multiple fact tables, like a single dim_customer used in sales, tickets, and email facts, preventing divergent definitions and enabling cross‑process analysis. Junk dimensions bundle several low‑cardinality attributes (e.g., is_gift, payment_method, channel) into one table to keep the fact narrow, while degenerate dimensions place high‑cardinality identifiers (order number, invoice number) directly in the fact when no richer descriptive table is warranted.

The presenter highlights practical examples: re‑aliasing dim_date three times, centralizing dim_customer for consistency, creating a composite key for the junk dimension, and inserting order numbers as degenerate attributes to avoid unnecessary tables. These patterns illustrate how thoughtful dimension design reduces redundancy, simplifies joins, and improves query performance.

Understanding and applying these dimension types helps data teams build cleaner, more scalable warehouses, facilitates accurate reporting across business units, and minimizes storage overhead—critical factors for organizations seeking reliable analytics at scale.

Original Description

Download the PDF shown in this video inside my free community

https://www.skool.com/moderndata/about

-----

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

Each company has unique nuances and business logic that they need to work around.

So when it comes to data modeling, designing Dimensions will naturally 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.

Enjoy.

Timestamps:

00:00 Intro

00:25 Download PDF

01:21 Role Playing Dimension

02:50 Conformed Dimensions

04:36 Junk Dimensions

07:23 Degenerate Dimensions

09:48 Mental Shortcut

10:44 ‌