Prerequisite:   This course assumes basic understanding of relational database and data warehousing terms and concepts.

 

One-day Course

You Will Learn

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

Geared To:

• Anyone involved in the product selection, design, and/or construction of multidimensional data access methods for the organization

Hands-On OLAP is committed to providing non-biased information 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, PolyVista, 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 it might fit in their warehouse efforts.

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