Topic: Introduction to Dimensional Modeling - A Case Study
What do they want to count? And what do they want to count by? This session will be presented in the form of a case study that will take the answers to those questions, the data from multiple OLTP databases and take you step by step through the path of creating a basic but well formed dimensional model. What data should go in the Fact tables? How many Dimensions tables are needed? What do you mean by ‘Determine the Grain’? What is a Bus Matrix? This session will answer those questions using examples and also provide you with a step by step process that can be used for any new Data Warehousing project. During the session, Lynda will share what she feels are the most important things to remember and the most important things to avoid based on her 8 years of experience creating and working with Dimensional models.
Speaker: Lynda Rab, Canada Mortgage and Housing Corporation
Lynda Rab is an IT professional with over 15 years of technical experience. She has been working with SQL Server since version 4.2 and is now focusing her efforts on Data Warehousing working for Canada Mortgage and Housing Corporation. Lynda is the Program Director for the Professional Association for SQL Server (PASS) and is a member of the OttawaSQL.net executive team.
RSVP: http://www.clicktoattend.com/?id=138407
Arrival: 5:45 PM to 6:00 PM
Session: 6:00 PM to 8:30 PM
Refreshments: Pizza and Pop
Comments