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 RUclipsR 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!

[@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

[@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 !

[@nsrchndshkh]

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

[@ITkFunde]

Thanks Nasir means a lot brother 🙏♥️

[@kovid.rathee]

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

[@ITkFunde]

Thanks Kovid

[@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!

[@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 😊🙏

[@bradcampbell374]

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

[@ITkFunde]

Thanks Brad 🙏

[@SDvirgo]

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

[@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!

[@VikasSinhaCDB]

Awesome delivery! Single shot you covered every thing.

[@callmesubhoo]

Excellent! Simple, crisp and well explained.

[@pankajlkhn115]

Excellent simplied explanation ! Kudos for all your efforts !

[@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.

[@simon_bateson]

Great introduction to Data Vault concepts, thank you!!

[@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

[@CoolCatJulia]

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

[@tusharpoojary6676]

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

[@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 ☺️

[@ExploreEuroCulture]

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

[@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

[@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 👍

[@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

[@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 ☺️🙏

[@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.

[@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

[@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 🙏☺️

[@pawansikawat8050]

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

[@ITkFunde]

Thanks Pawan 😊

[@bardamu9662]

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

[@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

[@A0STX]

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

[@ITkFunde]

Thanks a lot 🙏🙏☺️

[@mangeshxjoshi]

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

[@joaocruz9304]

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

[@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.

[@jvdborre]

Really well done, I'm bookmarking this!

[@ITkFunde]

Thank you Joris for motivating words. It helps !!

[@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 .

[@aftabalam-fy6kh]

Very well explained! Thanks for sharing this video.

[@pedrerorey]

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

[@ITkFunde]

Thanks Rey☺️🙏

[@kikthota]

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

[@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

[@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 :)

[@pratikroy2448]

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

[@damiann4734]

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

[@abhisheksemalty24]

Extremely helpful! Thank you.

[@NS-cp5bx]

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

[@dresvel]

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

[@rajeevkumar-kk5bh]

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

[@saravananvel2365]

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

[@chillhopmellowbeatssoul4988]

Beautifully explained! Wow! Thank you!

[@ITkFunde]

Thanks

[@jawa4763]

Wow... Amazing Brief Explanation ! Hats off :)

[@ITkFunde]

Thank you Jawa !!

[@joaopereira5576]

Amazing explanation! Thank you very much!

[@vamsiharati3206]

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

[@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?

[@titabm21]

Thank you so much for such detailed explanation!

[@ITkFunde]

Thanks

[@16692abhishek]

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

[@nammals]

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

[@phaninany]

Very nice explanation !! Thoroughly Enjoyed it.

[@ITkFunde]

Thanks Phani !!

[@samanthapikus3178]

Wow!!! Excellent Material and well explained!

[@ITkFunde]

Thanks Samantha for this encouraging feedback !!!

[@juliekell9454]

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

[@daanraven9362]

Perfect! Thank you very much!

[@ITkFunde]

Thanks Raven

[@leedsshri]

Very good explanation, it looked so complex in articles and in some websites but you broke the complexity with an easy example. All the best...

[@ITkFunde]

Thanks Saravana !

[@jagratimodi7608]

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

[@wayneyellow5843]

Nice video, very well explained. Thank you!

[@robinjamwal1]

Very well explained. Thank you very much!

[@rajaarchanapandiripalli5279]

Very clear and very detailed!! Thank you

[@ITkFunde]

Thanks Archana :)

[@hareeshgunda8371]

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

[@debmalyaroy7569]

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

[@asishjoshi5774]

nice.. simple n good explanation! Thanks!

[@jsparekh1]

Very Nice explanation!!! Kudos!!

[@mearigureisu9679]

Thank you soo much! Nice explanation about data vault! I'm subscribing. Keep it up.

[@ITkFunde]

Thanks Maria for your support !!

[@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 🙏☺️

[@HomelessOnline]

Great explanation, I only had to watch it once!

[@shahajiudar9386]

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

[@sagarmorakhia]

Very well explained. Thanks!

[@mariappanpalanivelu3426]

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

[@ITkFunde]

Glad it was helpful!

[@AirtagAlex]

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

[@rmishra66]

I really like the simplicity of explaining complex concepts....you are awesome and keep up the good work....I always look for your videos all the time

[@ITkFunde]

Thanks Rajesh ☺️🙏

[@nadaassila2425]

Very clear thank you!

[@pio024]

thanks very much for creating this video and explaining all these difficult subjects in such a way that was very easy to follow and understand for someone without any previous experience!

[@ITkFunde]

Thanks Behroz

[@prasanthan1995]

great job. i clearly understood.keep it up

[@ITkFunde]

Thanks Prasanthan please watch other videos on our channel and share your feedback.

[@lcsxwtian]

Thank you Anshul for such an informative video! I certainly learned what I need to know about Data Vault in your one-stop-shop!

[@ITkFunde]

Thanks Tian 🙏☺️

[@sawansoni449]

Very informative session, complex stuffs explained in very simple way

[@rajendrathorati5156]

Well done. Thanks for posting..

[@ITkFunde]

thanks Rajendra

[@jeromeugaditano]

great explanation. learned a lot! Keep it up

[@ITkFunde]

Thanks Jerome !!

[@subbuk-hc1fk]

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

[@ITkFunde]

Thanks Subbu

[@bhaskarsharma5341]

explained in so simple terms.. Thanks Anshul :)

[@sudippandit3943]

perfect! Thank you bro!!

[@ankitvats4795]

Excellent video. Very well explained. Please come up with more videos on Data Vault with practical examples. Thanks for the video.

[@ITkFunde]

Thanks Ankit, will definitely plan something. PLS KEEP SUPPORTING AND WATCH OTHER USEFUL TUTORIALS ON GCP AND NETWORKS.

[@nidhiigupta3161]

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

[@ITkFunde]

Thank you Nidhi pls keep supporting !! Anshul

[@akshaymanthalkar]

Thanks Anshul! Very well explained.

[@balajirajagopalan3022]

Awesome and concise explanation, thank you so much.

[@ITkFunde]

Thanks Balaji ☺️🙏

[@2kpravin]

Man! I would say- you are awesome! Thanks for such nice explanation.

[@ITkFunde]

Thanks Pravin 🙏☺️

[@tuanpa2201]

thanks for the clear explanation

[@paltube11]

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

[@loriviccua4003]

awesome! I learned in short minutes

[@karthicr6568]

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

[@mangeshgawali7683]

Thank you, Anshul. Great explanation.

[@ashsharma15]

Very nice Video !Now I can think of implementing vaults but first need to understand best scenarios suitable for the same in projects

[@karthiknaidu111]

Very nicely explained, Thanks for making the Data Vault concept so easy to understand..

[@ITkFunde]

Thanks Karthik 🙏☺️

[@manishbajaj4693]

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

[@ITkFunde]

Thank you Manish ☺️🙏

[@desarrollojava]

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