Designing the Data Warehouse

This workshop focuses on the full end-to-end process of the data warehouse, namely, Gather, Store and Deliver. This workshop is a must for teams involved in the full data warehouse life cycle.The workshop will walk through the process of transforming an operational data model to a central data warehouse model. The processes for creating informational and operational data bases are significantly different. Most crucial to this effort are the interviewing skills and facilitation techniques brought to the table when meeting the business customer. Facilitation techniques refined over many years of building data warehouse systems will be described to help elicit the important information needed when designing for warehouse applications.In any good database design, several factors play a key role: The number of occurrences of each tableThe number of columns in a tableData complexityThe ratio of one table to anotherThe queries that use the dataThe data accesses made by each queryThe load factor for each query (number of times performed).The workshop stresses how these apply to the warehouse optimization.