Module 1: Computer based training
- 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
Module 2: What is Data Vault 2.0?
- Business Vault
- Information Marts defined
- Data as an Asset
- Business Processes & Keys
- Common Terminology
Module 3: Hashing and Sequences
- 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
Module 4: 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)
Module 5: DV 101 BASELINE HANDS-ON, ONLINE ONLY
- Hands-on video course
- Standard model for PostGreSQL & Snowflake for Download
- Introductory class on how to build something
- Specially designed to illustrate all possible objects that we construct in Data Vault