•  

SQW10 Implementing Data Warehouse Patterns with the Microsoft BI Tools

A session at Live! 360

Wednesday 19th November, 2014

4:00pm to 5:15pm (EST)

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'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.

You will learn:
Some of the most critical "DOs and DON'Ts" in the design and population of fact and dimension tables
ETL patterns for populating some of the more advanced dimension modeling concepts (such as type-2 changing dimensions)

About the speaker

This person is speaking at this event.
Kevin Goff

Solutions Architecture, Gannett Digital bio from Twitter

Sign in to add slides, notes or videos to this session

Tell your friends!

View the schedule

Share

See something wrong?

Report an issue with this session