Data Vault 2.0 Boot Camp

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.

Dates

JANUARY 18 to 20

English

live online

FEBRUARY 8 to 10

English

live online

MARCH 15 to 17

English

live online

APRIL 19 to 21

English

live online

MAY 17 to 19

German

live online

June 7 to 9

English

live online

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

Get the Data Vault 2.0 Boot Camp Whitepaper

WHITEPAPER

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”.

Trainer

Michael has more than 20 years of experience in Information Technology. He has consulted for a number of clients in the automotive, insurance, banking, and non-profit fields. His work includes research on massively parallel processing (MPP) systems for building artificial intelligence (AI) systems for the analysis of unstructured data.

Michael OlschimkeCEO - Founder - Instructor

Marc is working in Business Intelligence and Enterprise Data Warehousing (EDW) with a focus on data architecture and Data Vault modeling. Since 2016, he has been advising renowned companies in various industries for Scalefree International.

Marc FingerInstructor - Consultant

Volker is an experienced BI Project Manager and Business Analyst with a broad overview of cloud and on-premise data architecture as well as strong analytical skills. In his over 20 years within the field, he has successfully advised companies in a wide range of industries.

Volker NürnbergInstructor - Coach