The Struggle of Data Modeling (Facts vs Dimensions)
All my FREE resources: https://www.skool.com/moderndata/about Consulting Services: https://go.kahandatasolutions.com ----- If I had to pick one thing data teams struggle with most in 2026... It would STILL be data modeling. Despite the fact it's been around for decades, there's a ton of content and even AI tools... It continues to be an area that gives teams a lot of trouble. But this is also understandable. Because it's one of the most custom aspects of data engineering. Textbook solutions can only get you so far. So in this video I'm going to take a slightly different approach to the subject. The goal isn't to talk about data modeling in terms of raw tactics. But rather just share different ways to think about Facts vs Dimensions at a high-level. Because sometimes I find that just hearing things put a slightly different way can unlock some understanding. And that's what I hope to do in this video. Enjoy! Learn more about how I help small data teams build modern architectures 👉 https://bit.ly/kds-advising Timestamps: 00:00 Intro 00:31 Purpose 01:50 Comparing to Words 02:58 Table Content 05:38 Why Do This At All?
The 3 Common Types of Fact Tables | Data Modeling 101
Learn Data Modeling in 8 minutes: Dimensional Data Modeling, Data Vault, and One Big Table
Data Lake vs. Data Warehouse vs. Data Lakehouse: Which One to Choose?
The Star Schema: Fact vs Dimension
3 Reasons Data Modeling Gets So Much Attention
Data Warehouse Schemas Explained: Stop Choosing Wrong in Interviews
Data Modeling Tutorial: Star Schema (aka Kimball Approach)
The 4 Common Types of Dimensions | Data Modeling 101
Avoid These 5 Costly Mistakes (as a small data team)
What is STAR schema | Star vs Snowflake Schema | Fact vs Dimension Table
Fact table and Dimension table | Data Warehousing
How to Track History in a Data Warehouse (Slowly Changing Dimensions)
How to Design a Perfect Fact Table – Deep Dive into Fact Types & Fact Table Types
Data Normalization vs Denormalization - Which is better when ?
Data Modeling in the Modern Data Stack
OLAP vs OLTP
The Risks of Lazy Database Roles
How to Design Dimension Tables | Types with Real Examples + Best Practices
Data Architecture 101: The 5 Key Questions
