Data Vault Modeling in One Day
Remco Broekmans, Coarem
Data Vault modeling is quickly becoming the standard approach for modeling the data warehouse. It’s a unique data modeling technique that uses sets of hubs, links and satellites to build Data Warehouses. The technique is based upon the paradigm:
“Separate things that change from those that do not change”.
A Data Vault modeled Data Warehouse will help companies to handle their data in a constantly moving and changing environment.
This course is intended to cover 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.
The whole day will be focused on learning and understanding Data Vault, and why it is so successful as a modeling technique. This course is designed to be a very practical with a lot of modeling labs and exercises. The following topics will be covered:
- 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.
- 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, non-unique keys, dealing with duplicates.
- Modeling Agility, Unified Decomposition, Ensemble Modeling, the Core Business Concept, Modeling Process, Architecture overview.
- 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.
- Business driven modeling, applying an agile modeling methodology, loading the EDW, designing and loading data marts sourced from data vault models, detailed architectural flow of data in the new EDW.
This course is intended for business intelligence and data warehousing professionals. The class is perfect for those who are just beginning to work with or have a small amount of experience with data vault. This course is also well suited for those who have heard about data vault and are interested in learning what it really means.
Data Modelers, Information Modelers, Data Architects, Information Architects, Business Analysts, Business Intelligence and Data Warehousing managers, designers, project leads and project owners, DW DBAs, Data Mart designers, Integration Experts, ETL Developers, and Functional Area Representatives are all part of the intended audience and will find the course highly beneficial to expanding their knowledge base.
Because the data vault concepts are closely aligned to the business, those working DWBI from both business and technical perspectives will benefit equally from this course.
Remco Broekmans, educator, trainer, and advisor. Remco is working on Business Intelligence and Enterprise Data Warehousing (EDW) with a focus on modeling and architecture including Ensemble and Data Vault modeling. Remco works internationally in Europe and is based in the Netherlands.
Remco worked for several consultancy companies in the Netherlands before starting his own companies, Coarem and BI Academy. He has worked as a consultant throughout the complete field of business intelligence from reporting, ETL and modelling. The last 15 years Remco is teaching different classes on business intelligence and data warehousing. Since 2006 Remco is closely involved with the Data Vault classes from Genesee Academy and authorized trainer from Genesee Academy since 2014. Courses delivered through Genesee Academy use blended and On-Demand DWBI training videos at http://www.DataVaultAcademy.com.