What is a Data Vault ? | 3NF vs Dimensional model vs Data Vault | Quick Starter Guide in 2023

What is a Data Vault ? | 3NF vs Dimensional model vs Data vault (2020)
#datavault #datavault2.0 #agile #datawarehouse #datamodelling #datavaultvs3nf #datavaultvsdimensionalmodel #itkfunde
**Link to other interesting tutorials**
What is a Datalake (2019) | Data lake vs Data Warehouse (English Subtitles) - • What is Data Lake (202...
Let's understand containers | 5 simple steps to create a docker container - • Lets understand contai...
Kubernetes crash course: In less than 15 minutes- • Kubernetes crash cours...
**Please visit below sections directly if you need specific information**
What is a Data Warehouse - 0:58
Understand 3NF (3rd Normal Form) and its challenges - 5:07
Understand the Dimensional model and its challenges - 1:40
Data Vault Concepts and high level architecture - 11:01
Data Vault Low Level Architecture - 14:01
Hi Friends, I am Anshul Tiwari and welcome to our youtube channel ITkFunde.
About this video -
In this video, we will understand what is a Data Vault and difference between 3NF
VS
Dimensional Model
VS
Data Vault.
Data Vault 2.0 is a data modeling technique that takes a hybrid approach towards designing a data warehouse by integrating good things of a 3NF (3rd Normal Form) and a Dimensional model. Data Vault is highly flexible, scalable and auditable which is required to build an agile data warehouse.
The pace at which business processes are evolving today, companies need a data warehouse that can easily absorb these changes while maintaining the data consistency. Data Vault with the help its 3 main components HUBS, LINKS and SATELLITES
provide a data model that can easily absorb these changes into an enterprise data warehouse.
3 components of Data Vault -
1) Hubs - Business keys which can be uniquely identified
2) Links - Relationship defined between 2 hubs
3) Satellite - Descriptor attached to a Hub which provides the business context
Data Vault offers an exciting option to be explored while designing an agile data warehouse. While you will still need dimensional models and data marts for Business Intelligence reporting. Data Vault can easily act as a middleman between source systems (3NF) and Data marts (Dimensional) as an enterprise data store or enterprise data warehouse.
PLEASE IF YOU FIND IT USEFUL KINDLY DO 3 BASIC ANY CZcamsR WANTS FROM HIS AUDIENCE - LIKE, SHARE AND SUBSCRIBE. THIS WILL REALLY MOTIVATE ME TO BRING
MORE SUCH USEFUL CONTENT IN FUTURE.
Credits and Free Resources -
en.wikipedia.org/wiki/Data_va...
www.vertabelo.com/blog/data-v...
danlinstedt.com/solutions-2/d...
• Dimensional Modeling t...
**Social Links**
Facebook - / itkfunde
Linkedin - / ansh9685
Twitter - / ansh9685
Blog - blogs.itkfunde.com/
Instagram - / itkfunde
**About This Channel**
Friends ITkFUNDE channel wants to bring I.T related knowledge, information, career advice and much more to every individual regardless of whether he or she belongs to I.T or not. This channel is for everyone interested in learning something new!

[@SDvirgo]

I was searching for a proper data vault here I go it's much easy & accessible thanks a ton!

[@anhz2023]

I find this channel the best of all online lessons in any of the topics covered.. Can I request to cover a list of all common tools and platforms used in each of the data pipelines.. even just a list will be useful.. thank you!

[@sergiosouzalima]

Hello, I hope everything's ok with you! I was looking for a fundamental explanation of Data Vault, and finally, I found this video. Congratulations! Very well explained. I want to encourage you to record another video, this time about Data Vault 2. Thanks!

[@androtel5922]

Beautiful video man. It's as clear as cristal water. I've been working in the BI field for 20 years, it's never been explained so clearly 👍

[@ambetangyie4027]

Excellent Video explaining concepts and challenges in data modeling and design. I’ve been working with business data for over 15 years and this video breaks down the concepts, challenges and solutions to solve.

[@ExploreEuroCulture]

It is the best explanation so far to understand basic DW models. Thank you for your effort.

[@tusharpoojary6676]

Commenting because you deserve it for the efforts and super clear explanation!

