Detailed SAP Analysis for Office learning objectives

Detailed overview of the Learning Objectives:

  • The fundamentals
    • Linking to various Data sources
      • Understanding Bex queries.
      • Understanding aDSOs, Composite providers...
      • Understanding HANA calculation views
      • Basics on SAP Analytics Cloud
    • Creating Connections
    • BO connection.
    • NW connection.
    • SAP Analytics Cloud
  • Reporting – the basics
  • Creating workbooks
    • Inserting a crosstab with data from different data sources
    • Inserting a dynamic chart
    • Inserting an Info Field
    • Inserting a filter
    • Protecting workbooks
    • Saving a workbook
    • Saving a view
  • Analyzing data
  • Opening a workbook
  • Analyzing data with the design panel
  • The analysis tab
  • The information tab
  • The components tab
  • Different ways of showing members and showing totals
  • Repeating members
  • Show/hide zeros in rows and columns
  • Workbook properties for prompting
  • Filtering members
  • Filtering measures
  • Defining the display of members, measures and totals
  • Include dimensions with hierarchies in an analysis
  • Display single dimensions as a hierarchy
  • Working with Grouping & creating a custom hierarchy
  • Learn how to share the axis across multiple reports
  • Using restricted measures
  • Using advanced calculations
  • Working with prompts and filters
  • Sorting data
  • Working with hierarchies
  • Axis Sharing
  • Set up Calculations
  • Working with conditional formatting
  • Commenting a data cell
  • Creating Presentations
  • Customize the user interface
  • Reporting – Advanced
    • Working with formulas
      • Use the functions included in the add-in to build formulas to include data and meta data of used data sources into your analysis
    • Working with API’s combined with VBA