[Skip Global Navigation]

Training

Training Home

Microsoft Excel for ShowCase Essbase

Course description:

This class provides comprehensive training for business analysts and end users. The processes of accessing and analyzing data maintained in Essbase multidimensional databases using Microsoft Excel are emphasized. The following functionality of Essbase Microsoft Excel Add-ins is presented: basic data access using ad hoc reporting, advanced data retrieval, and formal reports and charts. Basic data access techniques introduce the student to common Essbase terminology, logging on to the Essbase server, basic data retrieval methods, and configuring add-in environment options. Users will be able to create quick, customized reports that can be used for analysis and reporting. Advanced data access focuses on customizing specific data selection and filtering techniques by using member selection options and the database query functions. Finally, students will learn how to create more formal or permanent reports, which include spreadsheet formulas and charts based on Essbase data. The class addresses topics through lecture and provides hands-on exercises to reinforce the learning points.

US Customers - Select this link to begin course registration
Canadian Customers - Select this link to begin course registration

Please note: If you are paying by Check or PO, you will need to download the Public Training or the Academic Training registration form and fax or mail the completed form to SPSS along with your payment.

Subscribers: If you are a Training Subscriber please select "Call Me" as the payment type when preregistering for this course. You will be contacted by a sales representative to verify your subscription — otherwise you will be invoiced for the training.

Duration and Cost:

Costs are for United States courses only. Information about other countries can be found at the worldwide offices page.

Who Should Attend:

This class is intended for business analysts and end users who are required to access Essbase data using Microsoft Excel. The class content presents information from an end user perspective.

Prerequisite:

The student should have a thorough understanding of Microsoft Windows and Microsoft Excel. An understanding of multidimensional database structure is helpful.

Course Content:

The full table of contents for this course is available.