HR Analytics with Excel & Power BI
Use people data to answer HR questions on hiring, attrition, engagement and productivity.
Created by Shalini Gupta, HR Business Partner
What you'll learn
- Measuring HR KPIs
- Analysing attrition
- Building HR dashboards
- Making data-driven people decisions
Course curriculum
10 modules · 77 lessons · 2,100 minPlanned outline shown above (sample metadata). The detailed module and lesson list for this course hasn't been published yet.
Description
Use people data to answer HR questions on hiring, attrition, engagement and productivity.
What this course covers: HR metrics and KPIs, cleaning HR data in Excel, attrition and retention analysis, recruitment funnel analytics, HR dashboards in Power BI and presenting people insights to leadership.
Skills you will build: measuring HR KPIs, analysing attrition, building HR dashboards and making data-driven people decisions.
Practical applications: HR operations in growing companies, people-management roles and HR policy design.
Who should take this course: HR professionals who want to make decisions with data. It suits learners who already know the basics of human resources.
Learning outcomes: by the end of the course you should be able to apply HR metrics and KPIs and measuring HR KPIs in your own work, and know which areas to practise next.
Requirements
- Basic knowledge of human resources
- A computer with internet access
Your instructor
Shalini Gupta
HR Business Partner · 14+ years of experience
Shalini Gupta is a hr business partner with 14+ years of experience in human resources. Shalini teaches recruitment and selection and onboarding with practical, step-by-step examples.
Reviews
-
N
Naveen K. 4.5/5 Sample review
Good balance of theory and practice. The attrition and retention analysis lessons helped me apply building HR dashboards in real situations. Practical, India-relevant examples on payroll and compliance.
-
P
Pranav D. 4.5/5 Sample review
Well organised. Revisiting the attrition and retention analysis part a second time really helped it click. The engagement ideas were easy to roll out with my team.
-
D
Deepa J. 4.5/5 Sample review
I joined to get better at measuring HR KPIs. The practical exercises on HR metrics and KPIs were exactly what I needed. Interview scorecards from the course are now part of our hiring process.
Sample reviews are illustrative demo content, not verified purchases. Ratings from learners will appear here once submitted.