I have had the opportunity to work for both small and large employers – including one of the largest employers in the world. In both cases, there were some other payroll technologies used in addition to SAP or ...
Senior Vice-President of HCM Solutions Danielle Larocca has worked in the SAP HCM space for over 20 years. An SAP Mentor and featured speaker at numerous conferences, Danielle has authored four best-selling books on SAP, is the Technical Editor for the SAP Professional Journal, and often the Voice of the Expert on SAPInsider’s Ask the Expert series for HR.
We recently gave a webinar around how Query Manager can be used to feed data to Analytics systems. One of the attendees asked if the solution could be leveraged to help organizations identify employees most impacted by the COVID-19 pandemic.
We quickly put something together that takes advantage of the data released by reputable sources, including governmental authorities and global organizations such as the WHO, to show you how you can do this yourselves.
A simple Google search will allow you to download geographical COVID-19 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:
Your employee data, plus the data provided around statistics for COVID-19, allows you to create analytics similar to the sample shown below.
© EPI-USE Labs
Please contact me if you'd like to discuss how we can help you in any way during this difficult time.
© 2023 EPI-USE Labs
Trafford House, 11th Floor, Chester Road, Stretford, Manchester, United Kingdom, M32 0RS •Other Office Locations
Leave a Comment: