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.