Exploring Key Functionality and Data Sources

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.