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 – Analysis for Office – AO for Excel

October 26, 2021 @ 8:30 am - 4:00 pm

$250

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.

Details

Date:
October 26, 2021
Time:
8:30 am - 4:00 pm
Cost:
$250
Event Tags:

Venue

CA United States
View Venue Website

Organizer

Jim Rose
Phone
925-847-8262
Email
Jrose@ComputerTrainingSource.com

Share Our Website