HR Analytics & People Analytics 101 Using Excel
HR Analytics & People Analytics 101 Using Excel, available at $59.99, has an average rating of 4.2, with 14 lectures, 9 quizzes, based on 471 reviews, and has 1537 subscribers.
You will learn about 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 This course is ideal for individuals who are HR employees who want to learn how businesses are using analytics to study their workforces or Students who wish to explore whether they would enjoy a career in HR Analytics or Beginner level analytics people who wonder how analytics is different in HR It is particularly useful for HR employees who want to learn how businesses are using analytics to study their workforces or Students who wish to explore whether they would enjoy a career in HR Analytics or Beginner level analytics people who wonder how analytics is different in HR.
Enroll now: HR Analytics & People Analytics 101 Using Excel
Summary
Title: HR Analytics & People Analytics 101 Using Excel
Price: $59.99
Average Rating: 4.2
Number of Lectures: 14
Number of Quizzes: 9
Number of Published Lectures: 14
Number of Published Quizzes: 9
Number of Curriculum Items: 33
Number of Published Curriculum Objects: 33
Original Price: $22.99
Quality Status: approved
Status: Live
What You Will 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
Who Should Attend
- 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
Target Audiences
- 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
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.
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction – What you'll learn
Lecture 2: Real-world examples of analytics
Lecture 3: Studying people vs. studying machines
Lecture 4: Guiding Rules for the Selection and Interpretation of Metrics
Lecture 5: How HR/People analytics is used to study employees
Lecture 6: Impact Analysis: Are we treating people fairly?
Lecture 7: Using Analytics to Find Relationships
Lecture 8: Excel Demonstration for Testing Linear Relationships
Lecture 9: How to Use Analytics to Measure the Effectiveness of Training
Lecture 10: Privacy laws
Lecture 11: The current state of HR systems
Lecture 12: Connecting to Data Sources with Excel, Tableau and Power BI
Lecture 13: The changing skills demand in Human Resources
Lecture 14: Summary
Instructors
-
Tracey Smith, MBA, MASc, BMath, CPSM
Your guide to mastering the practical use of analytics
Rating Distribution
- 1 stars: 1 votes
- 2 stars: 8 votes
- 3 stars: 78 votes
- 4 stars: 208 votes
- 5 stars: 176 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024