CDVP2 Class Agenda

Data Vault 2.0 Boot Camp and Certification

We are happy you are deciding to investigate the Certified Data Vault 2.0 Practitioner (CDVP2) course further. We have provided a full agenda below that demonstrates the main topics the course covers. If you would like a more detailed course agenda, contact us and we will be happy to speak with you about additional details.

The practitioner certification test is included as a part of the course. The test is offered privately on-line, usually four (4) weeks after the class completes. You will need to contact your instructor for further details. We highly recommend studying, as the test is not easy. It is open book, open note.

The Training format is: 1 day of On-line CBT Video based training, 8 hours of run-time divided in to Modules, Modules are broken down in to 15 minute video segments. 3 days of in-person live training

It is imperative that you watch ALL the videos in the on-line portion of the course BEFORE attending the class in person. If you do not, then you will miss a significant portion of the content, and not be able to keep up with the lecture.

Dan Linstedt, Inventor of Data Vault

Overview

CDVP2 = Certified Data Vault 2.0 Practitioner & Workshop class is a three (3) day intensive course consisting of 90% lecture, and 10% hands-on student workshop. The workshop requires students to design an Entity Relationship diagram, in Data Vault 2.0 Style format, annotating their reasoning, their assumptions, and any potential open ended questions they may have. The objective of the workshop is: move the students to execute in an agile time-line, provide hands on knowledge work during class time, and to learn how to think about Data Vault models. The objective is not to have the groups finish a full design.

In addition to the materials listed here, there are some underlying themes that are discussed during the class, these include:

Performance and tuning of large scale systems (those with billions of records / hundreds of billions of records in the data vault, or loading within a 60 minute window)
Agility of the teams, and the ability to execute on vision in timely manners
Quality of build processes
Standards – why they exist, why they are important, and the foundational nature of the standards that cross architecture, methodology, and modeling
Discussion on ways of working – changing the ways teams work together to achieve better outcomes
Use and impact of automation tooling
Tracking and version control over metadata and metadata lineage (built-in governance)

Please note: this is a professional course, as a student, you are expected to have the following experience before enrolling or attending:

1 year of SQL experience
1 year experience of Star Schema or 3NF
1 year of data warehousing or BI experience
Basic understanding of Dev/Test/Production environments
Understanding data preparation concepts
Knowledge of data modeling concepts

Pre-Requisites

Exceptions: Managers, Directors, C-Levels. If you have one of these roles you are welcome to attend to gain an understanding of what Data Vault is, and what it means to your organization.

Objectives

Provide Students with Proper and Consistent Language for repeatable solution builds
Improve BI and Analytics Understanding, along with Big Data, Real-Time and NoSQL platforms
Show students how-to implement in a consistent and automated manner, applying CMMI Level 5, Disciplined Agile Delivery, and generation techniques for maximum capabilities
Allow students to exercise skills in a group workshop environment, where they are asked to draw an Entity Relationship diagram as a team in an agile manner.

Training Format

1 day of On-line CBT Video based training, 8 hours of run-time divided by Modules, divided further in to 15 minute video segments
3 days of in-person live training

Roles that Benefit

The following Business Roles benefit from attending the first 2 hours to the first day of the in-person course, as well as attending the video-based training: *Note: the Scrum/Sprint Leads who are to lead teams in build designs require all days of training, including the CBT intro day.

Business Analyst (technical)
Scrum Master / Project / Sprint / Agile Lead

Program Manager
Technology Directors and Executives

The following roles benefit from attending the full course.

Sprint / Scrum / Project Lead
Data Architect / Information Architect / Data Modeler
Business Subject Matter Expert
Systems Administrator
BI Team Lead
Data Miner / Data Scientist
Big Data / Hadoop Specialists

Data Integration Specialist
Business Process Modeler
Database Administrator
Mainframe / Midrange DBA (Source Systems)
BI Analytics / Dashboard Expert
Messaging Implementation Expert

Computer Based Training, On-Line

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

Agenda Day 1

Data Vault 2.0 Overview / Review / Introduction
DV2 Logical Data Flow
Business Vault
Information Marts
Value of Data as an Asset
Business Processes to Business Keys
Hashing and Sequences
Common Terminology
Core DV Structures

Agenda 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
Point-in-Time and Bridge Tables (Dashboards, analytical, virtual marts)
Group Workshop

Agenda Day 3

Workshop Review
Record Source Tracking
Applying Set Logic
ELT / ETL Performance Tuning
Loading Architecture
Column Comparison and Hash Differences
Handling Null Business Keys
Staging Loads
DV2.0 Loading Templates / Standards
Real-Time Loading
Dealing with Corrupted Data

Strongly Recommended Reading

” Hands-On Examples! ”

It is also recommended that you have a copy of the book: Building A Scalable Data Warehouse With Data Vault 2.0 (available on Amazon.com) prior to attending the course. 

This book provides a valuable resource with deep-dive data sets and hands-on examples to back up the lecture with practical and workable solutions.

Dan Linstedt, Co-Author and Sole Data Vault Inventor