Introduction To HR Analytics

How Does HR Analytics Work

HR Verticals Where HR Analytics Can Be Used

Setting-Up HR Analytics

Benefits Of HR Analytics

HR Data

HR Metrics

Data Analysis & Visualization

Introduction To Statistics

Statistics Usage In HR Analytics

Add/ Remove/ Delete/ Color a Worksheet, Copy & Move, Hide

Basic Formatting

Cut, Copy, Paste, Format Painter

Borders, Add/ Remove rows & columns

Sort, Filter

As Values

As Link

As Formula

As Transpose

Find/ Find All

Replace/ Replace All

Format

Group/ Ungroup

Custom Filter

Remove Duplicates

Format as Table & Add on Capabilities

Data Introduction: HR Data Of An IT Company

First Visual: Who Does Maximum Overtime?

Stacked Bar Chart: Male – Female Ratio

People Graph: Keep An Eye On Headcount

Rolls Royce – Improving The Assessment Process

Credit Suisse – Saving Money By Predicting Who Will Quit

Best Buy – Relating Store Income With Engagement

Experian – Getting Ahead Of Employee Attrition

FMCG Retailer – Testing Employee Training Effectiveness

E.On – Tackling Employee Absence

Cisco – Opening A New Office

DIY – Project For 2 Weeks

Practice Material

Get All The Updates Free Of Cost

101 HR Metrics Cheat Sheet