Data Vault 2.0 Boot Camp and Certification (English) - Seminar / Kurs von Scalefree International GmbH

We care about the health of our participants and trainers.Therefore this training is very exclusive with only a limited number of participants. There is an excellent hygiene concept throughout the hotel and the event room.

Our trainers are fully vaccinated.

***************************************************

The Data Vault Boot Camp is an introductory and intermediate class that takes you through the why, what and how of Data Vault 2.0. It includes the coverage of business justifications, covering a host of new topics, above and beyond just Data Vault modeling.

This class covers modeling, methodology, architecture, and implementation – a true system of Business Intelligence scope, which turns thestudent into a practitioner. Despite the current information available in the book “Building a Scalable Data Warehouse with Data Vault 2.0”, the boot camp course addresses more in-depth analysis of the concepts behind DataVault 2.0. In addition, it also contains a myriad of topics not covered before, including best practices.

The course provides ETL design paradigms, working templates (both conceptual and SQL) and best practices for successful Data Vault 2.0 implementation. Among others this class provides an in-depth explanation on how to upgrade your DV1.0 system to DV2.0

AGENDA

Computer based training, online only (preparation videos for live 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

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)

• 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