HR Reporting

INTRODUCTION

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:

Excel Analysis (HR Guide)

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.