Implementing Data Warehouse Patterns with Microsoft BI Tools HD

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. Kevin S. Goff Kevin S. Goff (www.KevinSGoff.net) SQL Server MVP since 2010 (was a C#/.NET MVP from 2005-2009) SQL Server/Business Intelligence architect/developer/speaker/instructor/author CoDe Magazine Columnist from 2004-2013 on .NET and SQL Server/BI Topics Frequent speaker at community events in the Mid-Atlantic region, and regular speaker for the SQL Live!360 Conference Brand Created 13-week SQL Server 2012 webcast series for Microsoft TechNet Radio Join PASS DW/BI Virtual Chapter at http://bi.sqlpass.org Follow us on Twitter @PASSBIVC