IIRF Online > Business > Human Resources > HR Analytics > HR & People Data and Analytics Fundamentals
HR & People Data and Analytics Fundamentals by Udemy
Learn the basics of HR data analytics | Make Better Decisions | Hands on with Excel and Sheets
Course Highlights
- 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
Skills you will learn!
Curriculum
5 Topics
Welcome & Course Overview
How to Use Udemy
Why HR & People Data Matters
Activity: Calculating Headcount
Introduce Yourself!
8 Topics
Intro to HR & People Data Basics
Identifying Data Questions to Ask
Regulatory Hurdles
Understanding Your Data's Origins & Limitations
How HR &People Data Drives Impact & The Perception of HR & People Teams
Data Hygiene: Passing the Gut Check
Data Hygiene Hands-On
Wrap-Up: HR & People Data Basics
5 Topics
Intro to HR & People Data Tools
Spreadsheets
Business Intelligence (BI) Tools
SQL & Data Warehouses
Wrap-Up: HR & People Data Tools
15 Topics
Introduction to Google Sheets
Cell Ranges Absolute and Relative Ranges
Ranges Quiz
The Averageif Function
AverageIf Quiz
The Countif Function
CountIf Quiz
The Countifs Function
CountIfs Quiz
The Unique function
Unique Quiz
The Sum function
Sum Quiz
Pivot Tables Basics
Hands On : Pivot Tables
13 Topics
Intro to Calculating HR & People Metrics
General HR & People Metrics
Calculating Headcount Metrics
Exercise: Calculate Headcount Metrics
Calculating Engagement Metrics
Exercise: Calculate Engagement Metrics
Calculating Diversity Metrics
Exercise: Calculate Diversity Metrics
Calculating Recruiting Metrics
Exercise: Calculate Recruiting Metrics
Time Series Basics
Hands On : Time Series
Wrap-Up: Calculating HR & People Metrics
5 Topics
Intro to HR & People Data Partnerships
Building Relationships
Common Ground & Buy-In
Improving Use & Utilization of Metrics
Wrap-Up: HR & People Data Partnerships
7 Topics
Intro to Presenting HR & People Data
Data Sensitivity
Executive Brief
Common Mistakes
How to Tell a Story
Presenting HR & People Data
Wrap-Up: Presenting HR & People Data
1 Topic
Thank you!
1 Topic
Coupons
HR & People Data and Analytics Fundamentals
Related HR Analytics Courses
Thank You!
Your review has been submitted successfully.