Data Vault in a Day

Data Vault in a Day

A One-day In-depth Overview of Data Vault Modelling

Location: In-company (YOUR COMPANY)
Presented in English by Antoine Stelma

 Learning Objectives

Why do we organise this course on Data Vault and Enterprise Data Warehousing (EDW) ?

Data Vault modelling is quickly becoming the standard approach for modelling the data warehouse. Compared to other popular approaches, Data Vault modelling represents a paradigm shift - a new way of thinking. Realising the full benefits of this approach means embracing this new paradigm in its entirety.

This course is designed to give you a consistent and clear message of the fundamentals of the Data Vault modelling paradigm. It is much more than an introduction: you get a sound and practical overview of the features - in a single day. Because there is so much to say about Data Vault, you also get a lot of exclusive background information, supporting your learning during and after this seminar. The seminar ends with an "assessment exercise" to test your knowledge and understanding of Data Vault.

This course, the background reading material and the assessment test are designed by Hans Hultgren, founder of Genesee Academy and author of the book "Modeling the Agile Data Warehouse with Data Vault (Volume 1)". You get this book free with you participation.

What will you learn in this Data Vault Modelling workshop ?

This course is intended as an initial introduction into the data vault modelling approach. Next to a global introduction, this course covers the modeling components of the data vault - the Hub, Link and Satellite. These components will be illustrated and trained via group exercises. The course ends with an assessment test to see if you have understood the basic theory and practice of Data Vault modelling.

This training is intensive and interactive. During this one-day course we cover:

  • What is Data Vault ?
  • Why do we need it ?
  • What are the major concepts of Data Vault ?
  • How does a Data Vault model look like ?
  • How does it work ?
  • What are core business concepts and enterprisewide business keys ?
  • What are hubs, Links, Satellites, backbone models, ... ?
  • What are the parts that make up data vault ?
  • What are the benefits of using this approach ?
  • What are source-driven and business-driven semantics ?
  • How do we deal with historical data ?
  • How do you apply Data Vault to your own data warehouse program ?

We also discuss the benefits of using this approach and some guidelines as to how we can apply Data Vault modelling to our own data warehouse program. In addition this course covers data warehousing business intelligence considerations that support these techniques as well as some practical modelling topics.

Who should attend this seminar ?

This course is intended for business intelligence and data warehousing professionals seeking a strong introduction to Data Vault modelling. In addition, the course is well suited for those who have heard about Data Vault or are just starting a Data Vault project and who are interested in learning what it means.

This includes but is not limited to:

  • Data and Information Modelers
  • Data and Information Architects
  • Business Analysts
  • Business Intelligence and Data Warehousing managers
  • Designers, project leads and project owners
  • Data Warehousing Database Administrators (DW DBAs)
  • Data Mart designers
  • Integration Experts and ETL Developers
  • Functional Area Representatives
  • ...

Because the data vault concepts are closely aligned to the business, those working on data warehousing and business intelligence from both business and technical perspectives will benefit equally from this course.

 Full Programme

9.30h - 10.00h
Registration and welcome of the participants with coffee/tea and croissants + Networking opportunity

This course, the background reading material and the assessment test are designed by Hans Hultgren, founder of Genesee Academy and author of the book "Modeling the Agile Data Warehouse with Data Vault (Volume 1)". You get this book free with you participation.

Introduction to Data Vault
  • What is Data Vault?
  • When to use it
  • How it differs from other approaches (pros and cons)
  • Why we need it
  • The benefits of this approach
EDW Requirements & a New Paradigm
  • Modelling Agility
  • Unified Decomposition
  • Ensemble Modelling
  • The Core Business Concept
  • The Modelling process
  • Architecture Overview
Hubs, Links and Satellites
  • Data Vault foundation
  • Colors analysis
  • Forming the Backbone
  • Tracking history
  • Attributes
  • Review of a sample Data Vault Model
Coffee/Tea Break
Workbook Exercise 1
  • Workbook exercise 2: explanation and group exercise
  • Discussion
  • Q & A
Hubs and the Core Business Concept
  • Attributes of a hub and their purpose
  • Identifying and modelling the business key
  • Core concepts versus abstraction
  • Multiple keys
  • Non-unique keys
  • Dealing with duplicates
13.10h - 14.00h
Lunch Buffet and Networking Opportunity
Workbook Exercise 2
  • Workbook exercise 2: explanation and group exercise
  • Discussion
  • Q & A
Link Topics
  • Natural business relationships
  • Business versus source driven
  • Transactions, hierarchies, ...
  • When a link grows a hub
  • Unique relationships
  • Circular not an issue
  • "The Fly"
  • Unit of Work
  • Context for the key
  • Designing satellites
  • Splitting and merging
  • Rates of change
  • Types of data
  • Sources of the data
  • Code and Reference Tables versus "Linked Core" concepts
  • Multi-valued
  • History
  • Folding to third normal form (3NF)
Workbook Exercise 3
  • Workbook exercise 3
  • Discussion
  • Q & A
Coffee/Tea Break
Group Exercise Case

The groups work on an assignment based on a practical case.

Discussion Group Exercise
  • Presentation, review, analysis and discussion of the group exercise
  • Q & A
The Process for Modelling and Deploying the Data Vault EDW
  • Business-driven modelling
  • Applying an agile modelling methodology
  • Loading the EDW
  • Designing and loading data marts sourced from Data Vault models
  • Detailed architectural flow of data in the new EDW
  • Guidance on how to use the course materials, book, and online resources after class
Assessment Test

All participants do a quick assessment test to see if they have understoond the theory and practice of Data Vault modelling. If they pass, they get the Genesee Academy certificate a few weeks later.

Q & A, Summary and Conclusions, Closing
End of this Seminar


Antoine Stelma (

Antoine Stelma is co-founder of connecteddatagroup and Centennium Academy. connecteddatagroup connects technology with business or rather, we connect data with people and people with data. It is our ambition to make data simple, fast, predictable and fully available for effective analytical application. Centennium Academy has been providing a diversity of BI, Analytics and data management training for more than ten years, with the specialization Data Vault modeling.

Antoine is "Genesee Academy Guest Instructor" and authorised to deliver Genesee Academy trainings around the world.

Antoine presents many courses on Business Intelligence and Datawarehousing. Antoine is Certified Data Vault Modeler, Certified Business Intelligence Professional and Oracle Certified Professional.

With almost 20 years of experience in Business Intelligence and Datawarehousing, Antoine has very broad and deep knowledge of this market. By doing various jobs such as architect, project leader, information analist, coach and teacher, Antoine is an allrounder in the BI domain. He is a rational person with excellent social and communicative powers.

In his advisory role, Antoine is responsible for architectural decisions at his customers. He also leads and supports the group of BI architects at connecteddatagroup in their daily job.

Check out our related in-house workshops:

dit is een inhouse