Intro to Business Intelligence Development

Session 1 – Introduction to Dimensional Data Modeling

Overview

Date: Tuesday, May 12, 2009

Time: 10:00am PT / 1:00pm ET

Duration: 90 minutes

Price: $149 USD

Training Format: Web Seminar

This session will introduce the concepts of dimensional data modeling. We will learn how to design fact and dimension tables based on Kimball principles. We will look at common design patterns and how to solve common challenges such as Slowly Changing Dimensions.

Outline

What is dimensional modeling?
Designing Fact Tables
Designing Dimension tables
Choosing data types
Designing for slowly changing dimensions

Audience

The target audience for this session is SQL Server developers and administrators interested in learning about dimensional data modeling.

Other sessions for this workshop:

SQL Server Integration Services Part 1 (90 minutes)
SQL Server Integration Services Part 2 (90 minutes)
Introduction to Data Mining (90 minutes)