Analysis for Office – AO for Excel

Course Number: 092721AO

Course Length:  1 day

Course Description

Overview:

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.