Browse Courses

Designing the Data Warehouse

Email this Page    Print-Friendly Version

Summary:
This workshop will stress that designing a data warehouse is not just an intuitive process based solely on the spontaneous judgment of a skilled analyst. It can be based on sound rules and guidelines just as production data models are.

Duration:
3 Days/Lecture & Lab

Topics:

  • Workshop Agenda
  • Introduction to Data Warehousing
  • Data Warehouse Methodology
  • Introduction To Data Modeling
  • Building the Data Warehouse Model
  • Levels of Data In the Enterprise
  • Derived Data
  • Modeling Time and History
  • Information Gathering
  • Analyzing Current Systems Data
  • Data Transformations
  • Critical Warehouse Components
  • Optimizing the Data Warehouse Design
  • Data Warehouse Technology
  • Important Considerations and Issues
  • Managing Data Warehouse Projects
  • Summary and Conclusion
  • Case Studies



Last Update: May 24, 2013