What you'll learn:
- Get understanding about Traditional Data warehouse concepts
- Learn fundamentals of the Data Vault modeling approach
- Understand principles of Agile Project Management in Data Vault 2.0
- Learn Big Data Platforms Integration with Data Vault 2.0
- Understand Data Vault architecture and layers
- Learn Business and Information Vault
- Understand advanced data modeling techniques
- Design a Data Vault practical scenario from scratch
- Convert 3NF & Dimensional Model to Data Vault
- Understand Dimensional model principles in Data Vault
Data Vault is an innovative modeling technique invented by Dan Linstedt to simplify data integration from multiple sources, offers auditability and design flexibility to cope with data from the heterogeneous information systems which supports most business demands today
It is designed to deliver an Enterprise Data Warehouse while solving many of the drawbacks of the 3NF (Inmon) and Dimensional Modelling(Kimball).
In this course, you will
Learn the basics of Data Modelling to become familiar with core concepts
Understand the fundamentals of traditional Data Warehouse approaches
Learn many of today’s Data Warehousing problems and issues with 3NF or Star Schema
Understand how Data Vault addresses these challenges and provide an innovative approach
Learn the fundamentals of the Data Vault modeling approach from core concepts to advanced, and from architecture to key benefits
Learn how to effectively model Hubs, Links and Satellites
Understand DV Modeling constructs in detail
Understand the different architectural and modeling layers of DV 2.0
Learn Business Vault, Information Vault and significance of Dimensional Layer
Understand where to use 3NF, Dimensional Model or Data Vault
Understand loading patterns and architecture
Learn how to handle schema and grain changes on the Data Vault model
Learn why Agile Methodology is important for scalable Data Warehouses
Get familiar with Big Data Terminologies along with Data Vault Methodology
It also contains a hands-on case study to get participants familiar with the principles and concepts
Footnote: Automatically created subtitles are corrected!
