Kimball University: Course Descriptions

Data Warehouse ETL in Depth
The back room of the data warehouse is a technically complex arena with little structure. This course prepares you to deal with the many facets of delivering data to the end users and business intelligence applications.

What you’ll learn
This three-day course, based on The Data Warehouse ETL Toolkit (John Wiley & Sons; September 13, 2004), will provide you a detailed technical introduction to building an ETL system for a data warehouse to meet the needs of the business intelligence applications. Using on a comprehensive case study, the class will work through extracting, data profiling, cleaning, conforming, and delivering data into final dimensional formats, before the data is available to the end users. Students will build on paper a number of ETL deliverables from source data provided, including the source to target map, data quality tests, error event fact tables, audit dimensions, and final star schemas. A CD will be provided for students to take home after the class showing dynamic screen captures of several industry standard tools for accomplishing some of these steps.

Who should attend
This course is designed for data warehouse implementers, who are responsible for building the back room, or ETL portion, of a data warehouse environment. This would include ETL developers, ETL architects, data warehouse operational staff, compliance tracking data warehouse professionals and real time data warehouse designers.

Prerequisites
Attendees must be familiar with and understand dimensional modeling. If you have attended one of our public or onsite courses, you qualify. If you have thoroughly read and understood the Data Warehouse Toolkit, Second Edition (John Wiley & Sons, 2002), you qualify. Whether or not you’ve attended one of our courses, be sure to review the key dimensional design concepts. For example, you must readily grasp the concept of a Type 2 Slowly Changing Dimension without explanation during the class. Please note that dimensional modeling is not taught during this course. It is your responsibility to come prepared.

COURSE OUTLINE (Coming in Mid August 2004)