International data warehousing and business intelligence experts Ralph Kimball and Bob Becker will present Kimball University's four-day ETL architecture in-depth from 26 to 29 October.
The class will be hosted by Sybase South Africa's BI Practice at the Southern Sun Montecasino Hotel, in Fourways, Johannesburg.
Kimball is widely regarded as one of the original architects of data warehousing and is known for his conviction that data warehouses must be designed to be understandable and fast. His methodology, also known as dimensional modelling or the Kimball methodology, has become the de facto standard in the area of decision support.
“Taught by two of the world's leading authorities on data warehousing and BI, the class will give delegates an in-depth understanding of all the factors involved in the effective design of the backroom of a data warehouse - one that can evolve gracefully over time as your needs mature and new technologies become available,” says Estelle de Beer, BI Practice manager at Sybase South Africa.
“At the end of this course you will understand how your data warehouse ETL (extract, transform and load) system can be built to anticipate all possible requirements.”
Kimball is known worldwide as an innovator, writer, educator, speaker and consultant in the field of data warehousing. He has remained steadfast in his long-term conviction that data warehouses must be designed to be understandable and fast. His books on dimensional design techniques have become the all-time best sellers in data warehousing.
Becker has worked with business managers and IT professionals to prioritise, justify and implement large-scale decision support and data warehousing systems since 1990. Regardless of the industry, he is highly skilled at identifying business requirements, facilitating organisational consensus and designing dimensional data models.
“The master class is designed for data warehouse implementers who are responsible for building the backroom, or ETL portion, of a data warehouse environment,” says De Beer. “This includes ETL developers, ETL architects, data warehouse operational staff, compliance tracking data warehouse professionals and real-time data warehouse designers. Participants are required to be familiar with the basic principles of dimensional modelling.”
The course ensures that data warehouse designers do not overlook any critical requirements. These include: compliance, integration of diverse sources, increasingly demanding real-time pressures, the time variance of major dimensions such as customer and product, the ability to resume or back out a partially completed load, having a 100% certainty that you have captured all changes in the source systems, and a host of other requirements that participants will learn about.
“This is not a microscopic code-oriented implementation class,” says De Beer. “It's an architecture class for the designer who must keep a broad perspective, and who needs to know what the latest technologies and techniques make possible. The course is organised around 34 necessary ETL subsystems which are developed in detail.”
Each participant will build on paper a comprehensive ETL system based on a realistic, complex example that includes all the subsystems. They will also receive a Kimball University Certificate of Completion.
The cost of the master class is R17 500 per person, including meals and course materials. Group discounts are available.
* For more information about Kimball University and the master class, go to www.kimballgroup.com/html/kucourseETLD.html.
* To book, contact Tessa Kyd, 011 804 6562, tessa@sybase.co.za.
Share
Editorial contacts