NOW UPDATED 2017 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.
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.
0830 Welcome & Introductions
0900 Data Warehouse Modeling
0930 Ensemble Modeling
1000 Data Vault Core Constructs
1020 Comparing Modeling Methods
1045 Tracking History
10:55 Information Modeling
11:15 Data Vault Modeling Process
1115 First Small Group Case Exercise
1300 Continue First Case
1345 Class Discussion & Groups Present
1415 Link Design & Exceptions
1430 SAL & HAL
1440 Business Key Topics
1500 Disconnected & Reference Tables
1530 Unit of Work
1600 Second Small Group Case Exercise
1700 Wrap up for the Day
0830 Q&A from Day One
0915 Continue Second Case
1045 Class Discussion & Groups Present
1120 Satellite Design & Exceptions
1135 Expanded UOW & Keyed Instance
1150 Modeling Address
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
1530 Continue Third Case
1545 Class Discussion & Groups Present
1620 Raw & BDV Layers
1630 Hyper Forms and Unstructured
1640 SID versus Hash
1700 Wrap up for the Day
0830 Q& A from Day Two
0900 Data Vault & Agility
0930 Data Vault & Big Data
1000 Architecture & Layers
1020 Helpful Tables: Bridge & PIT
1045 Loading Patterns
1130 Class Discussion
1145 Recap for Exam
1300 Recap & Discussions
1330 CDVDM EXAM
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, 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.