[@vgtek]

Hey this was really well done, great job breaking down the differences between the 3 modeling techniques and explaining DV with a very straightforward example - looking forward to more!

[@ITkFunde]

Thanks a lot for your encouraging feedback. It really helps me keeping motivated and bring more such useful content for everyone. Do suggest some topics !

[@susanmyers1]

Holy Cow that was incredibly enlightening! We are doing a build in Azure and I needed a refresher. So much value in your video! Thank You
IT k Funde!

[@ITkFunde]

Thank you Susan for this lovely feedabck. Please continue your support. Thanks ~ Anshul

[@VikasSinhaCDB]

Awesome delivery! Single shot you covered every thing.

[@callmesubhoo]

Excellent! Simple, crisp and well explained.

[@cakeuwaifu]

Thank you so much for this video, I learned a lot more from you and your videos than I have learning from anyone else. They are very informative and explain it in a very easy way, especially for someone like me who just started working with enterprise data warehouses. Great job keep it up

[@nandak74]

This video explains the data vault very nicely with example. I have watched many videos before this but nothing is close to this. Thanks for a such a nice one. Keep it.

[@simon_bateson]

Great introduction to Data Vault concepts, thank you!!

[@sandrafield9813]

Thanks!! Im new on the job and this helped me get up to speed much faster than some of the other videos from other content creators. You are succinct, direct, clear, and your examples are excellent! Subscribed!!!!

[@ITkFunde]

Thank you Sandra for your kind feedback and support 😊🙏

[@ravikumaroruganti2097]

Thank you so much for simplified explanation.

[@ITkFunde]

Thanks Ravi❤️

[@bradcampbell374]

Well done! That includes the editing of the video to make it concise without wasted pauses.

[@ITkFunde]

Thanks Brad 🙏

[@mangeshxjoshi]

appreciate your efforts , you have explained it in simple language , by giving simle example. thanks a lot. it really helps

[@bardamu9662]

Congrats for the great presentation laying down the key principles of the data vault architecture in a layman's terms.

[@dresvel]

Thanks for the video, its very clarify and motivate me a lot. The channel won a suscriber from Chile!

[@abhishekalmonde]

That was brilliantly explained. I am doing a Data Vault 2.0 Enterprise Data Lake and this is so relevant and besutifully explained. Not too long at all and will be great if you did another full explainer specifically with Data Vault 2.0. Thanks

[@tapashmazumder3212]

This is a really informative video. I got a brief but clear picture of what a data vault is and how is it different from other data model methodologies. Thank you for creating such good content.

[@pratikroy2448]

You saved me in my client round interview. Thanks a lot. Subscribed and shared ❤️

[@pankajlkhn115]

Excellent simplied explanation ! Kudos for all your efforts !

[@CoolCatJulia]

Great explanation and delivered with a lot of good energy! Thank you!

[@vamsiharati3206]

Simply yet brilliantly explained..
I visit this video again and again when I have doubts.. Thanks 👍

[@nammals]

So detailed, still explained in very simple way ! You got great teaching skills, not an easy for every one

[@kovid.rathee]

This is a superb introduction to Data Vault. Keep up the amazing work! Cheers!

[@ITkFunde]

Thanks Kovid

[@saravananvel2365]

Very well explained data vault in 20 mins with easy example. Thanks

[@Clentical]

Very Good Explanation. I have been working on data vault 2.0 from last 1 years. I can relate the information that you have provided. Keep it up .

[@kikthota]

Made it easy to grasp key concepts simultaneously working at the same time.

[@mahota7034]

So far the best short explanation on data vault. Good job

[@ITkFunde]

Thanks Mahota immensely grateful for your time and feedback spent on this video. keep supporting

[@NS-cp5bx]

THANK YOU!! You have nicely covered all the important points clearly and beautifully..

[@joaopereira5576]

Amazing explanation! Thank you very much!

[@nsrchndshkh]

Thank you so much, you explained it better than the Data vault guys.

[@ITkFunde]

Thanks Nasir means a lot brother 🙏♥️

[@damiann4734]

Thank you for the concise introduction. Quite easy to understand!

[@sawansoni449]

Very informative session, complex stuffs explained in very simple way

