OVERVIEW
The 1-day introductory course, focuses on getting your team started in Data Vault 2.0 Modeling. It covers the basics and functions of the Data Vault 2.0 concept. It also contains a hands-on case study to help participants become familiar with the principles and concepts.
The goal of this class is to guide students towards understanding the consequences of the different Data Vault 2.0 modeling options when loading data into the enterprise data warehouse, as well as how to derive useful information for the business. Note that this class, or demonstrable proficiency in Data Vault 2.0 modeling, is a prerequisite for the private certification as a Certified Data Vault 2.0 Practitioner.
HIGHLIGHTS
This class is a good preparation for the Data Vault 2.0 Boot Camp where you can receive a private certification to a Certified Data Vault 2.0 Practitioner (CDVP2™). Further, this modeling class requires a basic understanding of Data Vault 2.0 modeling concepts.
Major topics
This day gives an overview of the benefits of the different modeling options.
- Data Vault 2.0 Modeling constructs: Hubs, Links and Satellites
- Modeling standards
- Common Data Vault 2.0 Attributes
- Effectivity
- Status tracking
- Delete tracking
- Modeling for audit trails
- How to change grain of the data
- Detecting Structure Changes
- Business Vault Examples
- Historical Vault Modeling
- How to integrate changes
- Table Overloading
- Splitting/Merging
- Business Keys in Satellites
- Normalization in staging areas
- Determining Business Key Overlap/Overloading
- Dimensional Modeling (from DV)
Who is this class for?
- Data Architects
- Data Modelers
- DBA’s
Upcoming Trainings 2024
Currently there are no public trainings planned.
If you are interested in a Data Vault 2.0 modeling training, contact us for further information.
Live online trainings
All our Online classes are live and interactive to provide a valuable experience comparable to an on-site training to all our participants.
Inhouse training available
Our inhouse training option allows you to book a training session exclusively for your team. This is a great opportunity to learn together and have discussions with the trainer about internal matters. It fosters teamwork and collaboration, ensuring that your team is on the same page and working towards a common goal. Book our inhouse training and take your team’s skills to the next level!