X
GO


Cart Summary

0

SAP Business Objects Analysis, Edition for Microsoft Office

Previous 1 Next 

Analysis for Microsoft Office: Analysis Plug-In Introduction

In this course, you will gain a better understanding on how to work with and analyze data sources using the Analysis plug-in for SAP BusinessObjects Analysis, Edition for Microsoft Excel.  You will learn how to navigate data sources within workbooks, and analyze data using the Analysis Design Panel. You will also learn how to use standard SAP functions to enhance your analysis, basic formatting techniques for your crosstab, and how to plan your data using manual data entry and BW Planning Functions. This course is intended for users who navigate through existing workbooks to analyze the data they contain, as well as users who need to create and maintain these workbooks based on SAP BEx queries, query views and SAP NW BW InfoProviders.

Course Objectives:
- SAP BusinessObjects Analysis Positioning and Overview
- Start the Analysis Add-In
- Insert Data SourcesNavigate Data Sources
- Analyze Data Sources Using the Analysis Design Panel
- Sort and Filter Crosstab Data
- Create New Measures
- Update Hierarchies Within the Crosstab
- Work with Basic SAP Functions
- Insert Components, including Info Fields and Charts
- Use Analysis Planning Features, Including Manual Data Entry and Planning Functions/Sequences
- Convert BEx Workbooks

Completion Period: 1 Month   |   Access to Materials: 1 Month
USD $300.00

Analysis for Microsoft Office: Advanced Analysis Plug-In

In this course, you will gain a better understanding on advanced topics for the Analysis plug-in for SAP BusinessObjects Analysis, Edition for Microsoft Office.  Topics include advanced formatting techniques, working with query prompts and variables, additional SAP Functions and Formulas, scheduling, and working with the Analysis plug-in for PowerPoint.  This course also includes topics on customizing your Analysis for Office user profile and interface options. This course is intended for those users who navigate through existing workbooks and PowerPoint presentations to analyze the data they contain.  User can also be those who create and maintain workbooks based on the SAP BEx queries, query views and SAP NW BW InfoProviders.

Course Objectives:
- Work with and set data source prompts and variables
- Create local and global variants for data sources
- Apply advanced formatting techniques, including conditional formatting
- Apply additional formatting components to the crosstab, including new lines, texts, and formulas
- Work with SAP Functions to retrieve members and data values
- Insert data sources using Analysis for Office PowerPoint
- Understand the purpose of Scheduling
- Insert, edit, and remove comments within an Analysis crosstab
- Group multiple crosstabs
- Link dimensions between multiple crosstabs
- Modify existing Analysis settings and create a customized user-interface within the Analysis ribbon

Completion Period: 1 Month   |   Access to Materials: 1 Month
USD $300.00

Analysis for Microsoft Office: BEx Query Designer Introduction

In this course, you will gain a better understanding on how to use the BEx Query Designer in order to create queries for reporting and analysis using the Analysis plug-in for Microsoft Excel and PowerPoint.  This course covers key capabilities of the BEx Query Designer, including: interface options and navigation, how to open and edit existing queries, understanding the purpose of query elements and properties, how to create queries filters, and how to create BW-IP (Integrated Planning) functions which are used for system supported editing and generation of data. This course is intended for 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).

Course Objectives:
- Identify the purpose and function of the BEx Query Designer
- Understand the current BW Reporting Landscape
- Launch the BEx Query Designer
- Identify the core areas of the BEx Query Designer Interface
- Identify the steps in opening and saving queries
- Create a simple query
- Identify InfoProvider elements such as Key Figures and Characteristics
- Understand the purpose and function of query and characteristic properties
- Identify the steps in creating filter queries and set default values
- Understand the purpose and function of BW-IP Planning functions and how they are executed in the Analysis Plug-In for Analysis for Office

Completion Period: 1 Month   |   Access to Materials: 1 Month
USD $300.00
Previous 1 Next