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.
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:
Please contact me if you'd like to discuss how we can help you in any way during this difficult time.