Data Vault: Building a Scalable Data Warehouse Training Course

Course Code

datavault

Duration

28 hours (usually 4 days including breaks)

Requirements

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

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 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
 

Testimonials

★★★★★
★★★★★

Bookings, Prices and Enquiries

Guaranteed to run even with a single delegate!

Private Classroom

From £5000

Private Remote

From £4400 (92)

Public Classroom

Location Date Course Price [Remote/Classroom]
Belfast City Centre2018-10-30 09:30£ 4400 / £ 6200
Aberdeen - Berry Street2018-10-30 09:30£ 4400 / £ 5720
Manchester, King Street2018-10-30 09:30£ 4400 / £ 5700
Cardiff2018-11-05 09:30£ 4400 / £ 5600
Oxford2018-11-12 09:30£ 4400 / £ 5500
Newcastle2018-11-19 09:30£ 4400 / £ 5200
Swindon2018-11-19 09:30£ 4400 / £ 5100
Glasgow2018-11-20 09:30£ 4400 / £ 5800
London, Hatton Garden2018-11-26 09:30£ 4400 / £ 5900
Brighton2018-11-26 09:30£ 4400 / £ 5200
Coventry - The Quadrant2018-11-27 09:30£ 4400 / £ 5400
Cambridge2018-12-04 09:30£ 4400 / £ 5300
Leicester - St. Georges House2018-12-04 09:30£ 4400 / £ 5400
Birmingham 2018-12-10 09:30£ 4400 / £ 5700
Bristol, Temple Gate2018-12-10 09:30£ 4400 / £ 5400
Swansea- Princess House2018-12-10 09:30£ 4400 / £ 5000
Portsmouth Technopole2018-12-10 09:30£ 4400 / £ 5000
Liverpool2018-12-10 09:30£ 4400 / £ 5800
York - Priory Street Centre 2018-12-11 09:30£ 4400 / £ 5000
St Helier, Jersey, Channel Isles2018-12-11 09:30£ 4400 / £ 6300
Cannot find a suitable date? Choose Your Course Date >>Too expensive? Suggest your price

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
Jenkins: Continuous Integration for Agile Development Manchester, King Street Thu, 2018-10-18 09:30 £2574 / £3224
Introduction to Recommendation Systems Swansea- Princess House Thu, 2018-10-18 09:30 £990 / £1140
Advanced Statistics using SPSS Predictive Analytics Software Birmingham Mon, 2018-10-22 09:30 £5148 / £6448
Building Augmented Reality Applications with Vuforia and Unity Glasgow Wed, 2018-10-24 09:30 £2178 / £2878
Impact Evaluation – Quantitative Analysis London, Hatton Garden Wed, 2018-10-24 09:30 £2574 / £3324
Statistics with SPSS Predictive Analytics Software Cambridge Thu, 2018-11-01 09:30 £2574 / £3024
Programming in Scala Cambridge Thu, 2018-11-01 09:30 £2178 / £2628
CakePHP: Rapid Web Application Development Birmingham Tue, 2018-11-06 09:30 £4356 / £5656
AWS: A Hands-on Introduction to Cloud Computing Brighton Wed, 2018-11-07 09:30 £1287 / £1487
JMeter Fundamentals and JMeter Advanced Edinburgh Training and Conference Venue Mon, 2018-12-03 09:30 £2178 / £2578
HAProxy Administration London, Hatton Garden Mon, 2018-12-03 09:30 £2178 / £2928
Social Media Marketing Oxford Wed, 2018-12-12 09:30 N/A / £1364
Test Automation with Selenium Manchester, King Street Wed, 2018-12-12 09:30 £3267 / £4242

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

is growing fast!

We are looking to expand our presence in your region!

As a Business Development Manager you will:

  • expand business in the region
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

contact us right away!