Data Vault Model Tutorial - An Alternative to Kimball Data Warehouse

Опубликовано: 29 Июнь 2021
на канале: nullQueries
10,102
312

Let's take a hand's on look at modeling a Data Vault, an alternative approach to the Kimball dimensional data warehouse. We'll look at picking hub and link tables, their satellites, and how it all comes together.

⏯RELATED VIDEOS⏯
Dimensional Data Model:    • Dimensional Data Model Tutorial - A K...  
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:12 Hubs
02:33 links
03:06 Satellites
04:10 Reference
04:42 ER diagram