Data Vault: Building a Scalable Data Warehouse Training Course

Course CodeCourse Code

datavault

Duration Duration

28 hours (usually 4 days including breaks)

Requirements Requirements

  • An understanding of data warehousing concepts
  • An understanding of database and data modeling concepts

Overview Overview

Data vault modeling is a database modeling technique that provides long-term historical storage of data that originates from multiple sources. A data vault stores a single version of the facts, or "all the data, all of the time". Its flexible, scalable, consistent and adaptable design encompasses the best aspects of 3rd normal form (3NF) and star schema.

In this instructor-led, live training, participants will learn how to build a Data Vault.

By the end of this training, participants will be able to:

  • Understand the architecture and design concepts behind Data Vault 2.0, and its interaction with Big Data, NoSQL and AI.
  • Use data vaulting techniques to enable auditing, tracing, and inspection of historical data in a data warehouse
  • Develop a consistent and repeatable ETL (Extract, Transform, Load) process
  • Build and deploy highly scalable and repeatable warehouses

Audience

  • Data modelers
  • Data warehousing specialist
  • Business Intelligence specialists
  • Data engineers
  • Database administrators

Format of the course

  • Part lecture, part discussion, exercises and heavy hands-on practice

Course OutlineCourse Outline

Introduction
    The shortcomings of existing data warehouse data modeling architectures
    Benefits of Data Vault modeling

Overview of Data Vault architecture and design principles
    SEI / CMM / Compliance

Data Vault applications
    Dynamic Data Warehousing
    Exploration Warehousing
    In-Database Data Mining
    Rapid Linking of External Information

Data Vault components
    Hubs, Links, Satellites

Building a Data Vault

Modeling Hubs, Links and Satellites

Data Vault reference rules

How components interact with each other

Modeling and populating a Data Vault

Converting 3NF OLTP to a Data Vault Enterprise Data Warehouse (EDW)

Understanding load dates, end-dates, and join operations

Business keys, relationships, link tables and join techniques

Query techniques

Load processing and query processing

Overview of Matrix Methodology

Getting data into data entities

Loading Hub Entities

Loading Link Entities

Loading Satellites

Using SEI/CMM Level 5 templates to obtain repeatable, reliable, and quantifiable results

Developing a consistent and repeatable ETL (Extract, Transform, Load) process

Building and deploying highly scalable and repeatable warehouses

Closing remarks
 

Bookings, Prices and EnquiriesBookings, Prices and Enquiries

Guaranteed to run even with a single delegate!
Private Classroom
 
Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
Private Remote
From £4400
Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet. More Information

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Private Remote
1 £4400
2 £3100
3 £2667
4 £2450
Public Classroom
From £5000
(91)
Public Classroom
Participants from multiple organisations. Topics usually cannot be customised

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom
1 £5000
2 £3425
3 £2900
4 £2638
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories

Related Courses

Upcoming Courses

VenueCourse DateCourse Price [Remote / Classroom]
Belfast City CentreMon, 2018-02-05 09:30£4400 / £5400
Leicester - St. Georges HouseMon, 2018-02-05 09:30£4400 / £5400
Bristol, Temple GateMon, 2018-02-05 09:30£4400 / £5400
OxfordMon, 2018-02-05 09:30£4400 / £5500
NewcastleMon, 2018-02-05 09:30£4400 / £5200

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients