What is a Data Vault ? | 3NF vs Dimensional model vs Data Vault

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

Рет қаралды 129,250

Күн бұрын

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

Пікірлер: 450

@susanmyers1 4 жыл бұрын

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 4 жыл бұрын

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

@nsrchndshkh 2 жыл бұрын

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

@ITkFunde 2 жыл бұрын

Thanks Nasir means a lot brother 🙏♥️

@vgtek 4 жыл бұрын

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 4 жыл бұрын

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 !

@mahota7034 4 жыл бұрын

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

@ITkFunde 4 жыл бұрын

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

@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

@sandrafield9813 2 жыл бұрын

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 2 жыл бұрын

Thank you Sandra for your kind feedback and support 😊🙏

@sergiosouzalima 3 жыл бұрын

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!

@callmesubhoo 3 жыл бұрын

Excellent! Simple, crisp and well explained.

@bradcampbell374 Жыл бұрын

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

@ITkFunde Жыл бұрын

Thanks Brad 🙏

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

@prashanthmj4907 3 жыл бұрын

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 3 жыл бұрын

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

@ravikumaroruganti2097 4 күн бұрын

Thank you so much for simplified explanation.

@SDvirgo 3 жыл бұрын

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

@kovid.rathee 3 жыл бұрын

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

@ITkFunde 3 жыл бұрын

Thanks Kovid

@CoolCatJulia Жыл бұрын

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

@subbuk-hc1fk Жыл бұрын

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

@ITkFunde Жыл бұрын

Thanks Subbu

@VikasSinhaCDB 3 жыл бұрын

Awesome delivery! Single shot you covered every thing.

@pankajlkhn115 2 жыл бұрын

Excellent simplied explanation ! Kudos for all your efforts !

@ambetangyie4027 3 жыл бұрын

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.

@vamsiharati3206 Жыл бұрын

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

@joaocruz9304 3 жыл бұрын

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

@Ramble52 2 жыл бұрын

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

@ITkFunde 2 жыл бұрын

Thanks Bud for ur words

@ExploreEuroCulture 2 жыл бұрын

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

@tusharpoojary6676 3 жыл бұрын

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

@simon_bateson 2 жыл бұрын

Great introduction to Data Vault concepts, thank you!!

@androtel5922 6 ай бұрын

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 👍

@pedrerorey 2 жыл бұрын

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

@ITkFunde 2 жыл бұрын

Thanks Rey☺️🙏

@jvdborre 4 жыл бұрын

Really well done, I'm bookmarking this!

@ITkFunde 4 жыл бұрын

Thank you Joris for motivating words. It helps !!

@tarabutter1821 3 жыл бұрын

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 3 жыл бұрын

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

@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

@krithieshprabhukumar819 2 жыл бұрын

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 2 жыл бұрын

Thanks Krithiesh ☺️🙏

@debmalyaroy7569 6 ай бұрын

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

@A0STX 3 жыл бұрын

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

@ITkFunde 3 жыл бұрын

Thanks a lot 🙏🙏☺️

@DesiAngryYoungMan 3 жыл бұрын

Very useful, short and succinct.

@ITkFunde 3 жыл бұрын

Thanks

@pawansikawat8050 3 жыл бұрын

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

@ITkFunde 3 жыл бұрын

Thanks Pawan 😊

@joaopereira5576 9 ай бұрын

Amazing explanation! Thank you very much!

@mangeshxjoshi 2 жыл бұрын

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

@KamleshSharma-xk9zp 3 жыл бұрын

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

@ITkFunde 3 жыл бұрын

Thank you Sir 🙏☺️

@abhisheksemalty24 Жыл бұрын

Extremely helpful! Thank you.

@KVDBHRZNS 3 жыл бұрын

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?

@robinjamwal1 3 ай бұрын

Very well explained. Thank you very much!

@tapashmazumder3212 2 жыл бұрын

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.

@aftabalam-fy6kh 3 жыл бұрын

Very well explained! Thanks for sharing this video.

@bardamu9662 Жыл бұрын

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

