Skip to main Content

Advanced Data Vault Modeling

  • Course Code ADVM
  • Duration 2 days

Public Classroom Price

Please call

Request Group Training Add to Cart

Course Delivery

This course is available in the following formats:

  • Company Event

    Event at company

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Course Overview

Top

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.

Course Schedule

Top

Target Audience

Top
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

Top
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

Top
  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

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