Description

The name "Kimball" is synonymous with dimensional modeling. The Kimball Group has 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 2-day Virtual Live Course provides the opportunity to learn the fundamentals of the Kimball Approach of dimensional modeling, including some but not all advanced techniques. Modelers who need more interaction and want to develop their skills a bit more should consider taking the 3-day Dimensional Modeling Course, as the third day brings some extra complexity and sophistication to the table. Think of supertype and subtype dimensions and an extra challenging workshop to test your skills hands on. As an extra, your specific modelling challenges will be covered during the third day.

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 our venues in Amsterdam, Brussels, London, Stockholm or in a virtual classroom. 

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. It is a great foundation for the entire data warehouse / business intelligence team. 

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.

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.

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

Case Study: 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

Case Study: Child Protective Services

The Dimensional Modeling Process

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 Reader (Second Edition).

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

28 May29 May
Virtual Live CET Time

Pricing

The fee for this 2-day course is EUR 1.450,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 ©2020 quest for knowledge