HR Analytics, KPIs & Performance Management Professional Certificate
Build practical skills in hr data & metric design, excel for hr analytics, dashboards & storytelling.
Programme overview
Build practical skills in hr data & metric design, excel for hr analytics, dashboards & storytelling.
What you’ll study
01HR Data & Metric Design
HR data model, data quality, confidentiality, KPI logic, headcount, turnover, absenteeism, recruitment and training metrics.
Practical work: Create a data dictionary and KPI catalogue.
02Excel for HR Analytics
Cleaning, lookups, formulas, pivots, charts, error checks and repeatable reporting.
Practical work: Clean and analyse a simulated HR dataset.
03Dashboards & Storytelling
Dashboard design, trend/variance analysis, filters, management summaries and avoiding misleading charts.
Practical work: Build an HR dashboard in Excel or Power BI.
04Performance Management Analytics
Goal design, rating quality, calibration concepts, performance distributions, development and fairness.
Practical work: Analyse a simulated performance-review dataset.
05Workforce & Recruitment Analytics
Funnel metrics, time-to-fill, source effectiveness, capacity, turnover risk indicators and scenario planning.
Practical work: Build a recruitment/workforce analysis.
06People Analytics Capstone
Business question, dataset, analysis, recommendations, ethics/privacy and executive presentation.
Practical work: Deliver a complete people-analytics case and presentation.
Tools & learning resources
- Excel
- Power BI optional
- HRIS demo exports
- Google Sheets
- Presentation tools
Practical projects & portfolio
- KPI dictionary
- Excel HR model
- Dashboard
- Recruitment/performance analyses
- People analytics capstone
Who can apply?
Excel basics and some HR/business understanding. HR03 recommended for complete beginners.