Prerequisite: An understanding of relational database and DW terms and concepts

HandsOn-OLAP™ is committed to providing a non-biased lecture on best-of-class technologies and techniques as well as exposing participants to leading OLAP tools, their use, and their application. The course begins with an examination of data and technical architectures specific to OLAP. Participants are then led through discussions and lab exercises that emphasize product features, functionality, and applicability of products such as: MS OLAP Analytics, Hyperion Essbase, MicroStrategy, and Cognos PowerPlay.

This course is designed to provide participants with an opportunity to compare and experience critical features of leading OLAP tools. Using a formal case study, students will create multidimensional reporting applications. Extensive lab time provides students with valuable insight into the features of each product and how they may fit in their warehouse efforts.

HandsOn-OLAP™ is designed to provide participants with a non-biased view of leading OLAP tools.

You will learn:

• The best practices, in both data and technical architectures, for implementing an OLAP strategy
• The core components to effective OLAP and more
• Through extensive lab exercises, you will gain hands-on experience with leading OLAP tools, such as:
  • MOLAP: using Essbase and Cognos PowerPlay
  • HOLAP: using MS OLAP
  • ROLAP: using MicroStrategy Intelligent Server
• The right application of atomic level data, star schemas, and MOLAP cubes
• How to effectively apply leading OLAP tools, including MS OLAP Analytics, Excel Pivot Tables, MS MDX, and Cognos PowerPlay cubes
• To compare and contrast OLAP features in order to make the best decision for your organization

Intended Audience

• Anyone involved in the design and construction of data access methods for the organization

     Course Outline>