In the realm of data analytics, SAP offers two prominent solutions: SAP BW with Excel Analysis and SAP Analytics Cloud (EC) with tables and stories/dashboards. Whilst both serve reporting purposes, they differ significantly in their approach and capabilities.
SAP BW with Excel Analysis
SAP BW integrates and consolidates data from various sources (one of them being information present in EC).
Excel analysis offers flexibility and allows you to extract ad-hoc reports and perform detailed data manipulation using Excel's interface and formulas.
SAP EC Tables/Stories/Dashboards
SAP EC provides a cloud-based analytics platform with intuitive visualizations.
Tables, stories and dashboards offer dynamic interactivity and real-time data connectivity, facilitating data exploration and collaboration, with the extractions you perform allowing you to acquire data as of a pretended date as opposed to monthly prompts which you have to select in SAP BW.
Self Guide
Begin your journey into self-service with our training materials, now available in video & text formats:
Complete step-by-step instructions on various queries, ensuring you have all the guidance you need.
- Excel Analysis (Demo)
For a more immersive learning experience, have a look at our walkthrough of the entire process—from accessing Excel Analysis to extracting basic headcount reports.
Data Group
Analysis for Microsoft Excel provides users with a range of data groups, with each being designed to meet specific reporting needs. To check on the specifics of each data group and its underlying data source, please refer to the following table.
Data Group | Description |
Workforce | Overview of employee data & headcount metrics (FTEs, Turnover, EC Events, annual base salary, etc.). |
Time Management | Overview of absenteeism data, which can be further categorized by absence groups or types. |
Payroll | For details on labor costs, wage types, and accurate payslip reproduction. |
Appraisal | Supports the Appraisal Campaign by enabling feedback assessment and tracking individual objectives. |
Learning | For details on course and certification completions. |
Compensation | Supports the Compensation Campaign by providing data on merit assessments and variable pay structures. |
