Select Page

AN INTRODUCTION TO
DATA VAULT MODELING

“An Introduction to Data Vault Modeling” is a 1-day course, developed by Hans Hultgen of Genesee Academy, and delivered by OptimalBI.

The training is interactive with a combination of presentation and hands-on modeling exercises.

MODEL YOUR DATA WAREHOUSE TO ENABLE CHANGES, WITH AGILITY

Data Vault modeling is becoming the standard approach for Agile modeling of the data warehouse. Compared to other popular approaches, data vault modeling 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 training covers all of the key components that make up the data vault modeling paradigm – distilled into a single day. As such it goes beyond an introduction to arrive at a thorough and practical overview. Because there is a great deal to cover, this training includes a rich set of supporting resources and materials developed by Hans and the Genesee Academy. These are intended to support the learning process before and after the training day itself.

IS DATA VAULT RIGHT FOR YOU?

I’M A BUSINESS ANALYST

I’M A DATA ARCHITECT

I’M A DEVELOPER

Translating BEAM into Data Vault
Aligning the data model to the business process
Gather technical data requirements
Enable self-service BI

Ensemble modeling
Mapping data requirements to a data model
Change your data model at will
Changes in source systems won’t kill your model

Understand the Data Vault data model
SCD2 by default
Develop using design patterns
Changes in requirements won’t kill your code

Training Modules

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.

EDW requirements & a new paradigm

Modeling Agility, Unified Decomposition, Ensemble Modeling, the Core Business Concept, Modeling Process, Architecture overview.

Hubs, Links and Satellites

The foundation of Data Vault, Colors analysis, Forming the Backbone, Tracking History, Attributes, Review of a Sample DV Model

Hub Topics

Hub attributes and their purpose, identifying and modeling the business key, core concept versus abstraction, multiple keys, nonunique keys, dealing with duplicates

Link Topics

Natural Business Relationship, Business versus Source driven, Transactions, Hierarchies, when a Link grows a Hub, Unique relationships, Circular not an issue, the Fly, Unit of Work

Satellite Topics

Context for the Key, Designing Satellites, Splitting and Merging, Rates of Change, Types of Data, Source of Data, Codes and Reference Tables versus Linked Core Concepts, Multi-Valued, Folding to 3NF, History

Process for modeling and deploying the Data Vault

Business driven modeling, applying an agile modeling methodology, loading the DW, designing and loading data marts sourced from data vault models, detailed architectural flow of data in the new DW

Training Costs

Attending the 1-day training is NZD $1,000 (+gst) per participant

Next Event

We run the 1-day training once a month in our central Wellington office.

Contact us below to find out the next training date.

Get in touch