HR Analytics & HR MIS Professional
HR analytics and HR management information systems. Course outline to be confirmed by EPIQ. Duration: 40 hours.
Who this course is for
HR professionals seeking practical HR reporting, Excel and analytics skills.
What you will learn
- HR data fundamentals
- Recruitment analytics
- Attrition analytics
- Absenteeism
- Headcount
- Productivity
- Cost-per-hire
- Time-to-hire
- Hiring funnel
- HR dashboards
- Excel for HR
- Pivot tables
- XLOOKUP and VLOOKUP
- Conditional formatting
- HR reporting
Practical application
- 1Build an HR dashboard
- 2Analyse headcount
- 3Analyse hiring and recruitment funnel data
- 4Analyse attrition and absenteeism
- 5Compare department-wise data
- 6Create monthly HR trends and management reports