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: https://youtu.be/XROtSVXbTvs Database Normalization Tutorial: https://youtu.be/dsZy-2EJGec ------------------------------------------------------------------------------ Data Podcast ►► https://open.spotify.com/show/4PWmW2gA5CUGJXKzqxaPg4 Website ►► https://www.nullqueries.com/ ------------------------------------------------------------------------------ 🎓Data courses (Not Produced by nullQueries)🎓 Azure Data Engineering: https://click.linksynergy.com/deeplink?id=MZk10dBo9EU&mid=39197&murl=http%3A%2F%2Fwww.udemy.com%2Fcourse%2Fbeginning-azure-data-factory%2F DE Essentials, hands on: https://click.linksynergy.com/deeplink?id=MZk10dBo9EU&mid=39197&murl=https%3A%2F%2Fwww.udemy.com%2Fcourse%2Fdata-engineering-essentials-sql-python-and-spark%2F ------------------------------------------------------------------------------ 📷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