Microsoft BI & Big Data UG of NYC presents: Implementing Data Warehouse Patterns with the Microsoft BI Tools
Monday, October 14, 2013 from 6:00 PM to 8:30 PM (EDT)
Implementing Data Warehouse Patterns with the Microsoft BI Tools
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.
Presenter: Kevin S. Goff (http://www.kevinsgoff.net):
- Microsoft SQL Server MVP
- Database architect/developer/speaker/author
- Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics
- Frequent speaker at community events in the Mid-Atlantic region.
10-14-2013 6:00 P.M. – 8:30 P.M.
Microsoft NYC offices, 1290 Avenue of the Americas, 6th Floor, New York, NY, 10104
When & Where
Microsoft Business Intelligence and Big Data User Group of New York City
A community dedicated to the development of expertise in Microsoft BI technologies and related third party products.