BI, Big Data, Data Analytics, and Data Visualization

SQW03 Implementing Data Warehouse Patterns with the Microsoft BI Tools


9:15am - 10:30am

Level: Introductory to Intermediate

Kevin Goff

Kevin Goff

Microsoft SQL Server MVP

Practice Manager

SetFocus, LLC

You've read some of the content of well-known Data Warehousing books—now what? How do you take the structures and disciplines inside such books as the Ralph Kimball series and implement them? This session will take several of the key concepts in Data Warehousing and demonstrate some implementations using SQL Server Integration Services and Analysis Services. You'll examine items such as Type 2 Changing Dimensions, Confirmed Dimensions, Dimension Outriggers, Role-Playing Relationships, Many-to-Many Bridge table relationships, Factless Fact tables, Handling of NULL foreign key values and more.

You will learn:

  • Techniques for Populating Fact Tables and Dimension tables using T-SQL MERGE statements
  • Special considerations for managing Type 2 Slowly Changing dimensions
  • Tips for implementing many of the patterns found in the Kimball methodology