Dimensional Data Model Tutorial - A Kimball Style Data Model
Let's take a hand's on look at data modeling, specifically for data warehousing. Today we're modeling a dimensional data warehouse, based on Kimball methodology. We'll look at picking fact tables and dimension tables, how to create a star schema, and what to consider in the design.
⏯RELATED VIDEOS⏯
Data Vault Model Tutorial: • Data Vault Model Tutorial - An Altern...
Database Normalization Tutorial: • Database Normalization Tutorial - Mod...
------------------------------------------------------------------------------
Data Podcast ►► https://open.spotify.com/show/4PWmW2g...
Website ►► https://www.nullqueries.com/
------------------------------------------------------------------------------
🎓Data courses (Not Produced by nullQueries)🎓
Azure Data Engineering: https://click.linksynergy.com/deeplin...
DE Essentials, hands on: https://click.linksynergy.com/deeplin...
------------------------------------------------------------------------------
📷VIDEO GEAR📷
Programming Mouse: https://amzn.to/3zEom7f
Lighting: https://amzn.to/3o8tXAM
RGB light: https://amzn.to/3o8AQBS
USB Microphone: https://amzn.to/3m3hjAt
Mixer: https://amzn.to/2ZyqMIk
XLR Microphone: https://amzn.to/3AHPZ0L
💻VIDEO SOFTWARE💻
music/stock: https://1.envato.market/rnX70y
------------------------------------------------------------------------------
For business inquiries please contact [email protected]
Some of the links in this description are affiliate links and support the channel. Thanks for the support!
------------------------------------------------------------------------------
00:00 Intro
00:39 Business Process
01:19 Facts and Dims
02:33 Star vs Snowflake
03:23 Surrogate Keys
04:20 Dim Types
04:53 Grain
06:05 ER diagram
