We work closely with PG&E, Sandia National Labs and other clients. Our courses are open to all of our clients and we look forward to seeing you in class.


Upcoming Classes


Loading Events

« All Events

  • This event has passed.

NEW – (SAP) Analysis for Office – AO for Excel

April 13, 2022 @ 8:30 am - 4:00 pm


Analysis for Office – AO for Excel

Course Number: 092721AO

Course Length:  1 day

Course Description


This course is intended for users interested in building and analyzing workbooks using SAP BusinessObjects Analysis edition for Microsoft Excel.

In AO you can use SAP BW data sources from the BI platform data sources. The data is displayed in the workbook in crosstabs. You can insert multiple crosstabs in a workbook with data from different sources and systems. If the workbook will be used by different users, it is also helpful to add info fields with information on the data source and filter status.

Using the design panel, you can analyze the data and change the view on the displayed data. You can add and remove dimensions and measures to be displayed easily with drag and drop. To avoid single refreshes after each step, you can pause the refresh to build a crosstab. After ending the pause, all changes are applied at once.

You can refine your analysis using conditional formatting, filter, prompting, calculations and display hierarchies. You can also add charts to your analysis. If you want to keep a status of your navigation, you can save it as an analysis view.

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

Identify the components of Analysis for Office

  • Design and edit a basic report
  • Use an AO crosstab
  • Create and modify charts
  • Design and advanced report using hierarchies and filters
  • Create a report from scratch, using queries
  • Group AO crosstabs
  • Link and unlink dimensions for separate crosstabs


This event ticket will close at 12:00 pm the day before the event.


April 13, 2022
8:30 am - 4:00 pm
Event Tags:


CA United States
View Venue Website


Jim Rose


The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available

Share Our Website