Our Data Vault CDVP2® Boot Camp class provides an introduction to the Data Vault 2.0 System of Business Intelligence as well as intermediate topics. This course covers the business justification for the DV 2.0 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.
Updated my knowledge 🙂 Thank you Cindi Meyersohn for the training
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!
Thank you Cindi Meyersohn for your training and guidance. Thank you Michael Hiteand Veronika Durgin for sponsoring and support. #certified #challenging #datavault
CDVP2 = Certified Data Vault 2.0 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.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, 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.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
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.0 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.0 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.0 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.