The OLAP Option to Oracle Database 10g is a high-performance, decision-support engine that complements the existing operational and analytic data in your data warehouse. This 2-day course shows you how to add Oracle OLAP functionality to your data warehouse, using tools such as Oracle Warehouse Builder 10gR2 and Analytic Workspace Manager. We explore how the multi-dimensional nature of Oracle OLAP, together with it’s powerful calculation engine, can add additional functionality to your data warehouse and boost the performance of your users’ queries.

Delivered by Mark Rittman or Jon Mead, well known experts in both Oracle OLAP and before that, Oracle Express Server, this course covers the following topic areas:

  • The role of OLAP and Multi-Dimensional Storage
  • Oracle OLAP 10g Architecture
  • Creating OLAP cubes using Oracle Warehouse Builder 10gR2
  • Enhancing OLAP cubes using Analytic Workspace Manager 10g
  • Querying OLAP cubes using Oracle BI Discoverer for OLAP
  • Oracle OLAP Optimization
  • SQL Access to Oracle OLAP
  • Oracle OLAP Tips and Techniques
  • Discussion and Delegate Questions

The course includes slides and delegate notes, and can be delivered on-site or through partners organizations. The course is provided for a fixed price for up to 10 delegates, for locations in UK, Ireland and Europe. Quotations can be provided for custom versions of this course using your own data, and for delivery of this course in North America and other locations.

To book this course, or for more information, contact training@rittmanmead.com