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)
- Lifetime 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
- Data Vault 2.0 Overview / Review / Introduction
- Hadoop Overview (Cursory look)
- SMP vs MPP
- Data Vault at Lockheed Martin and Commonwealth Bank
- Business Vault
- Value of Data as an Asset
- Business Processes to Business Keys
- Hashing and Sequences
- Common Terminology
- Core DV Structures
DAY 2
- Dependent Child (Data Modeling)
- Driving Key
- Link to Link Denormalization
- Link Unit Of Work
- Exploration Links
- Applying Links
- Non-Historized Link
- Satellites in Depth
- Reference Data
- Distribution and Co-Location
- Queries in Hadoop MPP / Hive
- Point-in-Time and Bridge Tables (Dashboards, analytical, virtual marts)
- Group Workshop
DAY 3
- Workshop Review
- Data Vault in a Data Lake
- Record Source Tracking
- Applying Set Logic
- ELT / ETL Performance Tuning
- Loading Architecture
- Column Comparison and Hash Differences
- Zero Key Concept
- Staging Loads
- DV2.0 Loading Templates / Standards
- End-Dating Satellite Templates
- Real-Time Loading
- Dealing with Corrupted Data
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”.
