MEASURING THE IMPACT OF CORONAVIRUS
We may be living in uncertain times, but you need to be certain that you understand the impact that COVID-19 is having on your workforce.
As the Coronavirus pandemic grows, all business leaders need to regularly review their workforce and review the impact of COVID-19 on their health and business productivity.
So, we asked our technology expert, to document his process creating a Coronavirus impact dashboard, which will allow businesses to do just that.
STEP ONE - WHAT QUESTIONS HAVE TO BE ANSWERED?
Firstly you need to brainstorm a big list of questions that you want this dashboard to answer. This is the most important part of the process and should be carefully thought through and adjusted to show the adaptation of your business in the face of these challenges.
But having said all that, here’s where I would start:
- What % of our workforce can move to work remotely?
- What % have already moved to remote work due to Coronavirus?
- What % of our workforce is inactive due to Coronavirus?
- What are the infection rates in the locations where we have employees?
- What is the trend in our employee infection rates and how does that compare to the relevant locations?
- Which locations are significantly affected by COVID-19 related absences?
- What is the average duration of employee unavailability due to COVID-19?
- What % of our infected workforce has recovered and returned to work?
- What % of our temporarily remote workforce has returned to working on location?
- How long are impacted employees non-productive for?
- How much productive capacity have we lost?
STEP TWO - DO YOU HAVE THE DATA YOU NEED TO ANSWER THESE QUESTIONS?
In many cases, companies will have an effective HRIS which will capture the required data points.
But don’t worry if you’ve got some gaps. This just means HR will need to work with managers to gather the pertinent workforce data. A simple spreadsheet would suffice, to track absence and worker status info.
The key data points that you should be considering are:
- Ability to work from home
- Currently working from home
- Date employee stopped working
- Date employee returned to work
- Date employee in a Quarantine status
- Date employee in an Infected status
- Date employee cleared of Quarantine/Infected status
If we combine this event-based data with the usual HRIS data (employment type, location, P.I) then we can analyse workforce impact to the business over time.
STEP THREE - WHAT METRICS DO YOU NEED TO GET ANSWERS FROM THE DATA?
So now you know what you need to answer, and you’ve identified the data that holds the answers. But how do you turn this data into genuinely helpful insights?
With the help of metrics! Here’s what I would use:
Workforce Composition & Employee Health
- Headcount % – Quarantine, Infected, Recovered statuses
- Currently Working %
- Working from Home
Impacts on Productivity
- % Currently Working – Including Active, Quarantine, Infected
- % Able to WFH/Remote
- Lost productive hours (when people stop and return to work)
Duration of Quarantine and Infection
- Days in Quarantine
- Days from Infection to Recovered
- Number of Reinfections, Reinfection Rate
STEP FOUR - EXTENSION OPPORTUNITIES
The above metrics are really just the bare-bones. But, of course, there are many more attributes available that you might want to incorporate.
These will be specific to each business’ strategy so my advice is to include a number of common HRIS fields into the data collection process when you build your initial data set so you can segment later as needed.
Suggested other data elements to consider adding
- Succession – can we tap into the successors for persons in critical roles? How impacted are these successors?
- Critical roles – prioritize remote work arrangements or advise early preventive quarantine measures for specific roles in certain areas.
- Skills data – capture potential temporary backfills for employees that are unable to work.
- Set-up expense tracking – spending to facilitate remote working capabilities.
- Re-infection rates – tracking of persons previously cleared.
Want us to build a dashboard that measures the impact of coronavirus on your business? Pop in your details and we’ll be in touch.