Autoplay
Autocomplete
Previous Lesson
Complete and Continue
People Analytics Certification Course
Section 1 - Introduction
Instructor Introduction (1:28)
How to Navigate the Course (1:59)
What is People Analytics (9:27)
Becoming a People Analytics Expert (5:51)
The Importance of an HR Team (4:58)
Most Common Uses for People Analytics (7:51)
People Analytics Misconceptions (6:15)
Quiz #1
Section 2 - Create a Plan
Introduction - Preparing For HR Analytics (0:53)
How to Create an Analytical Hypothesis for HR (5:41)
People Analytics Preparations (9:02)
Create a People Analytics Plan (11:00)
How to Make Constructive Predictions (10:54)
Quiz #2
Section 3 - Introduction to Data Presentation
Make People Analytics Convincing (11:46)
Evaluation Plan - Analyzing Long-Term Success (9:30)
Presenting Data & Results (8:34)
Getting the Most Out of Data & Results (9:30)
Quiz #3
Section 4 - Employee Lifetime Value
Employee Lifetime Value (12:23)
Getting the Most Out of Employee Lifetime Value (11:15)
Attracting & Acquiring the Right Talent (12:26)
Increasing Employee Productivity (9:14)
Understanding & Minimizing Employee Churn (12:09)
Quiz #4
Section 5 - Excel Basics
Basic HR Calculations (13:11)
Basic Mathematical Functions in HR (16:08)
Textual Functions (9:55)
Logical Functions (8:25)
Date and Time Funtions (4:15)
Lookup Functions (11:49)
Data Tools (15:28)
Quiz #5
Section 6 - HR Analytics Basics
HR Metrics (2:14)
HR Performance Metrics (7:07)
Recruitment Metrics (4:15)
HR General Metrics (3:03)
HR Case Study - The Overview (3:58)
HR Case Study - Absenteeism (9:24)
HR Case Study - Turnover Rate (4:35)
HR Case Study - ENPS (5:58)
HR Case Study - Vlookup (2:05)
HR Case Study - Analysis (3:05)
Quiz #6
Section 7 - HR Statistics
Introduction to Statistics in HR (4:04)
Types of Statistics in HR (4:06)
Describing Data Visually (5:03)
Measures of Central Tendency (2:17)
Measures of Dispersion (2:19)
Section 8 - Collecting Data
Collecting HR Data (2:37)
Employee Data Collection Best Practices (6:31)
How to Collect HR Data (5:49)
Types of HR Data (9:01)
Quiz #7
Section 9 - HR Charts
HR Data Visualization (5:24)
Chart Elements (4:18)
Tips for Creating Charts (4:33)
Chart Formatting (11:25)
Line Chart (6:05)
Area Chart (5:57)
Pie Chart (7:26)
Danger of Using Pie Charts (2:00)
Scatter Plots (7:02)
Frequency Distribution (4:09)
Sparklines (2:15)
Maps Chart (5:58)
Section 10 - HR Dashboard
HR Dashboards (1:52)
HR Dashboard - Age Distribution (3:40)
HR Dashboard - Gender Distribution (3:30)
HR Dashboard - Employee Wellness Uptake (4:24)
HR Dashboard - Absence Days Distribution (2:50)
HR Dashboard - Performance Scores (2:35)
HR Dashboard - Employee Wellness Survey (2:18)
Dashboard Formatting (6:28)
Section 11 - Pivot
Pivot Tables (9:00)
Pivot Charts (6:14)
Data and Tables Formatting (15:46)
Named Ranges (5:57)
Shortcuts (2:55)
Pivot Chart - Dashboard (7:32)
Pivot Chart - Formatting (9:06)
Quiz #8
Section 12 - Pinpoint Metrics & Creating an HR Sheet
Using The Right HR Metrics (6:49)
Preparing HR Data (4:03)
Obtaining Data Insights (17:00)
Quiz #9
Section 13 - Interpreting Data
Interpreting HR Data (6:51)
Common Errors in Interpreting HR Data (6:20)
Validating HR Data (4:05)
Section 14 - HR Analytics in Practice (Onboarding)
Onboarding Effectiveness (9:10)
Using an Onboarding Effectiveness Assessment Tool (6:50)
Using a Survey Tool (7:06)
Intepreting Data with a Survey Tool (4:13)
Using an HR Satisfaction Survey (3:12)
Section 15 - HR Survey Examples
HR Surveys for Data Collection (1:33)
Using Survey Templates (1:32)
Employee Satisfaction Survey (2:05)
Employee Engagement Survey (2:24)
Performance Appraisal Survey (2:52)
Employee Exit Survey (0:33)
Professional Development Survey (1:31)
Work From Home Survey (1:17)
Employee Onboarding Survey (1:12)
Change Management Survey (1:18)
Employee Wellness Survey (1:35)
360-Degree Survey (1:37)
Final Certification Test
Certification Test
Congratulations (1:48)
Basic Mathematical Functions in HR
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock