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: youtu.be/XROtSVXbTvs
Database Normalization Tutorial: youtu.be/dsZy-2EJGec
------------------------------------------------------------------------------
Data Podcast ►► open.spotify.com/show/4PWmW2gA5CUGJXKzqxaPg4
Website ►► nullqueries.com/
------------------------------------------------------------------------------
🎓Data courses (Not Produced by nullQueries)🎓
Azure Data Engineering: 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: 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: amzn.to/3zEom7f
Lighting: amzn.to/3o8tXAM
RGB light: amzn.to/3o8AQBS
USB Microphone: amzn.to/3m3hjAt
Mixer: amzn.to/2ZyqMIk
XLR Microphone: amzn.to/3AHPZ0L
💻VIDEO SOFTWARE💻
music/stock: 1.envato.market/rnX70y
------------------------------------------------------------------------------
For business inquiries please contact nullQueries@gmail.com
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
- Dimensional Data Model Tutorial - A Kimball Style Data Model ( Download)
- Data Modeling Tutorial: Star Schema (aka Kimball Approach) ( Download)
- DIMENSIONAL DATA MODELING TUTORIALS - STAR SCHEMA | Based on a case study | Part 1 ( Download)
- Let's Compare the Kimball and Inmon Data Warehouse Architectures ( Download)
- Master Dimensional Modeling Lesson 01 - Why Use a Dimensional Model ( Download)
- What is STAR schema | Star vs Snowflake Schema | Fact vs Dimension Table ( Download)
- New to Data Modelling Watch This First | Kimball, Star Schema ( Download)
- Data Modeling (Star Schema 🌟) in Power BI – Creating Dimension Tables ( Download)
- DIMENSIONAL DATA MODELING TUTORIALS - GALAXY SCHEMA | A CASE STUDY ( Download)
- Comparing 3 Types of Data Modeling (Normalized vs Star Schema vs Data Vault) ( Download)
- What is Dimensional Modelling | Data Warehouse Tutorial Beginners | Data Warehouse Concepts (9/30) ( Download)
- Practical Dimensional Data Modelling with Real Industry Example ( Download)
- DIMENSIONAL DATA MODELING TUTORIALS - STAR SCHEMA | Based on a case study | Part 2 ( Download)
- Data Modeling in the Modern Data Stack ( Download)
- ETL Architecture In-Depth - Dimensional Modelling 101 ( Download)
