Data Vault Modeling Certification (CDVDM) – Melbourne

This course will guide you through the Data Vault modeling approach from modeling constructs and patterns to applying data vault principles in your DWBI program. This course covers also loading paradigms, architectures, and how to develop an effective overall data vault data warehouse program. Since data vault may be new for many of you, this course also includes a summary of the benefits of using data vault techniques.

Thank you for your interest in the Data Vault certification course. Your successful completion of this course will result in a designation of Certified Data Vault Data Modeler – CDVDM. Data Vault modeling is rapidly becoming the standard modeling approach for the data warehouse. Over 1200 major international organizations are applying data vault modeling techniques today. The data vault principles are specifically well suited for data integration and historization. When applied to data warehousing programs data vault modeling can provide the organization with some very compelling benefits. These include agility, auditability, adaptability, alignment with the business, and support for operational data warehousing initiatives. To gain these benefits the organization will need to commit to both EDW program level factors as well as specific data vault modeling patterns, standards and methods. This course will guide you through these modeling patterns, rules and methods to prepare you for successful data vault modeling in your organization. We look forward to seeing you in the classroom.

What Does This Course Cover?

This course will guide you through the Data Vault modeling approach from modeling constructs and patterns to applying data vault principles in your DWBI program. This course covers also loading paradigms, architectures, and how to develop an effective overall data vault data warehouse program. Since data vault may be new for many of you, this course also includes a summary of the benefits of using data vault techniques.

Who Should Attend?

The target audience for this course includes data warehousing and business intelligence professionals, data modelers, data architects, model managers, data warehouse DBAs, data scientists, and ETL professionals. Because data vault modeling concepts are closely aligned with the business aspects of DWBI programs our target audience also includes program managers, business analysts, information modelers, information architects, and other BICC professionals.

Requirements and Pre-Requisites

This course does not require a computer or other device. Students should be prepared to take notes. All materials, work books, case books and exercises will be provided. There are no pre-requisites for this course. It is helpful if you bring any specific topics that you are interested in concerning data vault. It can also be useful if you have the time for web research on the topic prior to class. Depending on the course section, the first day of class may be preceded by 2 weeks of online on-demand video lessons.

Here’s an outline of what will be covered during this 3-day workshop

Day 1

+

0830 Welcome & Introductions
0900 Data Warehouse Modeling
0930 Ensemble Modeling
1000 Data Vault Core Constructs
1020 Comparing Modeling Methods
1030 Break
1045 Tracking History
1055 Information Modeling
1115 Data Vault Modeling Process
1115 First Small Group Case Exercise
1200 Lunch
1300 Continue First Case
1345 Class Discussion & Groups Present
1415 Link Design & Exceptions
1430 SAL & HAL
1440 Business Key Topics
1500 Disconnected & Reference Tables
1515 Break
1530 Unit of Work
1600 Second Small Group Case Exercise
1700 Wrap up for the Day

Day 2

+

0830 Q&A from Day One
0915 Continue Second Case
1030 Break
1045 Class Discussion & Groups Present
1120 Satellite Design & Exceptions
1135 Expanded UOW & Keyed Instance
1150 Modeling Address
1200 Lunch
1300 Bike Shop Example
1320 Applying the DV Ensemble
1335 Standard and Expanded Attributes
1350 Managing Dates / Bi-temporal Data
1400 Third Small Group Case Exercise
1515 Break
1530 Continue Third Case
1545 Class Discussion & Groups Present
1620 Raw & BDV Layers
1630 Hyper Forms and Unstructured
1640 SID versus Hash
1650 Virtualization
1700 Wrap up for the Day

Day 3

+

0830 Q&A from Day Two
0900 Data Vault & Agility
0930 Data Vault & Big Data
1000 Architecture & Layers
1020 Helpful Tables: Bridge & PIT
1030 Break
1045 Loading Patterns
1130 Class Discussion
1145 Recap for Exam
1200 Lunch
1300 Recap & Discussions
1330 CDVDM EXAM
1630 Conclusion

$3,200 $2,800
2038

Melbourne CBD

Melbourne CBD

20th to 22nd November 2017

Single Rate $3,200*

Early Bird Rate $2,800* (expires 9th of October 2017)

* prices exclude GST

Meet our Instructor

Scot Reagin

Scot Reagin’s technology career spans the entire history of what we now think of as Business Intelligence. Starting with software he developed for mini-computers in the early 1980’s to the first cube technologies of the 1990’s and Self-Service BI and contemporary Predictive Analytics. Scot has consistently designed, developed and delivered solutions for organisations across the evolving BI marketplace.

Scot is a Certified Data Vault Data Modeller, a TDWI Certified Business Intelligence Professional, and Board Member of the Colorado Data Warehouse Institute.

Throughout his career, Scot has had a passion for straightforward problem solving which has been the basis for his many robust and reliable solution designs. He is a thought leader but also a pragmatist, allowing him to build solutions that provide value today while positioning for tomorrow.

Prior to co-founding Sensible Data Integrations, Scot was a Director and Principal Business Intelligence Architect for RevGen Partners, Founder and Principal Architect of SJ Reagin & Associates, and National General Manager and Senior BI Solutions Architect for Aspirity LLC (later acquired by Hitachi Consulting where he held the title of Senior BI Architect).

In addition to consulting, Scot has created and delivered public and private courses on a wide range of BI topics and his ability to clarify the technical aspects of a solution to business value have made him a popular speaker at business and technical conferences.