Course announcements

  • Analyse OLAP sources in MS Excel and create intuitive presentations with MS PowerPoint usnig SAP BusinessObjects Analysis Addins.

Goals

  • Learn the basic functions and navigation options of Analysis, edition for Microsoft Office
  • Learn the special functions and layout design options of Analysis, edition for Microsoft Office

Audience

  • Application Consultant
  • Business Analyst
  • Business Process Owner / Team Lead / Power User
  • Developer Consultant

Prerequisites

Essential

  • Microsoft Excel skills

Recommended

  • Experience with BEx Queries

Course based on software release

  • SAP BusinessObjects Analysis 2.4, edition for Microsoft Office, BI Launchpad, SAP NetWeaver Business Warehouse 7.4

Content

  • Positioning and Overview of SAP BusinessObjects Analysis, edition for Microsoft Office
    • Positioning of SAP BusinessObjects Analysis
    • Getting an Overview of SAP BusinessObjects Analysis
  • SAP BusinessObjects Analysis, edition for Microsoft Office - Excel
    • Starting the Microsoft Excel Addin and Inserting a Data Source
    • Navigating in Data Sources
    • Sorting and Filtering
    • Creating Measures in the Workbook
    • Working with Hierarchies
    • Working with Variables
    • Defining Formatting Options for the Crosstab
    • Adding Components to the Workbook
    • Working with Formulas
    • Creating a Default Workbook
    • Converting BEx Analyzer Workbooks
    • Setting Preferences
    • Publishing and Scheduling
    • Introducing the Usage of VBA in Analysis
  • SAP BusinessObjects Analysis, edition for Microsoft Office - Power Point
    • Starting the Microsoft Power Point Addin and Inserting a Data Source
    • Using the Fit Table Function
    • Adding Charts and Info Fields
    • Changing Presentation Settings
    • Publishing Analysis Presentations"

CPE Credits

016 Credits

Please note CPE credits are available only for publicly scheduled courses delivered at SAP locations. CPE credits are not available for virtual classroom deliveries or customer specific deliveries.

This course is also available as a test system within SAP Live Access

Learn more

Register your interest for taking this course

Let us know when and where you'd like to attend and we'll notify you when sessions become available.

Note: Location can be for a public classroom or a virtual that meets your prefered timezone.

Register Interest