Data Vault Training

Certified Data Vault Data Modeller Course (CDVDM)

This course is organised by EC Integrators in partnership with Genesee Academy (www.geneseeacademy.com).

Data Vault Modelling is rapidly becoming the standard modelling approach for the data warehouse. Over 800 major international companies are applying data vault modelling techniques today.

The data vault principles are specifically well suited for data warehousing programs and can provide the organisation with some very compelling benefits. These include auditability, agility, adaptability, alignment with the business, and support for operational data warehousing initiatives.

This course will guide you through these modelling patterns, rules and methods to prepare you for active data vault modelling in your organisation.

REGISTER NOW

Details

   
25-27 Jul 2016 
Sydney
$3,400 excluding GST
28-30 Nov 2016
Brisbane 
$3,400 excluding GST
18-20 Jul 2016
Melbourne CBD
$3,400 excluding GST
Early Bird expires: 30 May 2016 Early Bird expires: 03 Oct 2016 Early Bird expires: 23 May 2016

Early Bird Registration: $2,900 excluding GST

This course will cover the core concepts of the Data Vault including the Hubs, Links, Satellites, modelling of the business keys, table key structures, detailed attributes, modelling rules, and managing relationships. The course allows students to apply the data vault approach to in-classroom labs completed in small groups. Advanced and exception modelling constructs are presented along with the best practices for applying them.

All materials, exercises, labs, online lessons, and the exam itself are included in this training. The certification exam is administrated in the afternoon of the last day.

Target audience
The primary audience includes:

  • data designers and modellers

  • data architects

  • data warehouse architects

  • data warehouse ETL resources

Audience also includes business intelligence and data warehousing practitioners such as BI analysts and program managers. 

Course Presenter Profile
Hans 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 modelling and architecture including Ensemble and Data Vault modelling

Hans works internationally primarily in Nordics and EU (based in Stockholm), USA and Canada (based in Golden, CO) and down under in Sydney.

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 http://www.DataVaultAcademy.com.

Recently published book Modeling the Agile Data Warehouse with Data Vault which is available on Amazon websites.

 


 

 

ER Model


Course Structure

The classroom time is structured and highly interactive including:

  • 40% Classroom Lecture

  • 30% Small Group Exercises and

  • 30% Interactive Discussions

The classroom course consists of five core components plus the certification exam. These include the lectures, exercises, discussions as well as materials & workbooks and the modelling cases.

Day 1

  • Data Vault constructs of Hub, Link and Satellite

  • Impact of Data Vault – the benefits of applying this model

  • Sales Receipt example modelling with Data Vault

  • Deep dive into Hub design

  • Group Case: Secaucus Soccer

  • Deep dive into Link Design

  • Group Case: Mt Evans Harley

  • Advanced Constructs

  • Assign Integration Case

Day 2

  • Group Case: Integration Case

  • Working with Data Vault

  • Loading Paradigms

  • Applying to the EDW

  • Data Vault in Practice

Day 3*

  • Exam Review and Discussions

  • CDVDM Exam

* NOTE that the Sydney Course will have a special 2.5 day format (12 hours first day and 8 hours second day).

REGISTER NOW

 

Karstens

 

1/111 Harrington Street