course
Data Vault Modeling
Implement Data Vault
Description
Business Intelligence developers and architects learn to design and implement a database according to the rules of the Data Vault methodology developed by Dan Linstedt and the architectural patterns for agile data warehousing provided by Hans Hultgren.
You will learn the characteristics of and the philosophy behind the Data Vault, the differences with more traditional modeling techniques and architectures like 3NF and dimensional modeling and how to apply basic and advanced Data Vault modeling techniques within an Enterprise Data Warehouse (EDW) architecture using an business or source driven approach in designing the Data Vault entities: Hubs, Links and Satellites. You will also learn to implement the ETL process for loading the Data Vault, to generate ETL code and the advantages code generation has within the development process. Finally you will learn some best practices for implementing a Data Vault.
Prior Knowledge
Knowledge of relational modeling, design techniques (ERD) and standardisation. Familiar with the concepts of Kimball (dimensional modeling) and Inmon (Corporate Information Factory).
Subjects
- Introduction to Data Vault
- Data Vault Architecture
- Data Vault Modeling Techniques
- Loading a Data Vault
- Data Vault Best Practices
Schedule
All courses can also be conducted within your organization as customized or incompany training.
Our training advisors are happy to help you provide personal advice or find Incompany training within your organization.
Prior knowledge courses
"The instructor was clearly very experienced and had a lot of knowledge about the subject."Mika
-
Hoge waardering
-
Praktijkgerichte trainingen
-
Gecertificeerde trainers
-
Eigen docenten