Executive HR Analytics

Human Resource Management, Technology and Analytics

HRM In Changing Context

About HR Analytics

What is HR Analytics?

Key Objectives Of HR AnalyticS

Critical Areas Of People Analytics Skills Required For HR Analytics

HR Technology Overview

HR Analytics Popular Frameworks s

Advanced HR Analytics

Basics of statistics

Mean median & mode, Correlation , HR Case study of correlation

Linear regression, HR Case study of Linear regression, Logistic regression

The Anatomy of statistical model, knowledge check.

Business problem understanding and knowledge check.

Data Discovery & Collection, knowledge check

Introduction to Data preparation, uni-variate analysis

Feature engineering, reliability testing, Bi-variate analysis and Hypothesis Testing,

Employee data, data sources and metrics

Introduction to HR Metric

Metrics in critical areas of HR

Key metrics for each vertical of HR

Recruitment Metrics, Diversity Metrics, Talent Retention Metrics, Training & Development Metrics, Workforce Deployment Metric

The importance of Strategic Workforce Planning

Analyse the link between the business and HR

Linking Human Resources To ROI

Quantifying the workforce

Calculating ROI

Activity-based costing

Costs of Absenteeism Direct and Indirect Costs

Calculating ROI

Utility Models

HR Cost Benefit Metrics

Dashboards and Scorecards

HR Metrics Dashboard

KPI Dashboard

HR KPI Scorecard

Employee data visualization

Popular tools available for visualization

Interactive and static dashboards and reports

Statistics, HR Analytics Tools Excel, Python and R

Overview of HR Analytics Tools: R, Python, Excel, Power BI, Tableau

Choosing the right HR analytics tool

Installation and Introduction to Python

Installation and Introduction of R and Rstudio

Importing Excel File in Python and R

Using Analytics Tools for Statistical Analyses

Data Visualization with Excel

The HR3P Model in Excel

Create a visualization of the HR3P model

Understand the meaning behind skewed performance

Utilize PivotTables to generate new HR3P insights

Usage of colors to visualize PivotTables

Use the HR3P model in succession planning

Creating a Workforce Map

Explain the importance of HR reporting

Understand the key variables in HR dashboards

Workforce Scenario Analysis

Explain the importance of scenario planning

Understand the ID-principle in scenario planning

Describe the different steps in scenario planning