HR Analytics & People Analytics 101 Using Excel
What you'll learn
- Can we use data to reduce the impact of a planned downsizing of the workforce?
- How to calculate fairness in hiring, promotions and performance reviews
- How to calculate the effectiveness of learning/training programs
- How to select HR metrics and what happens when you ignore Rule #3!
- Practical applications of HR/People Analytics
- How HR teams are using data analytics to improve the employee / employer experience
- How to determine correlations/relationships in your HR data
- Concerns and ethical considerations associated with HR Analytics
- Basic statistical techniques (which comes with simple explanations)
- HR Data privacy policies
- Basic to Intermediate Excel skills
- Basic arithmetic (add, subtract, multiply, divide)
- Be curious and have a thirst for knowledge!
You do not need to be a math expert to take this class. All concepts taught are explained in simple terms. Join me to build your confidence around using HR data!
HR Analytics, also called People Analytics, talent analytics and workforce analytics has been increasingly used in corporate Human Resources (HR) teams.
This class is a beginner level introduction. It is intended for:
HR employees who want to learn how businesses are using analytics to study their workforces,
Students who wish to explore whether they would enjoy a career in HR Analytics, and
Beginner level analytics people who wonder how analytics is different in HR.
This course is not intended for analytics and statistical experts.
The course begins with real-world examples of analytics and the additional challenges that come with trying to study people. You will learn how HR teams are using analytics to improve the workplace for employees, to increase the bottom line for their business and to ensure fairness in the workplace.
I will present a step-by-step guide for approaching any analytics problem by beginning with the “business question.”
You will learn Tracey’s three fundamental rules for properly selecting which metrics to measure and what happens when you ignore Rule #3!
You will have several opportunities to practice your analytics skills in Excel (or in the tool of your choice) to answer real-world HR questions and provide HR leaders with decision-making advice based on your analysis.
Should your HR leader be concerned about turnover trends? Why are employees really leaving the company?
Can we use data to reduce the impact of a planned downsizing of the workforce?
Can we optimize recruitment from college and university campuses to help our leader reduce recruitment costs?
Are our hiring practices fair? You will learn how HR and Legal teams test for fairness by conducting an impact analysis.
We will install Excel’s free Data Analysis Toolpak to learn even more analytical techniques (or you can use the tool of your choice). While these techniques fall under the topic of statistics, do not worry if you are not a math expert. These techniques are easy to understand and I have taught them to thousands of non-mathematical students.
You will learn how to test if variables are related to each other, i.e., does a change in one create a change in another? I will teach you techniques to:
Test if performance scores are related to an employee’s salary,
Explore which factors can affect safety incidents, and
Understand how to properly analyze pay gaps.
I’ll provide simple explanations for how to use additional statistical tests to determine:
Whether a training workshop was effective and remained effective.
You’ll conclude the course learning:
HR’s role in protecting the privacy of employee data,
How confidential data is accidentally released, and
How different countries have implemented privacy regulations.
You will have the opportunity to answer quizzes throughout the course and be able to download multiple free reference sheets to guide you in your data analysis projects and pick mathematical techniques.
If that sounds like something that you’d love to learn, join me by registering for this class.
Download links Included:
Template: How to approach a business problem
Template: Diversity strategy
Reference sheet for picking statistical tests
Reference sheet to estimate the cost of turnover
Time Required to Complete Course
Video Learning Time: 1 hour
Additional time to complete the optional assignments: 1-3 hours (depending on skill level in Excel)
Testimonials from Former Students:
"Tracey's experience and wealth of knowledge is clear in the way she presents, explains new concepts and makes content relevant to students by providing real life examples. She has an amazing teaching style which allowed me to quickly grasp a topic I had struggled with during a whole term in my university days."
"This is a great course for HR Professionals who are already conducting some sort of reporting or data analysis and are looking to improve upon these skills. This course offers a lot of valuable information about analytics that I will benefit in the future moving forward."
"Tracey is a wonderful instructor with immense knowledge. Her teaching style was great and I thoroughly enjoyed learning from her."
I have taught several thousand students the basics of HR Analytics in-person and online. Feel free to explore additional comments on the Udemy platform.
Who this course is for:
- HR employees who want to learn how businesses are using analytics to study their workforces
- Students who wish to explore whether they would enjoy a career in HR Analytics
- Beginner level analytics people who wonder how analytics is different in HR
Tracey Smith has advised companies like Adidas, Continental Tire, FedEx, Northwestern Mutual, Shape Corporation, TD Bank, Kobo, Equitable Bank, Centura Health, Aviso Wealth, and global tech companies in the field of analytics.
She has 25+ years of experience in analytics and been recognized as one of the "top 50 influencers in HR analytics" and a certified Supply Management Professional. She is repeatedly listed as an "expert to watch" in her field.
Tracey is the President of Numerical Insights LLC, a boutique consulting company that specializes in business analytics. She holds multiple degrees in applied mathematics, mechanical engineering, supply chain and business.