Analysis for Office - Analysis Plug-in

Course Description / Summary:

SAP BusinessObjects Analysis, Edition for Microsoft Office provides in-depth instruction on how to work with and analyze data sources using the Analysis plug-in for Microsoft Excel.  This course begins with learning how to navigate data sources and create workbooks while utilizing the Analysis Design Panel.  You will also learn how to use standard SAP functions to enhance your analysis, formatting techniques for your crosstab, and how to plan your data using manual data entry and BW Planning Functions.  This course also includes an introduction to the BEx Query Designer, the application used to create queries used for planning and analysis with the Analysis plug-in.


Users who need to create and maintain workbooks based on SAP BEx queries, query views, and SAP NW BW InfoProviders, as well as users who need to create BW-IP Planning Functions through BW (Business Warehouse).


  • Experience using Microsoft Excel
  • Familiarity with modeling concepts and data warehousing


  • Analysis for Office Overview and Terminology
  • Navigating Data Sources and Creating Workbooks
  • Analyzing Data
  • SAP Functions and Formulas
  • Crosstab Formatting
  • Workbook Components
  • Planning Data
  • Working with Prompts and Variables
  • Creating Presentations in Microsoft PowerPoint
  • Scheduling
  • Analysis for Office Settings
  • BEx Query Designer
  • Query Elements and Properties
  • Creating Simple Queries
  • Query Characteristic Properties
  • Filtering Queries
  • Creating Planning Functions in Business Warehouse (BW)

Read MoreRead Less