Data Vault Introduction

Data Vault Modelling Introduction Course

This course is organised by EC Integrators in partnership with Genesee Academy (

Data Vault Modelling is rapidly becoming the standard modelling approach for the data warehouse. Over 800 major international companies are applying data vault modelling techniques today.

Compared to other popular approaches, data vault modeling represents a paradigm shift – a new way of thinking. Realizing the full benefits of this approach means embracing this new paradigm in its entirety.

This course is intended to cover an initial introduction into the data vault modeling approach. During this one day course we cover the topics of what is data vault, how does it look, how does it work, what are the parts that make up data vault, what are the benefits of using this approach and how do we apply data vault to our own data warehouse program.



20 November 2014
Melbourne CBD
$995 excluding GST

Early Bird Registration by 20 Oct 2014: $875 excluding GST

This course will cover an overview of data vault with the goal of achieving an understanding of the modelling approach and how it can be applied in the data warehouse program.

Topics covered include understanding of what is data vault? How does a data vault model look? How does it work? Next this course covers the modeling components of the data vault – the Hub, Link and Satellite. Then also a discussion on the benefits of using this approach and some guidelines as to how we can apply data vault modeling 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 modeling topics.

Target audience

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

  • Data Modelers / Information Modelers

  • Data Architects / Information Architects

  • Business Analysts

  • Business Intelligence and Data Warehousing Managers

  • Designers / Data Mart Designers

  • Project leads and Project owners

  • DW DBAs

  • Integration Experts / ETL Developers

  • Functional Area Representatives

Course Presenter Profile
Hans Hultgren

Hans Patrik Hultgren is a Data Warehousing and Business Intelligence educator, author, trainer, and advisor.

Hans is currently working on Business Intelligence and Enterprise Data Warehousing (EDW) with a focus on modelling and architecture including Ensemble and Data Vault modelling

Hans works internationally primarily in Nordics and EU (based in Stockholm), USA and Canada (based in Golden, CO) and down under in Sydney.

Hans was with the University of Denver for 20 years and now continues an education focus with hybrid course delivery including e-Learning components. Courses delivered through Genesee Academy use blended and On-Demand DWBI training videos at

Recently published book Modeling the Agile Data Warehouse with Data Vault which is available on Amazon websites.

Course Structure

The classroom day is scheduled in a location that includes table space for each student to work, white board or flip charts, and a presentation projector used during the lectures. The classroom half day is engaging and interactive with the students. The course includes lectures and a case lab.

Day 1

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

  • Data Vault and the Hubs, Links and Satellites - The foundation of Data Vault, Colors analysis, Forming the Backbone, The EDW and Tracking History

  • Hub Topics - Understanding the Hub and modeling the business key, core business concept, planning for and dealing with key integration

  • Link Topics - Natural Business Relationship, Business versus Source driven, Understanding Transactions, Link design considerations.

  • Satellite Topics - Context for the Key, Designing Satellites, Tracking History and design considerations

  • Lab Exercise

  • Present, Discuss, Q&A.

  • Recap