Modeling Data Warehouse with Data Vault 2.0
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
Requirements
- Familiar with the basic concept of Database/RDBMS
- Understanding the SQL fundamentals
Description
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!
Who this course is for:
- Anyone wants to learn data warehousing concepts with Data Vault
Instructor
![Esra Ekiz](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 1,808 Reviews
- 9,239 Students
- 2 Courses
Total 9+ years experience, as BI Senior Consultant and Project Manager in Business Intelligence projects including EIM and IDD technologies. Consultant experience containing data warehouse concepts ,reporting ,dashboard ,universe design, etl development,HANA modelling and I have participated in 100 + projects and worked with 50+ world wide known customers such as Mercedes Benz ,Coca Cola,Roche,Vodafone,British American Tobacco,Fritolay, Cigna Insurance ,EFES PILSEN etc... Having certificate on SAP HANA modelling & Administration and BI Platforms. Trainer experience including 50 + class trainings with 500 + students in different companies such as Arçelik,SuperOnline,İgdaş,Fritolay,Roche,Mercedes Benz,The Central Bank of the TRNC,İş Bank,Roche,Philsa etc...