IBM Planning Analytics for Excel PAfE (Instructor-Led, Online)

IBM Planning Analytics for Excel PAfE (Instructor-Led, Online)



Course Length: 1 days

IBM Planning Analytics for Excel (PAfE) brings the benefits of modern enterprise performance management to Microsoft Excel Spreadsheets.  It provides a way for business and financial analysts, line-of-business managers, and users to access data from a variety of sources, including IBM Planning Analytics and IBM Cognos Analytics to perform analysis in a familiar Microsoft Excel spreadsheet environment.


Students will be able to create spreadsheet reports from multidimensional IBM Planning Analytics models and IBM Cognos Analytics.  Retain the power of Microsoft Excel functionality and formatting while integrating with data between IBM Planning Analytics and share results with IBM Cognos Analytics-sourced reports in Cognos dashboards and reports. 


This is a one day instructor-led course.


Please email us at for pricing, available dates and more information.


Upon successful completion of this course, students will be able to:

  • Explore and Analyze Planning Analytics Cube Data
  • Retain Excel Functionality and Formatting
  • Modify data and commit data back to Planning Analytics
  • Share Results


Students will learn to use Planning Analytics for Excel (PAfE) to create new reports.  Aggregation, summaries, grouping and sorting will be covered.  Students will create filters and prompts, add detail and summary calculations, format reports, create list and crosstab reports, publish, share and navigate to other reports.

Knowledge Level:  Introduction

Field of Study:  Specialized Knowledge

Delivery Method:  Group Internet based

Participants will earn 7.0 CPE Credits.  To be awarded the full credits, you must fully attend the course.


Knowledge of the use of a web browser to access the corporate intranet environment is assumed. Familiarity with Microsoft Excel and basic navigation is expected.


Your instructor will be Maria Lack. Maria is an Implementation Manager based in San Diego, CA. She is certified in IBM's TM1 / Planning Analytics. She has been with QueBIT since 2015 and brings a wealth of project experience.