Intuitive data processing with SAP Analysis for Office (AfO)

Analysis for Office enables deep data analyses and allows outliers and trends to be identified directly in Excel. This intuitive tool still works in the regular Excel environment, which means that the usual tools can continue to be used - at the same time however, there is the ability to create complex reporting, planning and simulation scenarios beyond the usual Excel functions.

This is how you can benefit from SAP Analysis for Office:

SAP Analysis for Office enables (1) simple, Excel-based analysis of large data volumes; (2) rapid access to various data sources (queries, CDS views, HANA, BPC and local files), (3) flexible processing and central or local storage of the workbooks, including offline processing and (4) expandability with planning scenarios (embedded BPC) .

Get a rapid understanding of large amounts of data

Results and key figures from a variety of different Excel-based  data can be prepared on Excel and analysed from a solid basis.

Various sources at a glance

Quick processing and time-saving by merging different data sources such as queries, CDS views, HANA, BPC and local files.

Flexible processing

Central or local storage of the different workbooks, including the option of offline editing.

Planning scenarios included

In the analysis, the actual state is presented as well as forecasts and planning scenarios (Embedded BPC).

Overview of Excel with dashboard add-on Analysis for Office
Contact
Your contact person for SAP Analysis for Office

"Overall, SAP Analysisfor Office, with its highly intuitive usage and range of convenient functions, enables for example a controller - even one who does not have in-depth technical knowledge - to get started with Excel-based online data analysis and derive insights from business data."

Philipp May, Head of the Reporting workshop

Philipp May is Head of Planning | Reporting | Analytics / SAP® at s-peers AG
Philipp May
Head of reporting workshop
Screenshot - Analysis for Office - example of sales planning 
Screenshot of Analysis for Office using the example of a sales planning process

What is SAP Analysis for Office (AfO)? 

  • Analysis for Office is SAP's so-called starter BI tool.
  • The user interface is the Excel or PowerPoint environment. The SAP Analysis for Office application is available in separate tabs.
  • Functions: Read simple reports and run basic but powerful reporting and planning applications.
  • SAP Analysis for Office also includes extensive functions for database connection.

SAP Analysis for Office consists of the following three add-ins:

  1. Analysis add-in 
  2. Business planning and consolidation plug-ins 
  3. Enterprise performance management add-in 

Analytics New Year's aperitif 2025

Kickstart for the new data year!

13.02.2025
16.00-12.00 h

What are the functions of SAP Analysis for Office?

AfO is an add-in that provides multidimensional analyses and can be used for both Excel and PowerPoint. In Microsoft PowerPoint, the required data can be added to a presentation with the add-in - it thus remains up-to-date and can be updated at the touch of a button when changes are made in Excel.

Analysis for Office can be installed for both Microsoft Exceland PowerPoint. Both plug-ins are installed in a joint installation, after which both are available as separate tabs

  • The plug-in contains options for accessing connected BW systems for more demanding analysis.
  • In addition, a number of API functions are available to filter data in the Visual Basic Editor.
  • Many data sources can be accessed directly via Excel without the need for an export.

The following multidimensional analysesare possible:

  • Creating workbooks in Excel
  • Planning in Excel (planning features, systems, manual planning and functions)
  • Data analysis in Excel (sorting data, conditional formatting, filtering and creating hierarchies)
  • Share content (via PPT, BI platform etc.)
  • Connecting databases (e.g. SAP NetWeaver BW)

To use Analysis for Office, the Analysis plug-in must be installed. After that, you can connect directly to one of the following SAP BW systems: 

Import (classic) planning models and reporting as well as live (SAP BW) models.

More questions about AfO are answered here in our knowledge article.

Would you like to get started on implementing SAP Analysis for Office?

Would you like to delve deeper into the subject of Analysis for Office and implement it in your company?

Do you or your team need SAP Analysis for Office training?

We look forward to answering and solving any of these questions together with you. Get in touch!

Philipp May is Head of Planning | Reporting | Analytics / SAP® at s-peers AG
Philipp May
Head of reporting workshop
Overview of Excel with dashboard add-on Analysis for Office

KNOWLEDGE

Useful information

SAP BI Discovery Day_Banner_LP

SAP BI Symphony 2025

Immerse yourself in the latest developments of the SAP Business Technology Platform. Event location: SAP Headquarters with joint David Garrett concert visit!

Analytics New Year's aperitif 13.02.2025

The Analytics New Year's Apéro 2025 is taking off like a rocket this year and is entirely dedicated to the SAP Analytics Cloud (SAC) - with a clear focus on the latest developments in data-driven planning and AI in collaboration with SAP and Google!

Webinar: SAP S/4HANA Embedded Analytics: Individual visualizations with Fiori Elements

Webinar recording: SAP S/4HANA Embedded Analytics: Individual visualizations with Fiori Elements

Webinar recording: Watch recording now Speaker:innen Philipp Lemp Senior Analytics Consultant...

Webinar SAP Datasphere & SAC Feature Update - Q2 2024

Webinar SAP Datasphere & SAP Analytics Cloud Feature Update Q2/2024

Get a comprehensive insight into the latest functional enhancements of SAP Datasphere (formerly DWC) and SAP Analytics Cloud (SAC) for the second quarter of 2024. On May 28, we invite you to...

More information

Further analytics solutions