Advanced Data Vault Modeling Seminar & Lab

The next level beyond the Certified Data Vault Data Modeler course is the Advanced Data Vault. This course has been totally redesigned for 2017 and consists of two (2) intensive days of interactive modeling and group case analysis.


The focus of this 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 comfortable with the Data Vault modeling approach and the broader concepts of Ensemble Modeling.  Ideally certified CDVDM modelers, those actively working with Data Vault or those who have spent time working with data warehouse modeling ensembles.

Unique Value

This course provides the unique opportunity to leverage decades of Data Vault modeling experience from around the World to gain a deeper understanding of Data Vault modeling and the impact of various different patterns.  It also provides a venue for connecting with other modelers to share experiences, ideas, models, challenges, discoveries, and to work together towards a common better understanding of ensemble modeling.

Selected Topics

  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)


12 & 13 March 2018

Single Rate $2,700*

* prices exclude GST

Meet our Instructor

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

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.