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:

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

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
  • Distribution and Co-Location
  • Queries in Hadoop MPP / Hive
  • Point-in-Time and Bridge Tables (Dashboards, analytical, virtual marts)
  • Group Workshop

Agenda 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

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