Learn techniques for developing your dimensional model, from the basics to the most advanced practices. Don't miss the opportunity to learn directly from Joy Mundy, co-author with Ralph Kimball and other members of Kimball Group, of many of the popular “Toolkit” books.
Description
Course Announcement
This instructor-led course is offered as a classroom training course (3 days) and as a Virtual Live class (24 hours). Our Virtual Live classes will be delivered in a part-time approach. The course content is taught in 6 half-day blocks, from 1:00pm to 5:00pm CET / 7:00am to 11:00am EST.
Introduction
The name "Kimball" is synonymous with dimensional modeling. The Kimball Group established the vocabulary and techniques for dimensional modeling, and these techniques show up in today's popular business intelligence, database, and ETL tools.
An excellent dimensional model, or star schema, is the foundation of an excellent data warehouse. This course provides the opportunity to learn the Kimball Approach of dimensional modeling. Having a great dimensional model is necessary, but not sufficient, to implementing a successful business intelligence / data warehouse system. This course prepares you to successfully implement your business intelligence /data warehouse program by covering also the essential elements of the popular Kimball Approach.
In this course you will learn practical techniques for designing, developing, and implementing your dimensional model, from the basics to the most advanced practices. Concepts are taught through a combination of lectures, case studies, and small group exercises. Our goal is to provide you with the skillset you need to lead a dimensional modeling effort at your organization, or participate in the system's successful implementation.
Who should attend
This course is designed for data warehouse architects, data modelers, database administrators, business analysts, and ETL or BI application developers and designers.
Prerequisites
You should be:
- Able to name and describe in a few words the main operational systems of his or her organization
- Able to name and describe in a few words the main business concerns of the end users in his or her organization
- Somewhat familiar with basic data modeling concepts such as referential integrity
However, the absence of these abilities and familiarity will not keep you from profiting from the course.
Data Warehouse ETL: The Kimball Approach