Register
Tue 22 Sep, 2020 - Virtual Live Classroom
Tue 17 Nov, 2020 - Stockholm

Description

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.

In this practical course, 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.

This course gives you the opportunity to learn directly from Joy Mundy, formerly of the Kimball Group and co-author with Ralph Kimball of The Data Warehouse Lifecycle Toolkit , The Microsoft Data Warehouse Toolkit and The Kimball Group Reader.

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. And word-of-mouth brings students from all over Europe to one of the venues in Amsterdam, Brussels, London, Oslo or Stockholm.

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
Tue 22 Sep, 2020 - Virtual Live Classroom
Tue 17 Nov, 2020 - Stockholm

Need custom training for your team?

Get a quote

Inquire about this course

CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
Share
Related articles

Coronavirus (COVID-19)

Outline

 
 
 
 
 
 
 
 
 
 

Dimensional Modeling Fundamentals

Case Study: Retail Sales

  • Transactional fact tables
  • Star vs. snowflake dimensions
  • Surrogate keys
  • NULLs
  • Date and time
  • Header versus details
  • Identifiers

Workshop: Content Marketing

  • Roles of dimensions
  • Junk dimensions
  • Generic dimensions
  • Comments and other freeform text
  • Factless fact tables

Case Study: Financial Accounts

  • Semi-additive facts
  • Allocated facts
  • Multiple currencies
  • Multiple time zones
  • Periodic and accumulating snapshot fact tables
  • Conformed dimensions
  • Drilling across fact tables
  • Ragged hierarchies

Design Review Exercise

Slowly Changing Dimensions

  • Types 0..7

Workshop: Child Protective Services

Case study: Insurance Claims

  • Simultaneous facts and dimensions
  • Many to many dimensions

The Dimensional Modeling Process

Workshop: Higher Education

  • Supertype and subtype dimensions

Dates

22 Sep24 Sep
Virtual Live Classroom
17 Nov19 Nov
Stockholm

Pricing

The fee for this 3-day course is EUR 2.175 (+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 ©2020 quest for knowledge