[@aftabalam-fy6kh]

Very well explained! Thanks for sharing this video.

[@debmalyaroy7569]

Thanks! You have explained the difference so clearly. It was really helpful.

[@Ramble52]

You did a great job explaining these concepts. Thank you for taking the time to put this together.

[@ITkFunde]

Thanks Bud for ur words

[@jagratimodi7608]

It was really descriptive. Thanks for such a great video.

[@hareeshgunda8371]

I hated data in my SAP BI training. Now it makes sense. Thanks

[@altafpeerzade9609]

wonderful explanation to understand clear concept of data vault, thanks for making such video's to understand clearly,,,,,

[@joaocruz9304]

Thanks a lot for your explanation!!! Clear as Crystal!

[@rajeevkumar-kk5bh]

Great video , I was looking for this actually .
Thank you so much

[@desarrollojava]

Very well explained. Very good video, timing and features like zoom in on important points.

[@nadeemrajabali3166]

Great Job. I have been asking this question to data engineers they were not able to give me an answer. You answered it in first 15 minutes. Well done. Highly appreciated.

[@ITkFunde]

Thanks Nadeem

[@A0STX]

Thanks so much for this. Look forward to more content from you!!🙏🏼🙂

[@ITkFunde]

Thanks a lot 🙏🙏☺️

[@wayneyellow5843]

Nice video, very well explained. Thank you!

[@HomelessOnline]

Great explanation, I only had to watch it once!

[@pedrerorey]

Very well explained with examples. You have my thumbs-up!

[@ITkFunde]

Thanks Rey☺️🙏

[@shahajiudar9386]

Really nice explanation. This is what I am searching. Thanks a lot !!!

[@KamleshSharma-xk9zp]

Short and to the point explanation. Keep going, you are doing great job. Thanks a lot for creating these videos.

[@ITkFunde]

Thank you Sir 🙏☺️

[@asishjoshi5774]

nice.. simple n good explanation! Thanks!

[@juliekell9454]

This was super helpful and very easy to understand. Thank you for making this tutorial

[@karthicr6568]

It was really a nice presentation. Tha k you very much

[@tarabutter1821]

Thank you very much for this video. I have a new job and I am trying to understand the data warehouse I need to work with for a while now. It was not clear at all before, but this was very, very enlightening!

[@ITkFunde]

Thank you Tara for your feedback it motivates me so much thanks keep supporting~ Anshul

[@abhisheksemalty24]

Extremely helpful! Thank you.

[@yogeshkothari1]

I have been looking for this particular content, thanks for covering this topic.
A perfect video to understand data vault.

[@ITkFunde]

good to see your constant support buddy this just keep me motivated :)

[@paltube11]

Very informative and well explained. I understand the concept of Data Vault much better now after viewing your video

[@krithieshprabhukumar819]

Thank you for this. I find this very insightful, simple & powerful. You really kept the explanation crisp & punchy. Appreciate your time & efforts behind the preparation & presentation.

[@ITkFunde]

Thanks Krithiesh ☺️🙏

[@robinjamwal1]

Very well explained. Thank you very much!

[@pawansikawat8050]

A really clean and simple explanation on the topic. Totally loved your videos. Keep up the good work!

[@ITkFunde]

Thanks Pawan 😊

[@AirtagAlex]

Nice video! Greetings from the netherlands. Very clear explanations!

[@jsparekh1]

Very Nice explanation!!! Kudos!!

[@jvdborre]

Really well done, I'm bookmarking this!

[@ITkFunde]

Thank you Joris for motivating words. It helps !!

[@prashanthmj4907]

Anshul, thanks for such noble work you are doing training the world articulating complex technological concepts, products, services, and solutions in a way a non-techy can understand. I have been in the IT industry for 35 years now seen and done everything including programing, managing, C-level, etc. Your articulation skills are so impressive creating me a student again to listen to your lecture series. Your thinking, understanding, and explaining technologies are crystal clear and accurate. Again, thanks and keep up the great work. I started listing to your videos just a week or two back and I already see so much of gratitude pouring in. God Bless my dear!

[@ITkFunde]

Thank you so much Sir coming from a senior means a lot to me 🙏 I am so happy to read this. You made my day with your support and blessings ☺️

