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.
ANALYSIS FOR MICROSOFT EXCEL
Self Service 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 groups
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.
HR REPORTING
Learn how to get connected with HR Reporting - Data load frequency & Entry Point
If you are new to Syensqo's Wiki space, you may need to link your Google Drive in order to see embedded documents.