HR Data Analytics
Turn workforce data into clear dashboards and insights that guide hiring, retention and workforce planning decisions.
Duration
6 weeks
Next start
Next cohort starts 11 January 2027. Enrol now to secure your seat.
Format
Live online
Level
Intermediate
Seats
25 per cohort
Today's HR leaders are expected to back their recommendations with evidence. This hands-on course gives you the analytical mindset and practical Excel skills to collect, clean and analyse people data, build dashboards leadership will actually use, and explain what the numbers mean for the business.
You will work through realistic Ghanaian and African workplace scenarios, using ready-made templates you can adapt for your own organisation from week one.
Who is this for? HR officers and managers, HR Business Partners, people analytics specialists, and anyone responsible for workforce reporting, retention analysis or HR planning.
- Basic working knowledge of Excel or Google Sheets
- A laptop with Microsoft Excel (2016 or later) or Google Sheets
- Stable internet connection for live online sessions
- Calculate and interpret core HR metrics such as turnover, absenteeism, time to hire and cost per hire
- Clean and analyse HR data confidently in Excel using pivot tables, lookups and charts
- Build an HR dashboard that gives leadership a clear monthly view of the workforce
- Analyse retention risk and estimate the true cost of staff turnover
- Support workforce planning with headcount, succession and skills gap forecasts
- Track diversity and inclusion indicators responsibly
- Present people data as a clear, persuasive story to senior management
- Why data matters in modern HR
- Core HR metrics and how to calculate them
- Collecting and cleaning people data