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
Aligning the data model to the business process
Gather technical data requirements
Enable self-service BI
Mapping data requirements to a data model
Change your data model at will
Changes in source systems won’t kill your model
SCD2 by default
Develop using design patterns
Changes in requirements won’t kill your code
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 attributes and their purpose, identifying and modeling the business key, core concept versus abstraction, multiple keys, nonunique keys, dealing with duplicates
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
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 CostsAttending the 1-day training is NZD $1,000 (+gst) per participant
Next EventWe run the 1-day training once a month in our central Wellington office.
Contact us below to find out the next training date.