“Certification processes are critical for assuring that core principles are consistently represented, for Data Warehousing this is my DW2.0 Certification and for the Data Vault it is the Genesee Academy CDVDM Certification” - Bill Inmon

Outline - ONLINE lessons

Foundational Concepts - business overview
Segment 1: Architecture Constructs
Segment 2: Definition of the Data Vault
Segment 3: Issues and Evolution in Data Modeling
Segment 4: Scalability, Agility, Pros and Cons
Segment 5: Operational Data Warehousing
Segment 6: Business Case Studies
Segment 7: Common Business Process Modeling Errors
Segment 8: Classified Information Systems
Segment 9: Business Process Agility in I.T.

Foundational Concepts - technical overview
Segment 1: Hubs and Lab on Hub Discovery
• Hub Definition
• Business Keys
• Composite Business Keys
• Real-time Arrival of Keys
Segment 2: Links and Lab on Link Discovery
• Link Definition
• Link to Link
• Links and Role Playing mistakes
Segment 3: Satellites and Labs on Satellite Discovery
• Satellite Definition
• Type of Information
• Rate Of Change
• Splitting/Consolidating Satellites

Key Structures, Elements in Tables, Common Table Structures
Segment 4: Point in Time/Bridge Tables, User Defined/
Record Sources
• Point in Time Structures
• Bridge Tables
• Reference Structures
• Report Collections
• Net Change and Tracking data across loads
• Aggregation Points
Segment 5: User Grouping Sets
• Excel Sources
• Flat File Sources
• Defining User Data and processing into the DV

Segment 6: EDW Processing
• Business Processing Overview
• Tying the business to the technical data models
• The business process of defining a Data Vault
Segment 7: Conversion to A Data Vault
• Converting from Normalized format to a Data Vault
• Converting a Dimension to a Data Vault
• Converting from a Report to a Data Vault

Outline - ONSITE training & Certification

In-depth, labs en workshops
By the time the onsite lessons begin you must have acquired a firm theoretical Data Vault base and should be ready for an increasingly more hands-on approach. The onsite part of the modeling an certification course is very interactive
 with a large variety of workshops, exercises and labs.

Loading and Querying processes within a DV
Segment 8: Golden Rules, Loading Constructs, math
behind the Load Cycles
• Golden Rule of the Data Vault
• Basic Mathematics behind the loading processes
• Paradigm Shift in executing Business Logic
• Agility of the Loading Processes
• Scalability of through Architecture
• Hub, Link, Satellite Load Process Flows
Segment 9: Loading Data Delivery Mechanisms
• Loading Dimensions
• Loading Facts
• Loading Error Marts
• Loading Report Collections
Segment 10: Scalability of Loading Processes
• Issues with the current loading paradigm
• Shifting the paradigm for Compliance reasons
• Delta Processing and Set Logic
• What to do about “bad data”
Segment 11: What Happens when you Break the
Data Vault Rules?
• Role Playing Links
• Mistakes with the Load DatesSegment 12: Business Constructs
• SLA’s needed for changes, and sign-off
• Default Values versus Error Codes
• Zero Rows populated in the Data Vault
• Views in the Data Vault
Segment 13: Strategies for Managing the Data Vault
• Backup and Restore
• Suggested Topic Areas
• Suggested Satellites
• Items To Note

Exceptions, brainstorm and certification
Near the end of the seminar the inevitable “exceptions to the rule” will be discussed as well as other issues and specific challenges that have come up during the seminar. The seminar is concluded with a Data Vault recap, a brief time to prepare for the test  and...the written exam.

Free Online In-depth modules
After the seminar you are able to extend your knowledge even further by accessing for two weeks additional in-depth on-line  lessons through the e-learning program of Genesee Academy.