Certified Data Vault Data Modeling (CDVDM)

EXCLUSIVE GENESEE ACADEMY SEMINAR

Learn Data Vault modelling with the most effective, popular and proven course Certified Data Vault Data Modeler (CDVDM) by Genesee Academy.

The unique and internationally recognized Certified Data Vault Data Modeler (CDVDM) was introduced in 2007* by Genesee Academy and guarantiesthree interactive course days with new material, among which:

Big Data modeling, revised UOW, Metrics Overlay, Ensemble Modeling, updated BK design, Hash Key options, new Raw/BDV materials, and new cases.

* Since 2009, Connected Data Academy takes care of the certification in the Netherlands and Belgium as full-fledged partner of  Genesee Academy.

 

Duration:
3 days (On-Site / Live-on-Line)
+ 30 E-Learning lessons (4-10 hours)
+ online re-cap session (3 hours)
+ online exam (2-3 hours)

Costs:
€ 2.850,00 excl. VAT (on-line)
€ 3.275,00 excl. VAT (on-site)

Participants:
6-25

Cluster:
Data Modeling

Planning:
Oct 10,11,12 ’22 – Online
Nov 9,10,11 ’22 – Rotterdam NL
Nov 23,24,25 ’22 – Online

General information

An architecture based on Data Vault offers a unique solution, focused on data-integration by and in the whole organisation. The key to success for Data Vault lies in the flexible embeddedness of the company processes. Strict compliance with the fundamental rules of the concept guarantees a solid base for your datawarehouse. Data Vault offers the opportunity to realise flexible and cost effective datawarehouses in a short period of time

Through a combination of on-line training and five intensive half-day on-site trainings you will receive answers to all your questions regarding Data Vault. The seminar will be rounded off with an exam which enables you to become ‘Certified Data Vault Data Modeler’.

E-Learning / Self Training
The on-line training will be offered approximately two weeks before the start of the classical training. This part consists of 30 lessons via video streams and e-learning which enables you to study the basis Data Vault in your own tempo.
In the on-line program a case will be broadcast as preparation. This case will be discussed in the classical part. To be well-prepared and able to effectively take part in the on-site trainings you will have to have followed all on-line classes and elaborated on the case!

Classical Training
During the three classroom days  the learning in the on-line section and the self-worked case will be recalles. Furtheron we will discuss new cases and labs with the design, agreements and underlying principles of modelling according to Data Vault.

The course days are divided as follows: 35% class, 40% In-Depth labs & workshops and 25% discussions. By being intensively occupied with cases yourself, you will quickly be able to make the studied subject matter your own. Goal is to not only prepare yourself as well as possible for the exam, but also to learn the deeper backgrounds of Data Vault and to get ready for practice. The design of this training is therefore entirely in the focus of interactive and collaborative work. Live-on-line performances are also like being in a training room with your fellow students.

On-Line in-depth course
To broaden your knowledge, you have the possibility to follow additional and broadening modules via the e-learning program of Genesee Academy, until two weeks after the seminar.

On-Line Exam & Certification
The course will be closed with an exam that allows you to become ‘Certified Data Vault Data Modeler’. A unique opportunity to enhance your distinctive professional value! The exam tests in 4 sections you gained knowledge on the geed of Data Vault and Ensemble Modeling and is written in English. The assessment will take place on ideas and concepts rather THAN on grammar or spelling.

At the end of the training days, participants will receive different exam dates with the option to choose a suitable date. Before the exam’s taken, there is another re-cap session that provides an additional set of videos and allows you to ask questions.

To broaden your knowledge, you have the possibility to follow additional and broadening modules via the e-learning program of Genesee Academy, until two weeks after the seminar.

The classes, training material and the exam are all in English.

Your results after the seminar:

  • You understand all ins and outs of Data Vault, including the application of Big Data surroundings
  • You are able to put all principles into practice
  • You are fully prepared for the Certified Data Vault Data Modeler exam
  • You have done the exam on-site; you receive the results within four weeks

The book “Modeling the Agile Data Warehouse with Data Vault” by Hans Hultgren is part of the course and will be awarded after the exam.

Target group
Data Architects, BI and/or IT architects, BICC team leaders, Business analysts, information analysts, data integration designers and consultants, ETL designers, project managers, database administrators and architects who are involved with Datawarehouse surroundings.

Desired prior knowledge
Solid knowledge of Datawarehousing and some experience in the disciplines relevant for this seminar. Upon arrival in the class, participants must have *working knowledge* of Data Vault principles and standards as defined in the E-learning lessons.

 

Program

The CDVDM seminar consist of three components:

  1. 8-10 hours of self-study via online video classes (e-learning).
  2. 3 days of in-class lessons lead by a Genesee Academy Certified Instructor (on-site / live-on-line)
  3. Certification exam (2,5 hours on-line exam in English).

     

AD 1: ON-LINE / SELF STUDY

Foundational Concepts – business overview

  • Segment 1: Architecture Constructs
  • Segment 2: Definition of the Data Vault
  • Segment 3: Issues and Evolution in Data Modeling
  • Segment 4: Scalability, Agility, Pros and Cons
  • Segment 5: Operational Data Warehousing
  • Segment 6: Business Case Studies
  • Segment 7: Common Business Process Modeling Errors
  • Segment 8: Classified Information Systems
  • Segment 9: Business Process Agility in I.T.

Foundational Concepts – technical overview

Segment 1: Hubs & Lab on Hub Discovery

  • Hub Definition
  • Business Keys
  • Composite Business Keys
  • Real-time Arrival of Keys

