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

Schedule

Mon Sep 23 2024 at 09:00 am to Thu Sep 26 2024 at 04:30 pm

UTC+03:00

Location

HUONE Kamppi | Kokous- ja juhlatilat | Helsinki, ES

Advertisement
This 3-day intensive course will introduce students to the concepts and standards behind the Data Vault 2.0 System of Business Intelligence.
About this Event

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.


Event Photos
Instructor-led Course Prerequisites

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


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

NEW!! Self-Paced, Hands-On Modeling Video with Downloadable DDL and ELT/ETL Scripts
  • Walk-thru / Follow Along, Hands-On Videos taught by Dan Linstedt
  • Downloadable DDL
  • Downloadable SQL Scripts for Data Loading
  • Sample Data for Ingest

Instructor-led Course
Day 1

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

Day 2

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

Day 3

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.

Advertisement

Where is it happening?

HUONE Kamppi | Kokous- ja juhlatilat, Malminkatu 30, Helsinki, Finland

Event Location & Nearby Stays:

Tickets

USD 3100.00

DataRebels LLC, a Data Vault 2.0 CDVP2 Authorized Training Partner

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

It's more fun with friends. Share with friends

Discover More Events in Helsinki

Sacred & Saariaho
Tue Oct 01 2024 at 07:00 pm Sacred & Saariaho

Musiikkitalo, Concert hall

MUSIC
W Love Games Conference 2024
Thu Oct 03 2024 at 10:00 am W Love Games Conference 2024

Helsinki Central Library Oodi

BUSINESS CONFERENCES
Max Raabe & Palast Orchester (DE): September Song, Kulttuuritalo, Helsinki 3.\u20134.10.2024
Thu Oct 03 2024 at 06:30 pm Max Raabe & Palast Orchester (DE): September Song, Kulttuuritalo, Helsinki 3.–4.10.2024

Kulttuuritalo (Helsinki)

MUSIC ART
Cruise to the Stockholm meetup - Moved to the autumn
Fri Oct 04 2024 at 12:00 am Cruise to the Stockholm meetup - Moved to the autumn

Viking Line Suomi

MEETUPS
Conquer Overthinking And Make Lasting Changes
Thu Jul 08 2021 at 11:00 am Conquer Overthinking And Make Lasting Changes

Helsinki Online

WORKSHOPS
Croquis Classes
Wed Feb 28 2024 at 05:30 pm Croquis Classes

Myymälä 2 osk.

WORKSHOPS ART
The Art of Happy Learning Practices - Course for Teachers
Sun May 19 2024 at 09:00 am The Art of Happy Learning Practices - Course for Teachers

Helsinki

ART WORKSHOPS
Creatives Meetup
Tue May 21 2024 at 10:00 am Creatives Meetup

G Livelab

MEETUPS WORKSHOPS
Creatives Meetup
Tue May 21 2024 at 10:00 am Creatives Meetup

Yrjönkatu 3, FI-00120 Helsinki, Suomi

MEETUPS ART
CREATIVE IDEAS FOR SOCIAL MEDIA PLATFORMS
Tue May 21 2024 at 03:00 pm CREATIVE IDEAS FOR SOCIAL MEDIA PLATFORMS

Globe Art Point.

WORKSHOPS ART
Finnbrit Pudding Club
Tue May 21 2024 at 05:30 pm Finnbrit Pudding Club

Finnbrit

WORKSHOPS
S-Dance Spring season 2024
Tue May 21 2024 at 06:00 pm S-Dance Spring season 2024

S-Dance

WORKSHOPS
Argentine Tango Beginners - Last course of the season!
Tue May 21 2024 at 06:00 pm Argentine Tango Beginners - Last course of the season!

Sinergia - Movement + Art

WORKSHOPS BUSINESS
Liquid Intuition
Wed May 22 2024 at 12:00 pm Liquid Intuition

Uudenmaankatu 23 F, 00120 Helsinki, Finland

ART EXHIBITIONS
P\u00e4iv\u00e4 Harakassa - A day at Harakka island
Wed May 22 2024 at 01:45 pm Päivä Harakassa - A day at Harakka island

Harakan saari

HEALTH-WELLNESS ART
Afrofusion & Amapiano -kes\u00e4tunnit
Wed May 22 2024 at 07:00 pm Afrofusion & Amapiano -kesätunnit

Viba

ENTERTAINMENT WORKSHOPS
Ancestral workshop | Esivanhemmat-ty\u00f6paja
Thu May 23 2024 at 05:00 pm Ancestral workshop | Esivanhemmat-työpaja

Helsinki Marjaniemi

WORKSHOPS HEALTH-WELLNESS
Afterwork with MAM
Thu May 23 2024 at 05:30 pm Afterwork with MAM

Pjazza

WORKSHOPS
Practical Guide to Meditation: How to Begin and Maintain Your Journey
Thu May 23 2024 at 06:00 pm Practical Guide to Meditation: How to Begin and Maintain Your Journey

Lapinlahden Lähde

HEALTH-WELLNESS MEDITATION
Viihdeorkesteri Haavekuva ja T\u00f6\u00f6l\u00f6 Brass: Viihdett\u00e4 ilmassa
Thu May 23 2024 at 07:00 pm Viihdeorkesteri Haavekuva ja Töölö Brass: Viihdettä ilmassa

Helsinginkatu 26, FI-00530 Helsinki, Suomi

WORKSHOPS

What's Happening Next in Helsinki?

Discover Helsinki Events