Description

Building a data warehouse is complex and challenging. This 2-day course is packed with specific techniques, guidance and advice from planning, requirements and design through architecture, ETL, and operations. It is taught through a combination of lectures, class exercises, and small group workshops. 

Joy Mundy, co-author of Ralph Kimball’s best-selling books and former partner of the Kimball Group, will present the essential elements of the popular Kimball approach as described in the bestselling book, The Data Warehouse Lifecycle Toolkit (Second Edition).

Important topics include:

  • The Kimball approach to data warehouse project planning and requirements gathering
  • Dimensional modeling techniques to capture the most complex business rules
  • A framework for creating your technical architecture
  • And much more!

Why attend

This course is appropriate for anyone who is launching an initiative to build a new data warehouse system, or improve an existing one. It delivers value both to beginners and to DW professionals who have completed multiple projects.

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 / BI project, as well as for those who have several project under their belts and want to align their experience with the proven, Kimball method techniques.

Prerequisites

You 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 DW/BI course prior to this course.

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

Outline

 
 
 
 
 
 
 
 
 
 

Kimball Approach Overview

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

Define Business Requirements

  • Requirements gathering overview
  • Survey the landscape
  • Gather requirements from the user community
  • Gain consensus on priorities
  • Document the business requirements

Understand Dimensional Modeling

  • The dimensional modeling process: The Kimball Approach
  • A brief introduction to dimensional modeling: dimensions and facts
  • Design a simple dimensional model
  • Manage changes in dimension attributes
  • Conformed dimensions
  • Hierarchical dimensions
  • Fact table structure
  • Multiple currencies

Define The Technical Architecture

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

Develop The Data Warehouse database

  • Develop the physical model
  • Plan the storage
  • Keys and when to declare them
  • Initial index plan
  • Performance aggregations
  • The role of OLAP

Create The ETL system

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

Build The BI applications

  • BI applications are the face of the data warehouse
  • Types of BI applications
  • Scope the initial BI applications
  • Design and build the reports and dashboards

Deploy, Operate and Grow

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

Instructor

Joy Mundy

Joy Mundy has worked with business managers and IT professionals to prioritize, justify and implement large scale business intelligence and data warehousing systems since 1992. She leverages these consulting experiences when teaching DW/BI courses. She co-authored, with Ralph Kimball and other members of Kimball Group, many of the popular “Toolkit” books including The Data Warehouse Lifecycle Toolkit (Second Edition) and The Kimball Group Reader (Second Edition).

Joy began her career as a financial analyst, but soon decided that she enjoyed working with a wide variety of data. She learned the fundamentals of data warehousing by building a system at Stanford University, and then started a data warehouse consultancy in 1994. She worked at WebTV and Microsoft’s SQL Server product development team for a few years before returning to consulting with Kimball Group in 2004, until Kimball Group’s dissolution in 2016. Joy is now semi-retired, but loves teaching and the occasional consulting engagement. She graduated from Tufts University with a BS in Economics, and from Stanford University with an MS in Engineering-Economic Systems.

Dates

20 May21 May
Brussels

Pricing

The fee for this two-day course is EUR 1.450 per person. This includes two days of instruction, lunch and morning/afternoon snacks and course materials.

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 5 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 ©2018 Quest for Knowledge