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
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
Thank you so much, you explained it better than the Data vault guys.
@ITkFunde
2 жыл бұрын
Thanks Nasir means a lot brother 🙏♥️
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 !
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
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 😊🙏
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!
Well done! That includes the editing of the video to make it concise without wasted pauses.
@ITkFunde
Жыл бұрын
Thanks Brad 🙏
I was searching for a proper data vault here I go it's much easy & accessible thanks a ton!
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!
Excellent! Simple, crisp and well explained.
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.
This is a superb introduction to Data Vault. Keep up the amazing work! Cheers!
@ITkFunde
3 жыл бұрын
Thanks Kovid
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
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
It is the best explanation so far to understand basic DW models. Thank you for your effort.
Excellent simplied explanation ! Kudos for all your efforts !
Great explanation and delivered with a lot of good energy! Thank you!
appreciate your efforts , you have explained it in simple language , by giving simle example. thanks a lot. it really helps
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 👍
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
Awesome delivery! Single shot you covered every thing.
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 🙏☺️
Thank you so much for simplified explanation.
@ITkFunde
Сағат бұрын
Thanks Ravi❤️
Great introduction to Data Vault concepts, thank you!!
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.
Thanks a lot for your explanation!!! Clear as Crystal!
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
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 ☺️
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 ☺️🙏
Simply yet brilliantly explained.. I visit this video again and again when I have doubts.. Thanks 👍
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
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.
A really clean and simple explanation on the topic. Totally loved your videos. Keep up the good work!
@ITkFunde
3 жыл бұрын
Thanks Pawan 😊
Congrats for the great presentation laying down the key principles of the data vault architecture in a layman's terms.
Great teaching....Thank you so much for your efforts explaining to us in detail
@ITkFunde
Жыл бұрын
Thanks Subbu
Thanks so much for this. Look forward to more content from you!!🙏🏼🙂
@ITkFunde
3 жыл бұрын
Thanks a lot 🙏🙏☺️
Commenting because you deserve it for the efforts and super clear explanation!
Really well done, I'm bookmarking this!
@ITkFunde
4 жыл бұрын
Thank you Joris for motivating words. It helps !!
Made it easy to grasp key concepts simultaneously working at the same time.
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 .
Very well explained with examples. You have my thumbs-up!
@ITkFunde
2 жыл бұрын
Thanks Rey☺️🙏
Thanks! You have explained the difference so clearly. It was really helpful.
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 :)
Thank you for the concise introduction. Quite easy to understand!
THANK YOU!! You have nicely covered all the important points clearly and beautifully..
Perfect! Thank you very much!
@ITkFunde
3 жыл бұрын
Thanks Raven
You saved me in my client round interview. Thanks a lot. Subscribed and shared ❤️
thanks for the clear explanation
Thank you so much for such detailed explanation!
@ITkFunde
3 жыл бұрын
Thanks
Beautifully explained! Wow! Thank you!
@ITkFunde
2 жыл бұрын
Thanks
Very well explained data vault in 20 mins with easy example. Thanks
Amazing explanation! Thank you very much!
Extremely helpful! Thank you.
Very well explained! Thanks for sharing this video.
So detailed, still explained in very simple way ! You got great teaching skills, not an easy for every one
Thanks for the video, its very clarify and motivate me a lot. The channel won a suscriber from Chile!
Very clear thank you!
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
3 жыл бұрын
Thanks Saravana !
Very clear and very detailed!! Thank you
@ITkFunde
4 жыл бұрын
Thanks Archana :)
Explanation got enlightened as you have narrated with Live example.... I will follow your more videos. Pls. keep it up. Thanks a lot.
@ITkFunde
3 жыл бұрын
Thanks Shariful 🙏☺️
Very well explained. Thank you very much!
Great video , I was looking for this actually . Thank you so much
Excellent presentation. You explained clearly with examples. Thank you for the great work.
@ITkFunde
Жыл бұрын
Glad it was helpful!
Very informative session, complex stuffs explained in very simple way
It was really a nice presentation. Tha k you very much
Thanks for the explanation of the data vault this really made me understand the concept in one go
awesome & simple explanation .. thanks
@ITkFunde
2 жыл бұрын
Thanks Rahul ☺️🙏
Fantastic explanation Sirjee.. one of the best tutorial videos I have come across in KZread. Kudos to you.
@ITkFunde
3 жыл бұрын
Thank you Manish ☺️🙏
Your effort is appreciable on the content of Data Vault
@ITkFunde
3 жыл бұрын
Thanks Santosh
Wow!!! Excellent Material and well explained!
@ITkFunde
4 жыл бұрын
Thanks Samantha for this encouraging feedback !!!
Really nice explanation. This is what I am searching. Thanks a lot !!!
perfect! Thank you bro!!
Very very insightful. Thank you
@ITkFunde
3 жыл бұрын
Thanks Mate
great explanation. learned a lot! Keep it up
@ITkFunde
3 жыл бұрын
Thanks Jerome !!
wonderful explanation to understand clear concept of data vault, thanks for making such video's to understand clearly,,,,,
Very useful, short and succinct.
@ITkFunde
3 жыл бұрын
Thanks
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?
nice.. simple n good explanation! Thanks!
Well done. Thanks for posting..
@ITkFunde
4 жыл бұрын
thanks Rajendra
Very well explained. Thanks!
This was super helpful and very easy to understand. Thank you for making this tutorial
Very nice explanation !! Thoroughly Enjoyed it.
@ITkFunde
4 жыл бұрын
Thanks Phani !!
really easy for understanding, tks you bro!
@ITkFunde
3 жыл бұрын
Thanks
Explained brilliantly...
Thank you! Really Helpful
It was really descriptive. Thanks for such a great video.
Wonderful video. Thank you so much 😊
@ITkFunde
2 жыл бұрын
Thanks Prabhu ☺️
Thank you. Your explanation helped a lot.
@ITkFunde
4 жыл бұрын
thanks a lot !!!
Awesome and concise explanation, thank you so much.
@ITkFunde
2 жыл бұрын
Thanks Balaji ☺️🙏
Wow... Amazing Brief Explanation ! Hats off :)
@ITkFunde
4 жыл бұрын
Thank you Jawa !!
Great explanation..thank you soooo much
@ITkFunde
3 жыл бұрын
Thanks Vanitha 🙏☺️
Great explanations. Thanks.
@ITkFunde
3 жыл бұрын
Thanks
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
2 жыл бұрын
Thanks Rajesh ☺️🙏
Nice video, very well explained. Thank you!
Very nicely explained.. thanks much!
@ITkFunde
3 жыл бұрын
Thanks Vignesh
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
Great explanation, I only had to watch it once!
I hated data in my SAP BI training. Now it makes sense. Thanks
Very informative and well explained. I understand the concept of Data Vault much better now after viewing your video
Thank a Lot !!! Perfect
@ITkFunde
4 жыл бұрын
thanks buddy!!!