Data Vault Modeling Certification (CDVDM)

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.

Thank you for your interest in the Data Vault certification course. Your successful completion of this course will result in a designation of Certified Data Vault Data Modeler – CDVDM. Data Vault modeling is rapidly becoming the standard modeling approach for the data warehouse. Over 1200 major international organizations are applying data vault modeling techniques today. The data vault principles are specifically well suited for data integration and historization. When applied to data warehousing programs data vault modeling can provide the organization with some very compelling benefits. These include agility, auditability, adaptability, alignment with the business, and support for operational data warehousing initiatives. To gain these benefits the organization will need to commit to both EDW program level factors as well as specific data vault modeling patterns, standards and methods. This course will guide you through these modeling patterns, rules and methods to prepare you for successful data vault modeling in your organization. We look forward to seeing you in the classroom.

Day 1


0830 Welcome & Introductions
0900 Data Warehouse Modeling
0930 Ensemble Modeling
1000 Data Vault Core Constructs
1020 Comparing Modeling Methods
1030 Break
1045 Tracking History
1055 Information Modeling
1115 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

Day 2


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

Day 3


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
1630 Conclusion