Data Vault Day

Read more about the Data Vault modeling approach here

Data Vault Day

Goal:

This is a course on data vault modeling. It covers the complete scope of topics required to understand the data vault modeling approach and how this approach supports the goals of the data warehouse.

Topics covered include understanding the concept behind data vault, the data warehousing modeling requirements that drive this approach, how the data vault addresses these needs, the idea of the core business concept and the enterprise-wide business key, Hubs, Links, Satellites, backbone models, tracking history, modeling process, loading and sourcing the data vault model, comparing the pros, cons and fit of different modeling approaches, Link design topics, understanding Satellite attribution, source-driven versus business semantics, data integration around Hubs keys, dealing with hierarchies, and practical modeling topics.

Target audience:

This course is intended for business intelligence and data warehousing professionals. The class is perfect for those who are just beginning to work with data vault. In addition, the course is well suited for those who have heard about data vault and are interested in learning what it really means.

Data Modelers, Information Modelers, Data Architects, Information Architects, Business Analysts, Business Intelligence and Data Warehousing managers, designers, project leads and project owners, DW DBAs, Data Mart designers, Integration Experts, ETL Developers, and Functional Area Representatives.

Because the data vault concepts are closely aligned to the business, those working DWBI from both business and technical perspectives will benefit equally from this course.

Description:

Data Vault modeling is quickly becoming the standard approach for modeling the data warehouse. Compared to other popular approaches, data vault modeling represents a paradigm shift – a new way of thinking. Realizing the full benefits of this approach means embracing this new paradigm in its entirety. This course is intended to cover all of the key components that make up the data vault modeling paradigm - distilled into a single day. As such it goes beyond an introduction to arrive at a thorough and practical overview. Because there is a great deal to cover, this course includes a rich set of resources and materials. These are intended to support the learning process before and after the training day itself.

Content:
 This course consists of three (3) components: The one day classroom course, the online video lessons, and the course materials.

Classroom course day

  • Lectures
  • Case Lab
  • Exercises

Online video lessons

  • Data vault fundamentals
  • Related data warehousing & Architecture topics

Course materials

  • Class presentation deck
  • Workbook
  • Lab
  • Guide
  • Book

All components are designed to work together by communicating a consistent and clear message concerning the fundamentals of data vault modeling.

Registration

General information:

This course will be offered as a joint event by Affecto Academy and Genesee Academy and the course will be held in English.

Training venue in Finland: Atomitie 2, 00370 Helsinki

The course price 895€ includes materials, lunch and coffee. VAT will be added to the price.