(4 Days) CDVP2® - Certified Data Vault 2.0 Practitioner- In Person -Finland

ORGANIZER - DataRebels LLC

Instructor: Cindi Meyersohn

What to expect...

The Data Vault CDPV2® Boot Camp class provides an introduction to the Data Vault 2.0 System of Business Intelligence as well as intermediate topics. The 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.

The course includes both a practicum in hands-on design and a separate self-paced, hands on, online Modeling training video delivered by Dan Linstedt himself which provides an end-to-end full cycle build out complete with DDL, optimized SQL scripts, and test data. The course also discusses ELT/ETL best practices and provides SQL code examples/templates.

DataRebels' course provides certification exam preparation, vendor demos, and access to select vendors tools.

DataRebels LLC is a licensed authorized training partner of Data Vault Alliance Holdings, LLC, on the web at:

CDPV2® and other licensed courses are brought to you by our authorized training partners.

The full course agenda can be found here:

As a Data Vault 2.0 Authorized Training Partner, DataRebels LLC, is exclusively partnered with Dan Linstedt to deliver on-premise, instructor-led CDVP2® training to the US Federal government, US Department of Defense, and other government organizations as well as for private sector customers; she provides in-person and streaming/virtual instructor-led training globally.

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

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

• 10 hours of preparatory, computer-based training CBT (included with the paid course). The CBT provides an overview to the primary engineering concepts surrounding the methodology and architecture (People, Process, and Technology) that are foundational to the Data Vault 2.0 System of Business Intelligence. The CBT should be completed prior to attending the 3-day instructor-led Boot Camp.

• 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

• Walk-thru / Follow Along, Hands-On Videos taught by Dan Linstedt
• Downloadable DDL
• Downloadable SQL Scripts for Data Loading
• Sample Data for Ingest

To participate effectively on a Data Vault 2.0 (DV2) implementation, team members need to understand the DV2 foundational concepts so that each member can be actively engaged in the team’s decision-making and progress. The first day of training introduces the importance of the Data Vault 2.0 approach, the methodology and architectural disciplines it envelopes, and how it incorporates and encompasses any number of technologies to deliver the business value sought by the enterprise.

Topics covered

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

On the second day, you will cover more of the architecture and begin to dive into the modeling. This is where all three of the Data Vault Pillars are brought together. The student will begin to follow the thread from the methodology into the architecture and out to the model – comprehending why the standards and rules are paramount to the implementation. The student will also begin to understand how these Pillars ensure a successful system build within a hybrid technological environment, and will be able to put into practice current knowledge gained on Days 1 and 2 during the Group Workshop Exercise on Day 2.

Topics covered

• 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

We open the third day of Boot Camp with each group presenting their solution / approach to the Group Workshop problem. Each team will present and explain their design. During the remainder of day 3, we begin to introduce the student to advanced modeling techniques and variety of performance tuning strategies available in a Data Vault 2.0 solution.

Topics covered

• Workshop Review
• Record Source Tracking
• Applying Set Logic
• ELT / ETL Performance Tuning
• Loading Architecture
• Column Comparison and Hash Differences
• NULL (Zero) Key Concept
• Staging Loads
• DV2.0 Loading Templates / Standards
• Real-Time Loading
• Dealing with Corrupted Data

Certifications

All students that attend all three days of the class will receive a Certification of Attendance from DataRebels for completing the course.

If the Data Vault 2.0 Boot Camp with Certification (CDPV2®) course is purchased ,the price of the course includes one private, on-line Certified Data Vault 2.0 Practitioner exam. The student will be granted access to the on-line exam after completion of the course and will be given two weeks to complete the exam once the course is complete.

Group Pricing

Any one customer that sends eight or more students will receive a 10% discount applied to all of their students.

Cancellation Policy

All student cancellations must be processed through the online enrollment system.

Students who cancel their enrollment 21 or more business days prior to the start of the scheduled training course and who have not been given access to the Day 1 Introductory Videos will be offered enrollment in a future session of the course or a full refund of their tuition, minus any processing fees.

Students who cancel enrollment more than 14, but less than 21 days prior to the start of the class, and who have not been given access to the Day 1 Introductory Videos, will be offered a refund of 50% of their tuition, minus processing fees.

No refunds will be available to students who (a) cancel their enrollment within 14 days of the start of class, or (b) have already been given access to the Day 1 Introductory Videos, or (c) have had the course materials shipped for which DataRebels has a Bill of Shipping, or (d) have had access to download the course material .pdf files, or (e) who do not attend the class.

For online or virtual classes, refunds will not be issued due to technical failures or the student's equipment failures. Students may negotiate with DataRebels to reschedule for a class at a later date should technical or equipment failures cause the student to not be able to access and participate in the course.

Classes may be canceled at DataRebel’s discretion due to inclement weather, insufficient student enrollment, or other unforeseen circumstances. DataRebels will make every effort to cancel classes 21 or more days prior to the scheduled start date.

In the event that DataRebels cancels a scheduled class, students will be offered a full refund of their tuition or enrollment in another scheduled session of the class as long as they have not accessed the Day 1 Introductory Videos.

DataRebels is not liable for travel expenses incurred due to canceled or rescheduled classes.

Host or Publisher DataRebels LLC, a Data Vault 2.0 CDVP2 Authorized Training Partner