Data Vault in a Day

Did you see our webcasts about "Het Hybride Werken", "Consono's Dynizer", and "The Future of Bitcoin" ?

Data Vault in a Day


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

ON REQUEST
Location: In-company (YOUR COMPANY)
Presented in English by Antoine Stelma
Price:  ASK FOR PRICE QUOTE

 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.

10.00h
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
10.25h
EDW Requirements & a New Paradigm
  • Modelling Agility
  • Unified Decomposition
  • Ensemble Modelling
  • The Core Business Concept
  • The Modelling process
  • Architecture Overview
10.50h
Hubs, Links and Satellites
  • Data Vault foundation
  • Colors analysis
  • Forming the Backbone
  • Tracking history
  • Attributes
  • Review of a sample Data Vault Model
11.35h
Coffee/Tea Break
11.50h
Workbook Exercise 1
  • Workbook exercise 2: explanation and group exercise
  • Discussion
  • Q & A
12.20h
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
14.00h
Workbook Exercise 2
  • Workbook exercise 2: explanation and group exercise
  • Discussion
  • Q & A
14.30h
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
14.50h
Satellites
  • 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)
15.20h
Workbook Exercise 3
  • Workbook exercise 3
  • Discussion
  • Q & A
15.40h
Coffee/Tea Break
16.00h
Group Exercise Case

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

16.30h
Discussion Group Exercise
  • Presentation, review, analysis and discussion of the group exercise
  • Q & A
17.00h
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
17.30h
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.

17.50-18.00h
Q & A, Summary and Conclusions, Closing
18.00h
End of this Seminar

 Speakers


Antoine Stelma (connecteddatagroup.com)
connecteddatagroup.com

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 these related open workshops:

Check out our related in-house workshops:

dit is een inhouse

Questions about this ? Interested but you can't attend ? Send us an email !

-->