Description

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. The course also prepares you to successfully implement your business intelligence / data warehouse program by covering the essential elements of the popular Kimball Approach.

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.

Register
13 Nov15 Nov
Amsterdam
Code: DMD2024
Price: 2.175,00 EUR

Inquire about this course

Outline

 
 
 
 
 
 
 
 
 
 

Kimball Approach Overview

  • Introduction to the Kimball Approach
  • Focus on the business
  • The Kimball Lifecycle

Gather Business Requirements

  • Program planning and management
  • Gather requirements from the user community
  • Gain consensus on priorities
  • Document the business requirements

Dimensional Modeling Fundamentals

  • Defining dimensional modeling
  • Introduction to dimensions and facts
  • Design for the enterprise with conformed dimensions

Case Study: Retail Sales

  • Transactional fact tables
  • Surrogate keys
  • Date and Time dimensions
  • Hierarchies
  • Star vs. snowflake dimensions
  • Identifiers, NULLs, and Header dimensions

Technical Architecture

  • Alternative technical architectures
  • The Kimball architecture

Workshop: Content Marketing

  • Roles of dimensions
  • Multiple fact tables
  • Factless fact tables
  • Multiple time zones
  • Generic dimensions
  • Comments and other freeform text

Case Study: Financial Accounts

  • Junk dimensions
  • Semi-additive facts
  • Multiple currencies
  • Designing to support "updates" to facts
  • Periodic and accumulating snapshots
  • Conformed dimensions and drill-across

Slowly Changing Dimensions

  • Type 0: Retain original
  • Type 1: Restate history
  • Type 2: Track history
  • Type 3: Add a new column
  • Type 4: Mini-dimension
  • Types 5-7: Having it both ways

Workshop: Child Protective Services

  • Multivalued relationships
  • Uneven dimension hierarchies

Case Study: Insurance Claims

  • Simultaneous dimensions and facts
  • Tracking the history of a snapshot
  • The dimensional modeling process

Workshop: Higher Education

  • Pull it all together

ETL for Dimensional Modeling

  • Overview
  • Plan
  • Extract
  • Clean and conform the data
  • Deliver dimension and fact tables
  • Deploy, operate, and manage the BI/DW system

Instructor

Joy Mundy

This course gives you the opportunity to learn directly from Joy Mundy. 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), The Microsoft Data Warehouse Toolkit, and The Kimball Group Reader (Second Edition). Joy teaches the full course portfolio, previously taught by Kimball University for one simple reason: the methodology proves its value over and over in practice.

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. 

Joy began her career as a financial analyst, but soon decided that she enjoyed working with a wide variety of data. She learned the fundamentals of data warehousing by building a system at Stanford University, and then started a data warehouse consultancy in 1994. She worked at WebTV and Microsoft’s SQL Server product development team for a few years before returning to consulting with Kimball Group in 2004, until Kimball Group’s dissolution in 2016. Joy is now semi-retired, but loves teaching and the occasional consulting engagement. She graduated from Tufts University with a BS in Economics, and from Stanford University with an MS in Engineering-Economic Systems.

Dates

22 May - 24 May '24
Stockholm
13 Nov - 15 Nov '24
Amsterdam

Pricing

The fee for this course is EUR 2.175,00 (+VAT) per person.

We offer the following discounts:

  • 10% discount for groups of 2 or more students from the same company registering at the same time.
  • 20% discount for groups of 4 or more students from the same company registering at the same time.
Note: Groups that register at a discounted rate must retain the minimum group size or the discount will be revoked. Discounts cannot be combined.

Copyright ©2023-2024 quest for knowledge