Training

Our Data Vault CDVP2® Boot Camp class provides an introduction to the Data Vault 2 System of Business Intelligence as well as intermediate topics. This course covers the business justification for the DV 2 solution and provides a technical overview of the solution’s methodology, architecture, and model – basically the why, what, and how aspects of designing, building, and implementing a DV 2 Enterprise Data Warehouse. Course includes a practicum in hands-on design and discusses ELT/ETL best practices as well as SQL code examples/templates.

GO TO AGENDA

Updated my knowledge.Thank you Cindi Meyersohn for the training
-Miia

I am now officially a Certified Data Vault 2.0 Practitioner! Many thanks to our wonderful CDVP2 course trainer Cindi Meyersohn for making this possible!
-Arla

Thank you Cindi Meyersohn for your training and guidance. Thank you Michael Hiteand Veronika Durgin for sponsoring and support. #certified #challenging #datavault
-Rajesh

Course Agenda

CDVP2 = Certified Data Vault 2 Practitioner Course & Workshop: an intensive course consisting of 90% lecture and roughly 10% hands-on workshop.

The workshop requires students to design an Entity Relationship diagram, in Data Vault 2 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, but see how far they can get in the time allotted.

DataRebels offers this Instructor-led course across multiple day formats of from 3 to 7 days. The content of the 3-day Boot Camp agenda remains the same for extended day courses, however, the hours spent in the classroom per day are reduced. For example, the 4-day course slows the pace down to 7 hours of lecture and devotes the remaining time on Day 4 to the workshop; the 5-dy course breaks the course into five 6 hour days with the fifth day devoted entirely to the workshop.

The practitioner certification test is included as a part of the course. The test is offered privately on-line. The student is granted access to the exam once the course completed and will be given four (4) weeks to complete the exam. We highly recommend studying, as the test is not easy. It is open book, open note. The course includes one free retake should the student not pass the exam on the first attempt.

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.
in 3 or up to 7 days of in-person live training

Note: It is imperative that you watch ALL the videos in the on-line portion of the course prior to the start of your Instructor-led course. Failure to do so will result in the student missing a significant portion of the content and being unable to keep up with the lecture.

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, On-Line Prerequisite Training

What is Data Vault 2?
DV1 Compared to DV2
Issues Faced Today
Data Vault 2 In Business
Managed Self-Service BI
Agile Delivery and DV2 Methodology
Agile Requirements Gathering
Technical Numbering
Roles and Releases
Architecture Components

Note: the Agenda below is based on a 3-day course. Your course agenda may change if it exceeds 3 days.

Agenda Day 1

Data Vault 2 Overview / Review / Introduction
DV2 Logical Data Flow
Business Vault
Information Marts
Value of Data as an Asset
Taxonomies, Ontologies & Business Conceptual Modeling
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 Loading Templates / Standards
Real-Time Loading
Dealing with Corrupted Data

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

• Students are expected to have basic knowledge of the Data Vault 2 model, which is available by reading the book, “Building a Scalable Data Warehouse with Data Vault 2.0”.

1 year of SQL experience
1 years’ 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

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.