Introducing SAP Analytics Cloud, Add-in for Microsoft Excel

SAP Analytics Cloud can bring together a wide range of data from spreadsheets, on-premise databases, and the cloud.

Integrated with Microsoft 365, the SAP Analytics Cloud, add-in for Microsoft Excel lets you format, analyze, and enrich your data based on latest content from the SAP Analytics Cloud platform.

• You can add one or several tables to a workbook, each based on one SAP Analytics Cloud model.
• You can add or remove dimensions and measures to analyze your data.
• For all dimensions and measures, you can also create filters to narrow the scope of your analysis.
• If your analysis model includes dimensions with hierarchies applied, then you can expand and collapse the hierarchy nodes within the table.
• During your analysis and planning, you can update your table with the actual data from SAP Analytics Cloud at any time.

The SAP Analytics Cloud, add-in for Microsoft Excel is available from Microsoft AppSource.

Information on deploying the SAP Analytics Cloud, add-in for Microsoft Excel can be found in the SAP Help Portal: Deploying the add-in.

Once the add-in is activated, you can analyze SAP Analytics Cloud analytic and planning models based on import data connections.

You can also work with SAP Datasphere datasets, SAP S/4HANA Cloud queries, and SAP Business Warehouse queries as data sources.

The Creating and Working with Microsoft Excel Workbooks Using the SAP Analytics Cloud, Add-in for Microsoft Excel course is designed around a common business scenario. In this course, we will use a Microsoft Excel workbook to perform planning using the SAP Analytics Cloud, add-in for Microsoft Excel. The exercises in this course are designed to take you through all of the steps, from connecting to SAP Analytics Cloud to performing planning.

Watch this short video to learn more about the scenario that is used in the course.