TDWI Summer

Prerequisite: None

Warren Thornthwaite

This course covers the Kimball Lifecycle approach, including practical tips and techniques for creating a successful data warehouse and business intelligence system. It distills the essential elements of the Kimball approach described in the best-selling book The Data Warehouse Lifecycle Toolkit, Second Edition (Kimball, Ross, Thornthwaite, Mundy, and Becker).This course also provides an overview of the Kimball Lifecycle, beginning with the requirements gathering process as the foundation for success. It covers the basic concepts of dimensional modeling and demystifies BI/DW architecture, focusing on the fundamentals: what goes into the architecture and how do we create an architecture that will satisfy the business requirements? We then explore the data staging process, focusing on the extract, transform, and load process in the context of building a dimensional data warehouse.

You Will Learn

• A proven approach to build a BI/DW solution successfully
• Best-practice techniques for handling crucial tasks
• Methods to address common pitfalls and "gotchas"

Geared To

• Those wanting to understand the core elements of the entire data warehouse lifecycle; project and program managers; business sponsors and users; data architects or modelers; BI application developers; ETL system developers; technical architects or administrators