@karthicr6568 2 жыл бұрын

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

@nadaassila2425 3 жыл бұрын

Very clear thank you!

@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

@yogeshkothari1 4 жыл бұрын

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

@ITkFunde 4 жыл бұрын

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

@dresvel 2 жыл бұрын

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

@damiann4734 Жыл бұрын

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

@daanraven9362 3 жыл бұрын

Perfect! Thank you very much!

@ITkFunde 3 жыл бұрын

Thanks Raven

@rajeevkumar-kk5bh 2 жыл бұрын

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

@sagarmorakhia Жыл бұрын

Very well explained. Thanks!

@pratikroy2448 2 жыл бұрын

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

@kikthota 3 жыл бұрын

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

@wayneyellow5843 2 жыл бұрын

Nice video, very well explained. Thank you!

@titabm21 3 жыл бұрын

Thank you so much for such detailed explanation!

@ITkFunde 3 жыл бұрын

Thanks

@Ayuk1 3 жыл бұрын

Very very insightful. Thank you

@ITkFunde 3 жыл бұрын

Thanks Mate

@asishjoshi5774 Жыл бұрын

nice.. simple n good explanation! Thanks!

@rajaarchanapandiripalli5279 4 жыл бұрын

Very clear and very detailed!! Thank you

@ITkFunde 4 жыл бұрын

Thanks Archana :)

@sudippandit3943 3 жыл бұрын

perfect! Thank you bro!!

@syedrazahaiderkazmi9641 Жыл бұрын

Excelent Job!!

@chillhopmellowbeatssoul4988 2 жыл бұрын

Beautifully explained! Wow! Thank you!

@ITkFunde 2 жыл бұрын

Thanks

@tuanpa2201 2 жыл бұрын

thanks for the clear explanation

@sawansoni449 2 жыл бұрын

Very informative session, complex stuffs explained in very simple way

@akshaymanthalkar 2 жыл бұрын

Thanks Anshul! Very well explained.

@HomelessOnline Жыл бұрын

Great explanation, I only had to watch it once!

@paltube11 2 ай бұрын

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

@altafpeerzade9609 2 жыл бұрын

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

@AirtagAlex Жыл бұрын

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

@jsparekh1 3 жыл бұрын

Very Nice explanation!!! Kudos!!

@ngocloile6641 3 жыл бұрын

really easy for understanding, tks you bro!

@ITkFunde 3 жыл бұрын

Thanks

@mariappanpalanivelu3426 Жыл бұрын

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

@ITkFunde Жыл бұрын

Glad it was helpful!

@nandak74 2 жыл бұрын

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.

@shrutipatil7544 3 жыл бұрын

Thank you! Really Helpful

@jagratimodi7608 2 жыл бұрын

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

@reyanpe9505 3 жыл бұрын

Good Job. Thx. Please more data vault

@ITkFunde 3 жыл бұрын

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

@saravananvel2365 5 ай бұрын

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

@vigneshmanoharan2310 3 жыл бұрын

Very nicely explained.. thanks much!

@ITkFunde 3 жыл бұрын

Thanks Vignesh

@NS-cp5bx 5 ай бұрын

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

@ravinderjeetsingh4345 2 ай бұрын

Explained brilliantly...

@rahulsirohi2163 2 жыл бұрын

awesome & simple explanation .. thanks

@ITkFunde 2 жыл бұрын

Thanks Rahul ☺️🙏

@fondofhao3726 Жыл бұрын

Great one! Very easy to understand

@ITkFunde Жыл бұрын

thanks

@jawa4763 4 жыл бұрын

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

@ITkFunde 4 жыл бұрын

Thank you Jawa !!

@phaninany 4 жыл бұрын

Very nice explanation !! Thoroughly Enjoyed it.

@ITkFunde 4 жыл бұрын

Thanks Phani !!

@hareeshgunda8371 2 жыл бұрын

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

@seiaeia5755 10 ай бұрын

Excelent Video ++ respect ++

@neerajsomani4 3 жыл бұрын

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.