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.
There are no prerequisites.
4 Days/Lecture & Lab
This is a workshop, not just lecture. Students will perform a number of exercises throughout the life cycle of the data warehouse to drive home complete understanding of the data warehouse development process and its issues.
  • Introduction to Data Warehousing
  • Data Warehouse Architectures
  • Data Warehouse Methodology
  • Information Gathering
  • Data Store Layer
  • Modeling Time and History
  • ETL Layer
  • Data Quality
  • BI Layer
  • Important Considerations
  • Managing Data Warehouse Projects
  • Data Warehouse Technology
  • Summary and Conclusion
  • Case Studies
  • Glossary
  • Explanatory Texts

Related Scheduled Courses