Audience :

  • DBAs
  • Database Designers
  • Any users building the OBIEE metadata repository

Topics :

  • Introduction to Data Warehousing
  • Introduction to Dimensional Modeling
  • Building the Data Warehouse Model
  • Levels of Data in the Enterprise
  • Information Gathering
  • Building the Central DW Model
  • Modeling Aggregates
  • Modeling Time and History
  • Building Data Marts
  • Optimizing the Data Warehouse Design
  • Data Warehouse Technology
  • Summary and Conclusion

Objectives :

  • Discover principles of Data Warehousing
  • Discover basic data warehouse architectures as well as DW development processes
  • Discover data warehouse data design options
  • Work with both normalized data model and a dimensional model
  • Discover aggregation
  • Understand and apply different modeling techniques for different data warehouse structures