We HR professionals often ask the questions, How do I predict employee turnover? When do I make the decision to hire? These questions can be answered if we keep key HR metrics and analyze the data to make informed decisions. HR analytics and Metrics methodology and integrated process for improving the quality of people-related decisions in order to improve individual and organizational performance. In this course we take a look at the key metrics to bear in mind and the step-by-step approach to analyzing these data to help predict future organizational HR needs. We also prepare participants for HRCI Certifications who seek to hold an industry certification.
By the end of this course, Participants will be able to:
Introduction
What are Analytics?
What is HR Analytics?
Objectives of HR Analytics
What are HR Metrics?
Using Excel Functions to Investigate HR Data
Using Count and Frequency Excel Functions to determine performance ratings in Departments.
Using Max and Min Excel Functions to determine Highest Performance rating among employees.
Investigating central or typical value of employee performance ratings using Excel’s Average function
Making Promotion or Incentive decisions using the Rank and Percentile Excel functions
Checking the quality of HR Data for decision making using Deviation and variance function.
Excel Data Analysis ToolPak
What is the Excel Data analysis ToolPak?
Loading the Data Analysis ToolPak in Excel
Descriptive Statistics
What are descriptive statistics?
Making Training Decisions using Descriptive Statistics
Solving promotion business problem with Descriptive Statistics
Inferential Statistics
What are inferential Statistics?
Defining and Describing Hypothesis Testing
Solving a salary-based problem using Covariance and Correlation
Checking the effectiveness of Training programs using paired T-test
Making Training decisions using T-test with equal variance
Investigating promotion bias using ANOVA single factor
Investigating productivity decisions using ANOVA
Making hiring decisions using Z-test
Building business models for predicting HR results using Linear Regression.
Participants enrolling for this programme will be required to have basic computing skills. Participants who meet the programme requirement should pay the course fee and complete the enrollment form 2 weeks before the programme kick off date.
Requirements:
Prospective applicants who do not meet the programme requirement but want to join the programme should talk to a Career Advisor.
The HR Analytics and Metrics: Using Data to make HR decisions training approach employs hands-on learning, which imparts the skills required for specific job roles
The HR Analytics and Metrics: Using Data to make HR decisions course provides up to 4 months of internship while working on real work projects, which adds expertise and verifiable work references in the resident country.
The HR Analytics and Metrics: Using Data to make HR decisions course assists participants in securing a job through the development of a professional profile and job prospecting.
Lead L&D Consultant • Nigeria
MBA in Human Resource Management; Data Science for Business certification from Harvard Business School.
Chukwuma Agomo is a seasoned HR professional and data analyst with an MBA in Human Resource Management and a Data Science for Business certification from Harvard Business School. As the Lead L&D Consultant at Primer Hub Limited, he combines strategic thinking with practical skills to design impactful training programs that enhance employee engagement, productivity, and performance. His expertise includes leadership development, data-driven HR strategies, and diversity and inclusion initiatives. Chukwuma has successfully led projects such as leadership programs for multinational corporations and data analyses of employee turnover, earning recognition as a top trainer and sought-after speaker in his field.
Piston and Fusion offer the Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See dates and fees for classroom and virtual online class
19th May – 21st May, 2025
As of Thu Mar 27 2025
Mon – Wed
8:30am – 3:30pm
3 days
Contact Us
19th May – 21st May, 2025
As of Thu Mar 27 2025
Mon – Wed
8:30am – 3:30pm
3 days
Contact Us
Piston and Fusion offer the Course as Classroom in Lagos and Virtual Online Class in other states in Nigeria. See dates and fees for classroom and virtual online class.
Virtual Only
-
-
-
-
-
-
Virtual Only
3 Months
-
-
-
CV & LinkedIn Profile Development
Exam Application (Only for Certification courses)
Classroom & Virtual
Print & PDF
-
Teabreak & Lunch
Souvenir
Notepad & Pen
-
-
Classroom & Virtual
Print & PDF
Print & PDF
3 Months
Tea Break & Lunch
Souvenir
Notepad & Pen
CV & LinkedIn Profile Development
Exam Application (Only for Certification courses)
This programme is designed for executives tasked with igniting innovation within their organisations, or who seek to create innovative solutions to a major challenge.
Are you a corporate client looking to upskill your team?
To register multiple employees for our courses, please fill out this form to request a proposal.
We’ll provide you with a detailed quote, outlining the costs and benefits of your chosen courses. Once approved, we’ll generate an invoice for payment.
Let’s elevate your team's skills together!
https://www.pistonandfusion.org/enrol-now?type=corporate&course=hr-analytics-and-metrics-using-data-to-make-hr-decisionsWe help you decide if this course is a good match for your career. We can also help you plan and develop a career path.
We help you decide if this course is a good match for your career. We can also help you plan and develop a career path.