Advanced Data Vault Modeling

Course Overview

The focus of this Advanced Data Vault Modeling course is modeling. In particular this course is focused on providing students a deeper understanding of the various options available within the Data Vault Ensemble modeling approach.

The goal of this course is to enable data modelers and architects to make the most informed and best possible modeling decisions when establishing their specific modeling pattern in their organization.

This course follows an example-driven approach based on over a dozen real-life modeling cases. For each modeling scenario there is a business case that leads to a set of alternatives.  Through interactive group analysis and discussions, and drawing on the experiences of the students in the class, the various alternatives are uncovered, considered, often ranked, and ultimately classified and categorized based on best practice considerations, pros & cons, and how appropriate they might be given the specific business scenarios.

Target Audience

This course if for data modelers, data architects, information modelers, and other data warehousing and business intelligence professionals who work with the design of conceptual, logical or physical data.  Students attending this course should be certified CDVDM modelers, who have taken and passed the Data Vault certification exam.

Course Objectives

The goal of this course is to enable data modelers and architects to make the most informed and best possible modeling decisions when establishing their specific modeling pattern in their organization.

Course Content

1. Modeling Events (and the role of links)
2. Modeling Context Arrays (impact on satellite design)
3. Modeling for Big Data, Cloud & Streaming Deployments (leveraging new platforms)
4. Modeling UOW – Event based UOW  (advanced link design)
5. Modleing UOW – Keyed Instance UOW (hubs vs links)
6. Modeling Address  (context close to key)
7. Modeling the BK in and EDW  (dealing with lack of Enterprise Key – also include Anchor/Focal alternatives)
8. Modeling the Shuttle for Fuzzy Integration (dealing with realistic integration)
9. Modeling the SAT BOK  (alternate, degenerate keys, etc.)
10. Modeling for Personally Identifiable Information and Privacy (PID)
11. Architecture – Defining and Deploying the RAW and BDV (establish approach)
12. Ensemble Logical Form (ELF) and Virtualization (in memory)
13. Modeling Automation – the Play Book  (how and when to automate)

Course Prerequisites

Students attending this course should be certified CDVDM modelers, who have taken and passed the Data Vault certification exam