Full 3-day live training + 1-day video training
What to expect:
- Practical workshop
- Open discussions
- Original training concept by Dan Linstedt (inventor of Data Vault)
- CDVP2 ™ Certification
view Dates
Overview
- Learning how to use Data Vault and become certified
- Discussing business justifications and technical descriptions of all pillars of Data Vault 2.0
- Exploring the architecture, implementation, methodology, and modeling components of Data Vault 2.0
- Understanding ETL design paradigms – working templates within conceptual and SQL formats
- Developing best practices for successful Data Vault 2.0 implementations
Target Audience
- Project Managers
- IT implementers
- Data Architects
- Business Analysts
- Data Modelers
- ETL programmers
Data Vault Alliance
Enjoy access to the Data Vault Alliance, the world’s only community for all things Data Vault.
Join countless other professionals, authorized trainers and authorized vendors within a community built just for you.
With each booking, receive 90-days of access as well as a crafted learning platform along with a 1-day Introduction Video Class for the Data Vault 2.0 Boot Camp, all made available on the DVA.
Agenda
COMPUTER BASED TRAINING, ON-LINE ONLY
- What is Data Vault 2.0?
- DV1.0 Compared to DV2.0
- Issues Faced Today
- Data Vault 2.0 In Business
- Managed Self-Service BI
- Agile Delivery and DV2.0 Methodology
- Agile Requirements Gathering
- Technical Numbering
- Roles and Releases
- Architecture Components
DAY 1
- What is Data Vault 2.0?Â
- Business Vault
- Information Marts defined
- Data as an Asset
- Business Processes & Keys
DAY 2
- Hashing and Sequences
- Common Terminology
- Core Data Vault Structures
- Dependent ChildÂ
- Driving Key
- Link to Link Denormalization
- Link Unit Of Work
- Exploration Links
- Applying Links
- Non-Historized Link
- Satellites in Depth
- Reference Data
- Point-in-Time and Bridge TablesÂ
- Group Workshop
DAY 3
- Workshop Review
- Tracking Deleted Data
- Applying Set Logic
- ELT / ETL Performance Tuning
- Loading Architecture
- Column Comparison and Hash Differences
- NULL Business Key Concept
- Staging Loads
- DV2.0 Loading Standards
- Real-Time Loading
- Dealing with Corrupted Data
- Q&A (throughout)
Procedure
Preparing for Your Class
In preparation for your booked class, it is a prerequisite to have a basic understanding of Data Vault modeling which can be acquired by reading
“Super Charge Your Data Warehouse”or
“Building a Scalable Data Warehouse with Data Vault 2.0”.
