Register
22 May24 May
Stockholm
13 Nov15 Nov
Amsterdam

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
22 May24 May
Stockholm
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

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