Register
25 Sep25 Sep
Virtual Live CET Time
20 Nov20 Nov
Stockholm

Description

The extract, transform, and load (ETL) phase of the data warehouse development life cycle is the most difficult, time-consuming, and labor-intensive phase of building a data warehouse. A solid ETL system is reliable, accurate and high performant.

Joy Mundy, co-author with Ralph Kimball of The Data Warehouse Lifecycle Toolkit and The Kimball Group Reader, shows you how a properly designed ETL system extracts the data from the source systems, enforces data quality and consistency standards, conforms the data so that separate sources can be used together, and finally delivers the data in a presentation-ready format.

Join industry expert Joy Mundy as she leads you through a rapid-fire one day course on how to:

  • Choose the appropriate architecture for your ETL system
  • Plan and design your ETL system
  • Build the suite of ETL processes
  • Build a comprehensive data cleaning subsystem
  • Tune the overall ETL process for optimum performance
  • Determine the role of Big Data in your DW architecture
  • And much more 

Why attend

This vendor-neutral course helps you understand all the factors necessary for effectively designing the back room ETL system of your Kimball DW/BI environment. The course focuses on the overall architecture and design of the ETL system. We drill into the critical processes within the ETL system that are often overlooked. By the end of this course, you will understand how your data warehouse ETL system can be built to respond to ever-changing business requirements.

This is not a code-oriented implementation course; it is a vendor-neutral architecture course for the designer who must keep a broad perspective.

Who should attend

This course is designed for those responsible for building the back room ETL system of a data warehouse environment, including data warehouse team leads, ETL architects, ETL designers and developers, and data warehouse operational staff.

Prerequisites

This course assumes familiarity with the Kimball Approach to dimensional data warehousing. Students must have:

  • Attended the Lifecycle and Dimensional Modeling courses, or
  • Read The Data Warehouse Toolkit book, or
  • Have a lot of work experience!
Register
25 Sep25 Sep
Virtual Live CET Time
20 Nov20 Nov
Stockholm

Need custom training for your team?

Get a quote

Inquire about this course

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
Related articles

Coronavirus (COVID-19)

Outline

 
 
 
 
 
 
 
 
 
 

Understanding the requirements of ETL

  • Business needs
  • Defining the project
  • ETL development process flow
  • Technical requirements
  • The 34 subsystems of ETL
  • Available IT skills and licenses
  • Coding vs. tool

Extract the data

  • Design review exercise
  • Profile data
  • Extract data
  • Capture changed data

Clean the data

  • Data cleansing system
  • Audit dimension
  • Compliance tracking
  • Track error events
  • Deduplicate dimension data

Deliver dimension tables

  • Manage slowly changing dimensions
  • Populate mini-dimensions
  • Create and manage bridge tables
  • Manage hierarchies
  • Maintain special dimensions
  • Distribute dimension data

Deliver fact tables

  • Maintain transactional fact tables
  • Maintain periodic snapshots
  • Maintain accumulating snapshots
  • Calculate derived or consolidated fact tables
  • Lookup fact table surrogate keys
  • Handle late arriving data
  • Extending the dimensional model
  • Manage performance aggregations
  • Feed data to downstream systems

Manage the ETL process

  • Schedule jobs and handle exceptions
  • Backup, recovery, and restartability
  • Monitor ETL workflow

Dates

25 Sep25 Sep
Virtual Live CET Time
20 Nov20 Nov
Stockholm

Pricing

The fee for this 1-day course is EUR 725 (+VAT) per person.

We offer the following discounts.

  • 10% discount for groups of 2 or more students from the same company registering at the same time.
  • 20% discount for groups of 4 or more students from the same company registering at the same time.

Note: Groups that register at a discounted rate must retain the minimum group size or the discount will be revoked. Discounts cannot be combined.

Copyright ©2020 quest for knowledge