Data Warehose ETL: The Kimball Approach
The extract, transform, and load (ETL) phase of the data warehouse development life cycle is the most difficult, time-consuming, and labor-intensive phase of building a data warehouse. A solid ETL system is reliable; accurate; and high performance.
Joy Mundy, co-author with Ralph Kimball of The Data Warehouse Lifecycle Toolkit (Second Edition) and The Kimball Group Reader (Second Edition), shows you how a properly designed ETL system extracts the data from the source systems, enforces data quality and consistency standards, conforms the data so that separate sources can be used together, and finally delivers the data in a presentation-ready format.
She will lead you through two days of learning on how to:
- Choose the appropriate architecture for your ETL system
- Plan and design your ETL system
- Build the suite of ETL processes
- Build a comprehensive data cleaning subsystem
- Tune the overall ETL process for optimum performance
- Determine the role of Big Data in your DW architecture
- And much more
This is not a code-oriented implementation course; it is a vendor-neutral architecture course for the designer who must keep a broad perspective. The course is organized around the Kimball Method’s 34 necessary ETL subsystems which are developed in detail throughout the course.
This two-day course helps you understand all the factors necessary for effectively designing the back room ETL system of your DW/BI environment. It focuses on the critical processes within the ETL system that are often overlooked. Even if you don’t have an immediate need for every ETL subsystem on our list, it is likely that you will over time. By the end of this course, you will understand how your data warehouse ETL system can be built to anticipate these potential requirements.
Who should attend
This course is designed for those responsible for building the back room ETL system of a data warehouse environment, including ETL architects, ETL designers and developers, and data warehouse operational staff.
Since dimensional models are the ultimate ETL deliverables, some familiarity with the basic principles of dimensional modeling is necessary.
Link to course
Visa alla event