Segment 2: Links & Lab on Link Discovery

  • Link Definition
  • Link to Link
  • Links and Role Playing mistakes

Segment 3: Satellites & Labs on Satellite Discovery

  • Satellite Definition
  • Type of Information
  • Rate Of Change
  • Splitting/Consolidating Satellites

Key Structures, Elements in Tables, Common Table Structures

Segment 4: Point in Time/Bridge Tables, User Defined/Record Sources

  • Point in Time Structures
  • Bridge Tables
  • Reference Structures
  • Report Collections
  • Net Change and Tracking data across loads
  • Aggregation Points

Segment 5: User Grouping Sets

  • Excel Sources
  • Flat File Sources
  • Defining User Data and processing into the DV

Segment 6: EDW Processing

  • Business Processing Overview
  • Tying the business to the technical data models
  • The business process of defining a Data Vault

Segment 7: Conversion to A Data Vault

  • Converting from Normalized format to a Data Vault
  • Converting a Dimension to a Data Vault
  • Converting from a Report to a Data Vault

 

AD 2: IN CLASS TRAINNG 

Loading and Querying processes within a DV

Segment 8: Golden Rules, Loading Constructs, math behind the Load Cycles

  • Golden Rule of the Data Vault
  • Basic Mathematics behind the loading processes
  • Paradigm Shift in executing Business Logic
  • Agility of the Loading Processes
  • Scalability of through Architecture
  • Hub, Link, Satellite Load Process Flows

Segment 9: Loading Data Delivery Mechanisms

  • Loading Dimensions
  • Loading Facts
  • Loading Error Marts
  • Loading Report Collections

Segment 10: Scalability of Loading Processes

  • Issues with the current loading paradigm
  • Shifting the paradigm for Compliance reasons
  • Delta Processing and Set Logic
  • What to do about “bad data”

Segment 11: What Happens when you Break the Data Vault Rules?

  • Role Playing Links
  • Mistakes with the Load Dates

Segment 12: Business Constructs

  • SLA’s needed for changes, and sign-off
  • Default Values versus Error Codes
  • Zero Rows populated in the Data Vault
  • Views in the Data Vault

Segment 13: Strategies for Managing the Data Vault

  • Backup and Restore
  • Suggested Topic Areas
  • Suggested Satellites
  • Items To Note

Exceptions & Brainstorm

Near the end of the seminar the inevitable “exceptions to the rule” will be discussed as well as other issues and specific challenges that have come up during the seminar. The seminar is concluded with a Data Vault recap, a brief time to prepare for the test and…the written exam.

Free on-line in-depth modules

After the seminar you are able to extend your knowledge even further by accessing for two weeks additional in-depth on-line lessons through the e-learning program of Genesee Academy.

 

AD 3: CERTIFICATION EXAM

The course will be completed, on a day to be determined (15.00 – 18.00 hours), with an online protored exam that allows you to become ‘Certified Data Vault Data Modeler’. The certification is a closed book exam and lasts 2,5 hours. The questions are in English and can be answered in English or Dutch.

Within 4 to 6 weeks after the seminar you will receive the exam results. With a positive result you will also receive an official certificate of Genesee Academy. A free of charge resit exam is possible in consultation.

 

Our courses are conducted by experienced teachers who have gained experience in consultancy practice.

Teachers

  • Antoine Stelma
  • Hans Hultgren
  • Remco Broekmans

 

 

connecteddataacedemy is een Authorised Training Partner van Genesee Academy (GA).

Genesee Academy is the certifying entity for the Data Vault modeling approach. With over 600 Data Vault certifications issued to date including the Certified Data Vault Data Modeler (CDVDM) and the Certified Data Vault. Genesee Academy provides world class DWBI training from the Enterprise Data Warehouse (EDW) to Business Intelligence with the latest on multi-structured data, enterprise integration, big data, information visualization, DW2.0 with Bill Inmon, hyper-agility and Agile Data Warehousing.

Certified Data Vault Modeler is a GA seminar: program, online classes and course material are owned by GA.

Registration form Certified Data Vault Data Modeling (CDVDM)

PARTICIPANT

BILLING ADDRESS

REMARKS

Terms

3 + 13 =

 

*Terms

Cancellation by Connected Data Academy, represented by Connected Data Group B.V.: Connected Data Group will make every effort to allow training to take place but reserves the right to cancel training at any time. Connected Data Group is not responsible for costs incurred by the client as a result of the rescheduling or cancellation of the training. If a training course has been canceled by Connected Data Group, the client will be given the option to transfer the booking to another training course or to have the already paid course fee refunded.

Cancellation by the client: Cancellation is possible up to 5 working days before the start of the training, after which the full registration fee is due. In case of cancellation up to 20 working days before the start, no costs will be charged, in all other cases 50% of the registration fee is due. Cancellation must always be made in writing. The student has a 7-day cooling-off period after signing and can cancel without costs, unless the training has not been planned during this period.

Settlement and invoicing: Unless otherwise agreed and stated as a payment condition, invoicing of the total amount for the training takes place after booking. Payment of the full invoice amount must be made no later than 15 working days before the start of the training. Connected Data Group reserves the right to refuse participation in the training if the invoice is not paid on time. By submitting this form, you order the relevant training. There is a cooling-off period of fourteen days
For the other conditions, Connected Data Group applies the general conditions of FENIT (Filed with the Registry of the District Court in The Hague on June 3, 2003 under number 60/2003)

Printing and typing errors reserved.

Connected Data Academy | www.connecteddataacademy.com

ALSO IN-COMPANY

We offer a (made-to-measure) in-company training if there are multiple colleagues with the same learning objectives.