Description

Course Announcement

This course will be delivered in a part time approach. In conjunction with our virtual training platform, the course content is taught in 2 half-day blocks, from 1:00 pm CET until 5:00pm CET in the afternoons. This means that the course take longer to complete, but it also means that participants have the opportunity to attend training even if their daily business does not allow them to be absent for several days at a time.

Introduction

Building a data warehouse is complex and challenging. This course prepares you to successfully implement your data warehouse/business intelligence program by presenting the essential elements of the popular Kimball Approach as described in the bestselling book, The Data Warehouse Lifecycle Toolkit (Second Edition).

This 1-day course is packed with techniques, guidance and advice from planning, requirements and design through architecture, ETL and operations. The breadth of content covered in this course necessitates a lecture format.

Important topics include:

  • The Kimball Approach to data warehouse project planning and requirements gathering
  • A brief introduction to dimensional modeling
  • A framework for creating your technical architecture
  • Physical system design
  • Overview of the ETL system
  • And much more!

Who should attend

This course is designed for all major roles on a data warehouse project, including project managers, business analysts, data modelers, architects, and ETL or BI application designers and developers. It is valuable both for team members engaged in their first data warehouse/business intelligence project, as well as for those who have several projects under their belts and want to align their experience with the proven, Kimball techniques.

The course is an ideal introduction to the 3-day Dimensional Modeling: The Kimball Approach course that is scheduled immediately subsequently. That course is particularly valuable for students who need to be able to develop a dimensional model, the key to successful data warehouse design.

Prerequisites

Students should be:

  • Able to name and describe in a few words the main operational systems of his or her organization.
  • Able to name and describe in a few words the main business concerns of the end users in his or her organization.
  • Somewhat familiar with basic data modeling concepts such as referential integrity.

However, the absence of these abilities and familiarity will not keep you from profiting from the course. There is no need for any kind of preparatory data warehouse/business intelligence course prior to this course.

Code: DWL2020
Price: 725 EUR

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

 
 
 
 
 
 
 
 
 
 

Kimball Approach overview

  • Introduction to the Kimball Approach
  • Focus on the business
  • The Kimball Lifecycle

Gather business requirements

  • Program planning and management
  • Gather requirements from the user community
  • Gain consensus on priorities
  • Document the business requirements

Define dimensional modeling

  • The dimensional modeling process: The Kimball Approach
  • A brief introduction to dimensional modeling: dimensions and facts
  • Conformed dimensions

Create the technical architecture

  • Alternative technical architectures
  • The Kimball architecture
  • Implications of cloud architecture
  • The role of Big Data and the Hadoop platform

Develop the DW Database

  • Develop the physical model
  • Plan the storage
  • Keys and when to declare them
  • Performance aggregations and OLAP

Create the ETL system

  • Overview
  • Plan
  • Extract
  • Clean and conform the data
  • Deliver dimension and fact tables
  • Manage the ETL process

Build the BI applications

  • BI applications are the face of the data warehouse
  • Types of BI applications

Deploy, operate and grow

  • Technical deployment
  • Get ready for release: documentation, training and user acceptance
  • Plan for automated operations

This course will be delivered in a part time approach. In conjunction with our virtual training platform, the course content is taught in half-day blocks, from 1:00 pm CET until 5:00pm CET in the afternoons. 

Class Times

09 November 1:00 - 5:00 pm (CET)

10 November 1:00 - 5:00 pm (CET)

Pricing

The fee for this 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