Human Resources

HR Analytics with Excel & Power BI

Use people data to answer HR questions on hiring, attrition, engagement and productivity.

4.7★★★★★(78 reviews) 580 learners 10 modules · 77 lessons · 2,100 min Intermediate English

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 min

Planned 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

SG

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.

Keep Exploring

More in Human Resources