Wed, Apr 23 2014 12:00 Eastern Daylight Time
Demystifying Data Warehouses: Detecting DW Patterns and implementing them with SQL Server
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 (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP
Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics
Frequent speaker at community events in the Mid-Atlantic region.
Host of BDBI Radio (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics
May 11: Noon Mountain
May 25: Noon Eastern
About the recording for September 23: You may want to advance
the video about 5 minutes into the file.
The DBA Virtual Chapter presentations are recorded. On the Meeting Archive page, you will find .WMV files that can be viewed on-line.
We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley, email@example.com.
The DBA Virtual Chapter holds two webinars each month. The first one is on the second Wednesday at noon, Mountain time and the second one is on the fourth Wednesday at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.