image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

If you're interested in getting a better understanding of what HR (Human Resource) or People data is, how it can by analyzed, and used, and how it can help you drive impact, then this course is for you. I designed this course specifically for individuals just getting started on a Human Resources or People team, or for individuals who are interested in learning the basics of HR or People data and analytics.
No prior HR experience is necessary,
but basic knowledge of Google Sheets or Excel will be very helpful.
This course is a great source for anyone interested in learning more about HR and People data, including:
Human Resource / People Generalists
Human Resource People Specialists
Human Resources Business Partners (HRBPs)
People Managers
Executives
and more!
We'll cover the many places HR and People data can come from, including some common challenges (such as abbreviations and nicknames). This course also explores how to partner with other teams to improve how HR and People data is collected - something that will make your work as a HR or People data analyst more satisfying and increase the impact you will have on your team.
You'll also get hands on and learn how some basic HR and People metrics are derived, including things like
headcount, engagement,

diversity, and recruiting metrics
. We'll get hands on in Google Sheets and Microsoft Excel to learn how to calculate various metrics and use other features of those tools. We certainly won't get into every HR and People metric, but by the end of the course you'll be able to use fundamental metrics to help your organization better understand its most important asset - its people.
In this course you will be exposed to some core skills needed to understand HR data, including:
Where HR and People data comes from
What HR and People data can be used for
How common metrics, such as turnover, are calculated
How to avoid common “gotchas” in HR and People data
How to present HR and People data to leadership
Please join me in this course and start using data to positively influence your organization!
Who this course is for:
Entry/mid-level HR and People employees (including HR or People Generalists, Specialist and HR Business Partners) who need to understand the basics of HR metrics to gain context of their role and company
Managers curious to understand how HR analytics and data can help them better understand how their team(s) are functioning
This course is NOT for those with a background in HR data science or executive level HR employees
Individuals looking to learn how Microsoft Excel or Google Sheets can be used to calculate HR metrics

What you'll learn

Explore the basics of HR data & people analytics and what makes it unique

Familiarize yourself with basic HR analytics tools and what they are used for

Conduct fundamental HR & people analytics activities, such as data cleaning

Perform basic HR analytics using mock data

Identify teams to partner with to improve how your organization uses HR data

Present HR data clearly and concisely for maximum impact

Calculate metrics with Google Sheets or Microsoft Excel

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
6
1.1-Welcome & Course Overview
1.2-How to Use Udemy
1.3-Why HR & People Data Matters
1.4-Activity: Calculating Headcount in Google Sheets
1.5-Activity : Calculating Headcount in Microsoft Excel
1.6-Introduce Yourself!
2-HR & People Data Basics
8
2.1-Intro to HR & People Data Basics
2.2-Identifying Data Questions to Ask
2.3-Regulatory Hurdles
2.4-Understanding Your Data's Origins & Limitations
2.5-How HR &People Data Drives Impact & The Perception of HR & People Teams
2.6-Data Hygiene: Passing the Gut Check
2.7-Data Hygiene Hands-On
2.8-Wrap-Up: HR & People Data Basics
3-HR Data Tools
5
3.1-Intro to HR & People Data Tools
3.2-Spreadsheets
3.3-Business Intelligence (BI) Tools
3.4-SQL & Data Warehouses
3.5-Wrap-Up: HR & People Data Tools
4-Google Sheets and Microsoft Excel Basics
23
4.1-Introduction to Google Sheets
4.2-Introduction to Excel
4.3-Google Sheets Basics - Cell, Ranges, Absolute and Relative Ranges
4.4-Excel Basics - Cells, Ranges, Absolute and Relative Ranges
4.5-Ranges Quiz
4.6-Google Sheets - The Averageif Function
4.7-Excel - The Averageif Function
4.8-AverageIf Quiz
4.9-Google Sheets - The Countif Function
4.10-Excel - The Countif Function
4.11-CountIf Quiz
4.12-Google Sheets - The Countifs Function
4.13-Excel - The Countifs Function
4.14-CountIfs Quiz
4.15-Google Sheets - The Unique Function
4.16-Excel - The Unique Function
4.17-Unique Quiz
4.18-Google Sheets - The Sum Function
4.19-Excel - The Sum and Sumif Functions
4.20-Sum Quiz
4.21-Google Sheets - Pivot Tables Basics
4.22-Excel - Pivot Table Basics
4.23-Google Sheets - Hands On : Pivot Tables
5-Calculating HR & People Metrics
17
5.1-Intro to Calculating HR & People Metrics
5.2-General HR & People Metrics
5.3-Google Sheets - Calculating Headcount Metrics
5.4-Excel - Calculating Headcount Metrics
5.5-Exercise: Calculate Headcount Metrics
5.6-Google Sheets - Calculating Engagement Metrics
5.7-Excel - Calculating Engagement Metrics
5.8-Exercise: Calculate Engagement Metrics
5.9-Google Sheets - Calculating Diversity Metrics
5.10-Excel - Calculating Diversity Metrics
5.11-Exercise: Calculate Diversity Metrics
5.12-Google Sheets - Calculating Recruiting Metrics
5.13-Excel - Calculating Recruiting Metrics
5.14-Exercise: Calculate Recruiting Metrics
5.15-Google Sheets - Time Series Basics
5.16-Google Sheets - Hands On : Time Series
5.17-Wrap-Up: Calculating HR & People Metrics
6-HR Data& People Partnerships
5
6.1-Intro to HR & People Data Partnerships
6.2-Building Relationships
6.3-Common Ground & Buy-In
6.4-Improving Use & Utilization of Metrics
6.5-Wrap-Up: HR & People Data Partnerships
7-Presenting HR & People Data
7
7.1-Intro to Presenting HR & People Data
7.2-Data Sensitivity
7.3-Executive Brief
7.4-Common Mistakes
7.5-How to Tell a Story
7.6-Presenting HR & People Data
7.7-Wrap-Up: Presenting HR & People Data
8-Conclusion
1
8.1-Thank you!
9-Bonus Section
1
9.1-Coupons