Human Resources Analytics Dashboard for Healthcare Volunteer Retention
Date:
The team started the project by examining the data sets, which presented difficulty because the data was in a form that was common in data on staff and abilities but not amenable to analysis. They conducted an exercise in data munging to convert the data into standard forms and then developed a number of visualizations of the volunteers including their geographic distribution, age, employment status, volunteer roles and tenure (length of volunteering).
Presenting data to a nontechnical audience is an important part of the decision-making process. “Our Volunteer Services staff has very little analytical knowledge, and the community partners [Pro Bono Analytics team] were able to break down the information in a way for us to understand,” said Cheronda Rutherford, senior volunteer coordinator at Houston Methodist Hospital. Luangkesorn and his team chose to present their exploratory data analysis with a discussion on how the Houston Methodist Hospital Volunteer staff could interpret the output and take action based on different presentations.
The team presented several visualizations in a dashboard to track volunteer activity, number of active volunteers, new volunteers and volunteers becoming inactive. Using a Jupyter Notebook – a notebook that can be shared via Dropbox, GitHub, etc. – with the code hidden allowed the dashboard to be viewed in any browser and allowed the team to provide text to remind HMH staff how to interpret the results alongside the plots.