NOW UPDATED  including Big Data modeling, revised UOW, Metrics Overlay, Ensemble Modeling, updated BK design, Hash Key options, new Raw/BDV materials, and new cases.

This course will guide you through the Data Vault modeling approach from modeling constructs and patterns to applying data vault principles in your DWBI program. This course covers also loading paradigms, architectures, and how to develop an effective overall data vault data warehouse program. Since data vault may be new for many of you, this course also includes a summary of the benefits of using data vault techniques.

Who Should Attend?

The target audience for this course includes data warehousing and business intelligence professionals, data modelers, data architects, model managers, data warehouse DBAs, data scientists, and ETL professionals. Because data vault modeling concepts are closely aligned with the business aspects of DWBI programs our target audience also includes program managers, business analysts, information modelers, information architects, and other BICC professionals.

Requirements and Pre-Requisites

This course does not require a computer or other device. Students should be prepared to take notes. All materials, work books, case books and exercises will be provided. There are no pre-requisites for this course. It is helpful if you bring any specific topics that you are interested in concerning data vault. It can also be useful if you have the time for web research on the topic prior to class. Depending on the course section, the first day of class may be preceded by 2 weeks of online on-demand video lessons.

Course Structure

The CDVDM course is a three (3) day intensive classroom based course. The course consists of five core components plus the certification exam. The classroom time is 40% Classroom Lecture, 30% Small Group Exercises and 30% Interactive Discussions. The course materials consist of a published course book that follows the classroom lectures and several modeling cases for the small group modeling labs. Class interactive discussions are based on these cases plus workbook examples.

Day One

0830 Welcome & Introductions

0900 Data Warehouse Modeling

0930 Ensemble Modeling

1000 Data Vault Core Constructs

1020 Comparing Modeling Methods

1030 Break

1045 Tracking History

10:55 Information Modeling

11:15 Data Vault Modeling Process

1115 First Small Group Case Exercise

1200 Lunch

1300 Continue First Case

1345 Class Discussion & Groups Present

1415 Link Design & Exceptions

1430 SAL & HAL

1440 Business Key Topics

1500 Disconnected & Reference Tables

1515 Break

1530 Unit of Work

1600 Second Small Group Case Exercise

1700 Wrap up for the Day

Day2

0830 Q&A from Day One

0915 Continue Second Case

1030 Break

1045 Class Discussion & Groups Present

1120 Satellite Design & Exceptions

1135 Expanded UOW & Keyed Instance

1150 Modeling Address

1200 Lunch

1300 Bike Shop Example

1320 Applying the DV Ensemble

1335 Standard and Expanded Attributes

1350 Managing Dates / Bi-temporal Data

1400 Third Small Group Case Exercise

1515 Break

1530 Continue Third Case

1545 Class Discussion & Groups Present

1620 Raw & BDV Layers

1630 Hyper Forms and Unstructured

1640 SID versus Hash

1650 Virtualization

1700 Wrap up for the Day

 

Day3

0830 Q& A from Day Two

0900 Data Vault & Agility

0930 Data Vault & Big Data

1000 Architecture & Layers

1020 Helpful Tables: Bridge & PIT

1030 Break

1045 Loading Patterns

1130 Class Discussion

1145 Recap for Exam

1200 Lunch

1300 Recap & Discussions

1330 CDVDM EXAM

1630 Conclusion

Instructors

 

 

Hans Hultgren

Hans Patrik 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 modeling and architecture including Ensemble and Data Vault modeling. Hans works internationally primarily in Nordics and EU (based in Stockholm), USA and Canada (based in Golden, CO) and down under in Sydney, Melbourne, Brisbane as well as Auckland and Wellington. 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 www.DataVaultAcademy.com

Hans published the book Modeling the Agile Data Warehouse with Data Vault which is available on Amazon websites. Specialties: EDW, Data Modeling, DWBI Architecture, Ensemble Modeling, Data Vault Modeling, Speaking, Advising, Data Vault, Agile Data Warehousing, Education, Training, e-Learning, Entrepreneurship.

 

Remco Broekmans

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

Specialties: EDW, Data Modeling, DWBI Architecture, Ensemble Modeling, Data Vault Modeling, Speaking, Advising, Data Vault, Agile Data Warehousing, Education, Training.