BOAN10 SAP Analysis for Microsoft Office

COURSE OBJECTIVE:
• 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

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

COURSE PREREQUISITES:
Essential

• Microsoft Excel skillsRecommended

• Experience with BW Queries and the BI Suite

COURSE CONTENT:
Components and Data Sources for Analysis

• Using Analysis Components and Data Sources
Customization for Workbook Data Analysis

• Using the Basic Components of Analysis
• Sorting and Filtering Workbook Members
• Filtering Selected Workbook Members by Measure for Enhanced Analysis
• Using Hierarchies for Data Analysis in Workbooks
• Using Inserted Components to Add Workbook Functionality
• Configuring Filter Components Using Formulas to Enhance the Workbook Layout
• Defining Conditional Formatting Options for Workbooks
• Using a Prompting Dialog in Workbook Queries
• Extending Workbook Display Options with Functions and Microsoft Excel VBA
• Using Styles to Customize Workbook Appearance
• Setting Preferences to Control Workbook Behavior
• Publishing Analysis Documents to the BI Platform Server
Presentation of Workbook Analysis Data

• Presenting Analysis Data for Business Users

FOLLOW ON COURSES:
Not available. Please contact.