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

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
  • 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)

Eventdatum: 13.09.21 – 15.09.21

Eventort: Online