January 2018 - Data Warehouse Design Patterns

Kevin Goff Presents "Data Warehouse Design Patterns".

“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. We’ll look at 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.”

Bio:

Kevin S. Goff
SQL Server/Data Platform MVP

Microsoft MVP since 2005

Database Developer/Consultant/Writer/Speaker

Regular columnist, CODE Magazine

Location Sponsor:

The Workforce Institute at St. Petersburg College - Epicenter

Food Sponsor:

TEK Systems