Data Vault 2.0 Boot Camp and Certification - Hannover
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
- 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
- Common Terminology
- DAY 2
- 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
- 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)