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

Пікірлер: 451

  • @susanmyers1
    @susanmyers14 жыл бұрын

    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

    @ITkFunde

    4 жыл бұрын

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

  • @nsrchndshkh
    @nsrchndshkh2 жыл бұрын

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

  • @ITkFunde

    @ITkFunde

    2 жыл бұрын

    Thanks Nasir means a lot brother 🙏♥️

  • @vgtek
    @vgtek4 жыл бұрын

    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

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

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

  • @ITkFunde

    @ITkFunde

    4 жыл бұрын

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

  • @sandrafield9813
    @sandrafield98132 жыл бұрын

    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

    @ITkFunde

    2 жыл бұрын

    Thank you Sandra for your kind feedback and support 😊🙏

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

  • @bradcampbell374
    @bradcampbell374 Жыл бұрын

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

  • @ITkFunde

    @ITkFunde

    Жыл бұрын

    Thanks Brad 🙏

  • @SDvirgo
    @SDvirgo3 жыл бұрын

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

  • @sergiosouzalima
    @sergiosouzalima3 жыл бұрын

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

    Excellent! Simple, crisp and well explained.

  • @ambetangyie4027
    @ambetangyie40273 жыл бұрын

    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.

  • @kovid.rathee
    @kovid.rathee3 жыл бұрын

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

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thanks Kovid

  • @Ramble52
    @Ramble522 жыл бұрын

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

  • @ITkFunde

    @ITkFunde

    2 жыл бұрын

    Thanks Bud for ur words

  • @nadeemrajabali3166
    @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

    @ITkFunde

    Жыл бұрын

    Thanks Nadeem

  • @ExploreEuroCulture
    @ExploreEuroCulture2 жыл бұрын

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

  • @pankajlkhn115
    @pankajlkhn1152 жыл бұрын

    Excellent simplied explanation ! Kudos for all your efforts !

  • @CoolCatJulia
    @CoolCatJulia Жыл бұрын

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

  • @mangeshxjoshi
    @mangeshxjoshi2 жыл бұрын

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

  • @androtel5922
    @androtel59226 ай бұрын

    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 👍

  • @cakeuwaifu
    @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

  • @VikasSinhaCDB
    @VikasSinhaCDB3 жыл бұрын

    Awesome delivery! Single shot you covered every thing.

  • @KamleshSharma-xk9zp
    @KamleshSharma-xk9zp3 жыл бұрын

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

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thank you Sir 🙏☺️

  • @ravikumaroruganti2097
    @ravikumaroruganti20977 күн бұрын

    Thank you so much for simplified explanation.

  • @ITkFunde

    @ITkFunde

    Сағат бұрын

    Thanks Ravi❤️

  • @simon_bateson
    @simon_bateson2 жыл бұрын

    Great introduction to Data Vault concepts, thank you!!

  • @tapashmazumder3212
    @tapashmazumder32122 жыл бұрын

    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.

  • @joaocruz9304
    @joaocruz93043 жыл бұрын

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

  • @abhishekalmonde
    @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

  • @prashanthmj4907
    @prashanthmj49073 жыл бұрын

    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

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

  • @krithieshprabhukumar819
    @krithieshprabhukumar8192 жыл бұрын

    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

    @ITkFunde

    2 жыл бұрын

    Thanks Krithiesh ☺️🙏

  • @vamsiharati3206
    @vamsiharati3206 Жыл бұрын

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

  • @tarabutter1821
    @tarabutter18213 жыл бұрын

    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

    @ITkFunde

    3 жыл бұрын

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

  • @nandak74
    @nandak742 жыл бұрын

    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.

  • @pawansikawat8050
    @pawansikawat80503 жыл бұрын

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

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thanks Pawan 😊

  • @bardamu9662
    @bardamu9662 Жыл бұрын

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

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

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

  • @ITkFunde

    @ITkFunde

    Жыл бұрын

    Thanks Subbu

  • @A0STX
    @A0STX3 жыл бұрын

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

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thanks a lot 🙏🙏☺️

  • @tusharpoojary6676
    @tusharpoojary66763 жыл бұрын

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

  • @jvdborre
    @jvdborre4 жыл бұрын

    Really well done, I'm bookmarking this!

  • @ITkFunde

    @ITkFunde

    4 жыл бұрын

    Thank you Joris for motivating words. It helps !!

  • @kikthota
    @kikthota3 жыл бұрын

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

  • @Clentical
    @Clentical3 жыл бұрын

    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 .

  • @pedrerorey
    @pedrerorey2 жыл бұрын

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

  • @ITkFunde

    @ITkFunde

    2 жыл бұрын

    Thanks Rey☺️🙏

  • @debmalyaroy7569
    @debmalyaroy75696 ай бұрын

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

  • @yogeshkothari1
    @yogeshkothari14 жыл бұрын

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

  • @ITkFunde

    @ITkFunde

    4 жыл бұрын

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

  • @damiann4734
    @damiann4734 Жыл бұрын

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

  • @NS-cp5bx
    @NS-cp5bx5 ай бұрын

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

  • @daanraven9362
    @daanraven93623 жыл бұрын

    Perfect! Thank you very much!

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thanks Raven

  • @pratikroy2448
    @pratikroy24482 жыл бұрын

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

  • @tuanpa2201
    @tuanpa22012 жыл бұрын

    thanks for the clear explanation

  • @titabm21
    @titabm213 жыл бұрын

    Thank you so much for such detailed explanation!

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thanks

  • @chillhopmellowbeatssoul4988
    @chillhopmellowbeatssoul49882 жыл бұрын

    Beautifully explained! Wow! Thank you!

  • @ITkFunde

    @ITkFunde

    2 жыл бұрын

    Thanks

  • @saravananvel2365
    @saravananvel23656 ай бұрын

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

  • @joaopereira5576
    @joaopereira55769 ай бұрын

    Amazing explanation! Thank you very much!

  • @abhisheksemalty24
    @abhisheksemalty24 Жыл бұрын

    Extremely helpful! Thank you.

  • @aftabalam-fy6kh
    @aftabalam-fy6kh3 жыл бұрын

    Very well explained! Thanks for sharing this video.

  • @nammals
    @nammalsАй бұрын

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

  • @dresvel
    @dresvel2 жыл бұрын

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

  • @nadaassila2425
    @nadaassila24253 жыл бұрын

    Very clear thank you!

  • @leedsshri
    @leedsshri3 жыл бұрын

    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

    @ITkFunde

    3 жыл бұрын

    Thanks Saravana !

  • @rajaarchanapandiripalli5279
    @rajaarchanapandiripalli52794 жыл бұрын

    Very clear and very detailed!! Thank you

  • @ITkFunde

    @ITkFunde

    4 жыл бұрын

    Thanks Archana :)

  • @sajjadkabirmdsharifulalam8652
    @sajjadkabirmdsharifulalam86523 жыл бұрын

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

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thanks Shariful 🙏☺️

  • @robinjamwal1
    @robinjamwal13 ай бұрын

    Very well explained. Thank you very much!

  • @rajeevkumar-kk5bh
    @rajeevkumar-kk5bh2 жыл бұрын

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

  • @mariappanpalanivelu3426
    @mariappanpalanivelu3426 Жыл бұрын

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

  • @ITkFunde

    @ITkFunde

    Жыл бұрын

    Glad it was helpful!

  • @sawansoni449
    @sawansoni4492 жыл бұрын

    Very informative session, complex stuffs explained in very simple way

  • @karthicr6568
    @karthicr65682 жыл бұрын

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

  • @16692abhishek
    @16692abhishek4 жыл бұрын

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

  • @rahulsirohi2163
    @rahulsirohi21633 жыл бұрын

    awesome & simple explanation .. thanks

  • @ITkFunde

    @ITkFunde

    2 жыл бұрын

    Thanks Rahul ☺️🙏

  • @manishbajaj4693
    @manishbajaj46933 жыл бұрын

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

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thank you Manish ☺️🙏

  • @santoshsingh-nt2bb
    @santoshsingh-nt2bb3 жыл бұрын

    Your effort is appreciable on the content of Data Vault

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thanks Santosh

  • @samanthapikus3178
    @samanthapikus31784 жыл бұрын

    Wow!!! Excellent Material and well explained!

  • @ITkFunde

    @ITkFunde

    4 жыл бұрын

    Thanks Samantha for this encouraging feedback !!!

  • @shahajiudar9386
    @shahajiudar93863 жыл бұрын

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

  • @sudippandit3943
    @sudippandit39433 жыл бұрын

    perfect! Thank you bro!!

  • @Ayuk1
    @Ayuk13 жыл бұрын

    Very very insightful. Thank you

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thanks Mate

  • @jeromeugaditano
    @jeromeugaditano3 жыл бұрын

    great explanation. learned a lot! Keep it up

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thanks Jerome !!

  • @altafpeerzade9609
    @altafpeerzade96092 жыл бұрын

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

  • @DesiAngryYoungMan
    @DesiAngryYoungMan3 жыл бұрын

    Very useful, short and succinct.

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thanks

  • @KVDBHRZNS
    @KVDBHRZNS3 жыл бұрын

    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

    @kaanchii123

    Жыл бұрын

    Is this the most common method these days?

  • @asishjoshi5774
    @asishjoshi5774 Жыл бұрын

    nice.. simple n good explanation! Thanks!

  • @rajendrathorati5156
    @rajendrathorati51564 жыл бұрын

    Well done. Thanks for posting..

  • @ITkFunde

    @ITkFunde

    4 жыл бұрын

    thanks Rajendra

  • @sagarmorakhia
    @sagarmorakhia Жыл бұрын

    Very well explained. Thanks!

  • @juliekell9454
    @juliekell9454 Жыл бұрын

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

  • @phaninany
    @phaninany4 жыл бұрын

    Very nice explanation !! Thoroughly Enjoyed it.

  • @ITkFunde

    @ITkFunde

    4 жыл бұрын

    Thanks Phani !!

  • @ngocloile6641
    @ngocloile66413 жыл бұрын

    really easy for understanding, tks you bro!

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thanks

  • @ravinderjeetsingh4345
    @ravinderjeetsingh43452 ай бұрын

    Explained brilliantly...

  • @shrutipatil7544
    @shrutipatil75443 жыл бұрын

    Thank you! Really Helpful

  • @jagratimodi7608
    @jagratimodi76082 жыл бұрын

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

  • @prabhureddy548
    @prabhureddy5482 жыл бұрын

    Wonderful video. Thank you so much 😊

  • @ITkFunde

    @ITkFunde

    2 жыл бұрын

    Thanks Prabhu ☺️

  • @krepko7
    @krepko74 жыл бұрын

    Thank you. Your explanation helped a lot.

  • @ITkFunde

    @ITkFunde

    4 жыл бұрын

    thanks a lot !!!

  • @balajirajagopalan3022
    @balajirajagopalan30222 жыл бұрын

    Awesome and concise explanation, thank you so much.

  • @ITkFunde

    @ITkFunde

    2 жыл бұрын

    Thanks Balaji ☺️🙏

  • @jawa4763
    @jawa47634 жыл бұрын

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

  • @ITkFunde

    @ITkFunde

    4 жыл бұрын

    Thank you Jawa !!

  • @vanithamurugesan3046
    @vanithamurugesan30463 жыл бұрын

    Great explanation..thank you soooo much

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thanks Vanitha 🙏☺️

  • @flavb83music
    @flavb83music3 жыл бұрын

    Great explanations. Thanks.

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thanks

  • @rmishra66
    @rmishra662 жыл бұрын

    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

    @ITkFunde

    2 жыл бұрын

    Thanks Rajesh ☺️🙏

  • @wayneyellow5843
    @wayneyellow58432 жыл бұрын

    Nice video, very well explained. Thank you!

  • @vigneshmanoharan2310
    @vigneshmanoharan23103 жыл бұрын

    Very nicely explained.. thanks much!

  • @ITkFunde

    @ITkFunde

    3 жыл бұрын

    Thanks Vignesh

  • @pio024
    @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

    @ITkFunde

    Жыл бұрын

    Thanks Behroz

  • @HomelessOnline
    @HomelessOnline Жыл бұрын

    Great explanation, I only had to watch it once!

  • @hareeshgunda8371
    @hareeshgunda83712 жыл бұрын

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

  • @paltube11
    @paltube112 ай бұрын

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

  • @spideroriol
    @spideroriol4 жыл бұрын

    Thank a Lot !!! Perfect

  • @ITkFunde

    @ITkFunde

    4 жыл бұрын

    thanks buddy!!!

Келесі