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) - [ Ссылка ]
Let's understand containers | 5 simple steps to create a docker container - [ Ссылка ]
Kubernetes crash course: In less than 15 minutes- [ Ссылка ]

***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 YOUTUBER 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 -
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]

***Social Links***
Facebook - [ Ссылка ]
Linkedin - [ Ссылка ]
Twitter - [ Ссылка ]
Blog - [ Ссылка ]
Instagram -[ Ссылка ]

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

свернуть