Dimensional Modeling: The Kimball Approach

Program | 31 maj, 2017 | Mariko Eldenholt

Dimensional Modeling: The Kimball Approach

Kimball’s Course Portfolio: Lifecycle – Dimensional Modeling – ETL

Ralph Kimball may have retired from active duty but his former partner and co-author of his best-selling books, Joy Mundy, keeps the legacy alive. She teaches the full course portfolio, previously taught by Kimball University for one simple reason: the methodology proves its value over and over in practice.

Ralph Kimball popularized dimensional modeling, or star schemas, nearly thirty years ago. In the decades since, the five members of the Kimball Group worked to develop, explain, and teach the techniques for dimensional modeling. Today’s popular business intelligence, database, and ETL tools are all marked by the concepts published by the Kimball Group .

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 from Joy Mundy, formerly of the Kimball Group. In this practical, hands-on class you will learn techniques for developing 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, and the judgement needed to make the tradeoffs between competing goals.

Who should attend

Dimensional Modeling: The Kimball Approach is designed for data warehouse architects, data modelers, database administrators, business analysts, and ETL or BI application developers and designers.

Prerequisites

Students 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.

Kimball’s All-in-One

This course is an ideal follow-on to the one-day Data Warehouse Lifecycle: The Kimball Approach course that is offered immediately preceding. Students who are new to the concepts of data warehousing design and development will find the wealth of information in that fast-paced course to be particularly valuable.

Combine the two courses and you win on all levels:

  • A coherent end-to-end education for analysts, modelers, architects and project managers
  • An insight in the interaction of project complexity with  business requirements, modeling options and how to solve complex requirements or reduce complexity

Instructor

Joy Mundy

Joy Mundy has worked with business managers and IT professionals to prioritize, justify and implement large scale business intelligence and data warehousing systems since 1992. She leverages these consulting experiences when teaching DW/BI courses. She co-authored, with Ralph Kimball and other members of Kimball Group, many of the popular “Toolkit” books including The Data Warehouse Lifecycle Toolkit (Second Edition) and The Kimball Group.

 

Avega Group & KIMBALL UNIVERSITY erbjuder professionella utbildningar inom Business Intelligence & Data Warehouse.


Visa alla event