[@prashantmhatre9225]

Wow, it's amazing explanation love it
Watching again tomorrow and will be noting down on notebooks

[@itconsultant6501]

Awesome content and presentation

[@tuanpa2201]

thanks for the clear explanation

[@mangeshgawali7683]

Thank you, Anshul. Great explanation.

[@ravinderjeetsingh4345]

Explained brilliantly...

[@sagarmorakhia]

Very well explained. Thanks!

[@16692abhishek]

Thanks for the explanation of the data vault this really made me understand the concept in one go

[@subbuk-hc1fk]

Great teaching....Thank you so much for your efforts explaining to us in detail

[@ITkFunde]

Thanks Subbu

[@akshaymanthalkar]

Thanks Anshul! Very well explained.

[@mariappanpalanivelu3426]

Excellent presentation. You explained clearly with examples. Thank you for the great work.

[@ITkFunde]

Glad it was helpful!

[@loriviccua4003]

awesome! I learned in short minutes

[@chillhopmellowbeatssoul4988]

Beautifully explained! Wow! Thank you!

[@ITkFunde]

Thanks

[@sajjadkabirmdsharifulalam8652]

Explanation got enlightened as you have narrated with Live example.... I will follow your more videos. Pls. keep it up. Thanks a lot.

[@ITkFunde]

Thanks Shariful 🙏☺️

[@neerajsomani4]

This is an awesome video. I have 7 years of experience in data engineering and based on my experience I can say you are a great instructor. All the best.

[@KVDBHRZNS]

Thank you for the presentation. I just realized that i am using similar technique in our EDW and I call it as my Normalized Data Store (NDS), without realizing it is some sort of Data Vault modeling. For every major concept (like Hub here), we create 2 surrogate keys, one we call it as object key and second one - object version key and all the child tables of the concept only use object key as the FK.

[@kaanchii123]

Is this the most common method these days?

[@Ayuk1]

Very very insightful. Thank you

[@ITkFunde]

Thanks Mate

[@rahulsirohi2163]

awesome & simple explanation .. thanks

[@ITkFunde]

Thanks Rahul ☺️🙏

[@annaduraip3182]

Really Great, and clear explanation

[@renatobuaizdelima5309]

great overview about data architecture with Data Vault, thanx!

[@ITkFunde]

Thanks Renato☺️

[@provishu]

beautifully explained !

[@vandanasharma4738]

Thank you thank you so much for sharing this..i was looking for data vault, kimbal and inmon methods.
Thank for sharing knowledge with easy examples. Please do share some more videos on data warehousing

[@prabhureddy548]

Wonderful video. Thank you so much 😊

[@ITkFunde]

Thanks Prabhu ☺️

[@vigneshmanoharan2310]

Very nicely explained.. thanks much!

[@ITkFunde]

Thanks Vignesh

[@manishbajaj4693]

Fantastic explanation Sirjee.. one of the best tutorial videos I have come across in CZcams. Kudos to you.

[@ITkFunde]

Thank you Manish ☺️🙏

[@farhankapdi1133]

Amazing explanation. You have gained a subscriber :)

[@taraprasaddash8643]

Your videos cleared my concepts more than the paid courses i had obtained for .
Keep it up .

[@ITkFunde]

Thanks Tara ☺️🙏

[@samanthapikus3178]

Wow!!! Excellent Material and well explained!

[@ITkFunde]

Thanks Samantha for this encouraging feedback !!!

[@DesiAngryYoungMan]

Very useful, short and succinct.

[@ITkFunde]

Thanks

[@indian_gagan]

superb content

[@nidhiigupta3161]

Very well explained. Well done. Thanks for sharing video.

[@ITkFunde]

Thank you Nidhi pls keep supporting !! Anshul

[@santoshsingh-nt2bb]

Your effort is appreciable on the content of Data Vault

[@ITkFunde]

Thanks Santosh

[@ngocloile6641]

really easy for understanding, tks you bro!

[@ITkFunde]

Thanks

[@reyanpe9505]

Good Job. Thx. Please more data vault

[@ITkFunde]

Thanks Reyan for your feedback I shall plan some more video on this topic.