With over 25 years in SAP Human Capital Management, Danielle is a recognized leader in HR technology. She holds the distinguished roles of SAP Mentor and SuccessFactors Confidant, and serves as HXM Chairperson for ASUG (America's SAP User Group). Danielle is a sought-after speaker at international conferences, sharing insights on HR tech trends. She has authored four best-selling books on SAP and holds certifications in both SAP and SuccessFactors technologies. Danielle is Global Vice President Strategic Alliances at EPI-USE Labs, where she continues to drive innovation in HR solutions.
Our recent webinar explained how Query Manager can be used to feed data to Analytics systems. One of the webinar attendees queried if this could be used to help HR teams identify employees most impacted by the COVID-19 pandemic. Our first blog on this subject explains how you can take advantage of the data released by reputable sources, including governmental authorities and global organizations such as the WHO, to do this yourself.
There are many additional use cases for leveraging the data shared by these organizations in tandem with your Human Resources data. Another example is determining the outstanding cost for your organization of all employees wishing to take or receive funds for their earned leave to date. This is often referred to as Leave Liability Reporting. You can leverage geo data for where your employees may be most vulnerable geographically; you can also analyze factors such as demographics, age, gender and ethnicity to create reports that could look at the financial impact for those employees.
Many organizations rely on Leave Liability reporting to identify trends in absence, and for costing purposes. These reports evaluate liability and absence history, and are calculated to help with administration of employee absences and leave. During this difficult time, determining the outstanding employee leave balance can be crucial. For example, should you be forced to pay out the outstanding leave for an entire department, you’ll need to know what the cost will be.
In the example below, we have combined the critical geographical data from published COVID-19 cases and used it with various Analytics solutions to help you easily review leave balances, and the financial impact to your company, based on the escalation of the virus and how your business may be impacted. Below are the instructions on how we did so.
A simple Google search will allow you to download geographical statistics including samples like these: OCHA, the New York Times and JHUCSSE. Many provide a download file (or a dynamic service) that includes geographic information (latitude and longitude or region, zip code, country etc.), the number of cases, and confirmed deaths and recoveries, similar to the sample below.
© GitHub
This data can be imported or linked with your Analytics solution (Microsoft PowerBI, SAP Analytics Cloud, Tableau etc.) and visualized in various outputs such as a geomap, table or graph.
Using Query Manager, you can then link your live employee data from your SAP HCM or SAP SuccessFactors Employee Central Payroll system to the Analytics solution, as follows:
In the example below, we integrated SAP Payroll data with geo data in SAP Analytics Cloud to detail Leave Liability, leveraging SAP SuccessFactors SAP Analytics Cloud Smart Insights.
© EPI-USE Labs
Please contact me if you'd like to discuss how we can help you in any way during this difficult time.
© 2024 EPI-USE Labs
Trafford House, 11th Floor, Chester Road, Stretford, Manchester, United Kingdom, M32 0RS •Other Office Locations
Leave a Comment: