Skip to main Content

SAP Analysis for Microsoft Office

  • Code training BOAN10
  • Duur 2 dagen

Andere trainingsmethoden

Extra betaalopties

  • GTC’s 20 (incl. BTW)

    Global Training Credits: neem contact met ons op voor meer informatie

Klassikale training Prijs

eur1.640,00

(excl. BTW)

Vraag een groepstraining aan Schrijf je in

Methode

Deze training is in de volgende formats beschikbaar:

  • Klassikale training

    Klassikaal leren

  • Virtueel leren

    Virtueel leren

Vraag deze training aan in een andere lesvorm.

Trainingsbeschrijving

Naar boven
This course is about analyzing OLAP sources in MS Excel and creating intuitive presentations with MS PowerPoint using SAP BusinessObjects Analysis Addins.
    • Methode: Virtueel leren
    • Datum: 29-30 april, 2024
    • Locatie: Virtueel-en-klassikaal
    • Taal: Engels

    eur1.640,00

    • Methode: Klassikale training
    • Datum: 29-30 april, 2024
    • Locatie: SAP Nederland (Amerikastraat 10) D-Bosch
    • Taal: Engels

    eur1.640,00

    • Methode: Virtueel leren
    • Datum: 23-24 september, 2024
    • Locatie: Virtueel-en-klassikaal
    • Taal: Engels

    eur1.640,00

Doelgroep

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

Trainingsdoelstellingen

Naar boven
  • 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

Inhoud training

Naar boven

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

Voorkennis

Naar boven
Essential
  • Microsoft Excel skills
Recommended
  • Experience with BW Queries and the BI Suite

Aanvullende informatie

Naar boven
Course based on software release
  • SAP BusinessObjects Analysis 1.4, edition for Microsoft Office, BI Launchpad, SAP NetWeaver Business Warehouse 7.3
Cookie Control toggle icon