TDWI World Conference

Prerequisite: This course assumes familiarity with the basic principles of dimensional modeling.

Bob Becker

For organizations implementing a dimensional data warehouse, this course helps you understand the key factors necessary to effectively design the back room of a data warehouse. This is not a microscopic code-oriented implementation class—rather, it is a product-independent architecture class for the designer/architect who must keep a broad perspective, and who also needs to know what the latest technologies and techniques make possible.

You Will Learn

• Extracting—gathering raw data from the source systems before any significant restructuring of the data takes place; subsystems 1 through 3 support the extracting process
• Cleaning and conforming—sending source data through a series of processing steps to improve the quality of the data, and merging data from two or more sources to create and enforce conformed dimensions and conformed metrics; subsystems 4 through 8 describe the cleaning and conforming processes
• Delivering—physically structuring and loading the data into the target dimensional models; subsystems 9 through 21 provide the capabilities for delivering the data
• Managing—managing the related systems and processes of the ETL environment; subsystems 22 through 34 describe the ongoing management of the ETL system

Geared To

• Data warehouse implementers responsible for building the ETL environment, including ETL developers, ETL architects, data warehouse operational staff, and data warehouse architects