Data Vault Data Modeler (CDVDM) and Certification (3 days)


Welcome to the Certified Data Vault Data Modeler CDVDM seminar!

This course will guide you through the Data Vault modeling approach from modeling constructs and patterns to applying data vault principles in your DWBI program. This course covers also loading paradigms, architectures, and how to develop an effective overall Data Vault Data Warehouse program.

Since Data Vault may be new for many of you, this course also includes a summary of the benefits of using data vault techniques.

The CDVDM course is a three (3) day intensive classroom based course. The course consists of five core components plus the certification exam

Target audience:

The target audience for this course includes data warehousing and business intelligence professionals, data modelers, data architects, model managers, data warehouse DBAs, data scientists, and ETL professionals.

Because data vault modeling concepts are closely aligned with the business aspects of DWBI programs our target audience also includes program managers, business analysts, information modelers, information architects, and other BICC professionals.


This course does not require a computer or other device. Students should be prepared to take notes. All materials, work books, case books and exercises will be provided.

There are no pre-requisites for this course. It is helpful if you bring any specific topics that you are interested in concerning data vault. It can also be useful if you have the time for web research on the topic prior to class. Depending on the course section, the first day of class may be preceded by 2 weeks of online on-demand video lessons.

Hans Hultgren's new book "Modeling the Agile Data Warehouse with Data Vault" is included in the CDVDM course price.

Day One
  • 08:30 Welcome & Introductions
  • 09:00 Data Warehouse Modeling
  • 09:30 Ensemble Modeling
  • 10:00 Data Vault Core Constructs
  • 10:20 Comparing Modeling Methods
  • 10:30 Break
  • 10:45 Tracking History
  • 10:55 Information Modeling
  • 11:15 Data Vault Modeling Process
  • 11:15 First Small Group Case Exercise
  • 12:00 Lunch
  • 13:00 Continue First Case
  • 13:45 Class Discussion & Groups Present
  • 14:15 Link Design & Exceptions
  • 14:30 SAL & HAL
  • 14:40 Business Key Topics
  • 15:00 Disconnected & Reference Tables
  • 15:15 Break
  • 15:30 Unit of Work
  • 16:00 Second Small Group Case Exercise
  • 17:00 Wrap up for the Day
  • 08:30 Q&A from Day One
  • 09:15 Continue Second Case
  • 10:30 Break
  • 10:45 Class Discussion & Groups Present
  • 11:20 Satellite Design & Exceptions
  • 11:35 Expanded UOW & Keyed Instance
  • 11:50 Modeling Address
  • 12:00 Lunch
  • 13:00 Bike Shop Example
  • 13:20 Applying the DV Ensemble
  • 13:35 Standard and Expanded Attributes
  • 13:50 Managing Dates / Bi-temporal Data
  • 14:00 Third Small Group Case Exercise
  • 15:15 Break
  • 15:30 Continue Third Case
  • 15:45 Class Discussion & Groups Present
  • 16:20 Raw & BDV Layers
  • 16:30 Hyper Forms and Unstructured
  • 16:40 SID versus Hash
  • 16:50 Virtualization
  • 17:00 Wrap up for the Day
  • 08:30 Q& A from Day Two
  • 09:00 Data Vault & Agility
  • 09:30 Data Vault & Big Data
  • 10:00 Architecture & Layers
  • 10:20 Helpful Tables: Bridge & PIT
  • 10:30 Break
  • 10:45 Loading Patterns
  • 11:30 Class Discussion
  • 11:45 Recap for Exam
  • 12:00 Lunch
  • 13:00 Recap & Discussions
  • 13:30 CDVDM EXAM
  • 16:30 Conclusion

General information:

This course will be offered as a joint event by Affecto Academy and Genesee Academy.


The course will be taught in English and the course material is written in English.

Course price includes course material and catering (coffees, lunch) daily.

If there are three (3) or more participants from the same company, participants will receive ~10% discount. (Finland)

Due to the online on-demand training, the course will be invoiced two weeks prior to the class training.

Affecto reserves the right to make changes to courses and schedules. Affecto may cancel a course if there are less than six (6) participants. Affecto is not responsible for any expenses related to course cancellation.

NOTE! Due to online on demand training starting two weeks prior to the course, last recommended day for registration is three weeks prior to actual courses days.

Kurssi pidetään Affecto Academyn koulutustiloissa osoitteessa Atomitie 2, 00370 Helsinki. Kurssipäivä alkaa klo 9 ja päättyy klo 16:30

Hintoihin lisätään arvonlisävero.

Lisätietoja: Academy Finland

The course will be held Affecto Academy training facility at Stortorvet 10 (GlasMagasinet), Oslo. The course day begins at 9am and end at 4pm.

For more information, please contact Academy Norway

Duration: 3 day
Price: 2795.00 €

24.10.2018, Registration closed

Cancellation and payment terms
Request offer
Good to know