Programme Content
Introduction to the Program: A Strategic Perspective of HR Analytics
Aligning HR Analytics & Organizational Strategy
Teaching through case studies, simulations & in class exercises
Career Progression & Workforce Deployment Metrics
Employees per manager
Employee service profiling
Workforce age profiling
Workforce service profiling
Churn over index
Separation clearance time
Talent Acquisition Metrics
Fill-up ratio, Time to hire, Cost per hire
Early turnover, Termination during probation
Channel efficiency mix in terms of Direct hires, Employee referral hires, Agency hires, Lateral hires
Offer reject and renege, Fulfilment ratio, Quality of hire
Talent Acquisition to HR cost
Diversity Equity & inclusion Metrics
Workforce diversity index
Gender mix
Differently abled index
Implementation challenges
Tableau in HR Analytics
Using Tableau in HR
Learning and Development Metrics
Per cent of employee trained
Internally and externally trained
Learning hours and cost per employee, ROI calculation
Talent Retention Metrics and Talent Analytics Maturity Model
Retention index
Voluntary and involuntary turnover
Turnover by department, grades, performance, and service tenure
Internal hired index
HR Metrics Dashboard using Excel
Process of development of dashboard
Essential criteria
Leading and lagging indicators
Selection of appropriate metrics
Sources of data
KPI Dashboard using Excel and MS Power BI
Criteria of creating KPI Dashboard
Creating a sales KPI Dashboard through 9 Box Grid
HR KPI Scorecard using Excel and Orange
Calculating HR KPI
Scorecard based on Talent Acquisition, training and development
Technology and Human Dimension
Sense making of digital revolution: AI, Big Data, Augmented Reality, Automation
Managerial competencies required in digital Deep Thinking
Tableau in HR Analytics
Using Tableau in HR
Using Social Media in HR
Uses of social media for Talent Acquisition
Social Media as a tool for employer branding
Employee Gamification: As a Talent Acquisition Technique As an Employee Engagement Technique
What is Gamification
Why companies use Gamification
How gamification can help in Talent Acquisition and selection
What is employee engagement
Employee engagement survey
Use of gamification in employee Engagement
Designing HR Balanced Scorecard
Learning and Growth perspective
Customer perspective
Business Process perspective
Financial perspective
Implementing Human Resources Balanced Scorecard
Using R in HR Analytics
Hands-on exercise using R
Advanced HR Analytics for Decision Making
Hands-on exercise using SPSS
Advanced HR Analytics for Decision Making using SPSS
Regional and country level differences in turnover data
Predicting individual and team turnovers
Turnover costs for business implications
Selection decisions from previous performance data
Predictive modelling of individual and team performance
Identifying flight-risk candidates
Process of report generation
Developing a HR Analytics Unit
Go to market model
Developmental model
Structure, team, stakeholders/sponsor/champion
Analytics Culture
Working with consultant/coaches
Group Presentation by Participants
Group presentations at Campus
15Hrs. Tableau Masterclass by Nulearn
Introduction
Introduction to Tableau
Data Connection
Tableau Environment
Basic Charts
Text Tables
Highlight Tables
Pie Charts
Bar Chart
Stacked Bar Chart
Side by Side Bar Chart
Line Chart Continuous
Line Chart Discrete
Advanced Charts
Symbol Map
Filled Map
Dual Line Chart
Dual Combination
Box and Whisker
Formatting
Filters, Totals, Highlighters, Groups
Table Calculations
Sparklines
Word Cloud
Analytics
Analytics
Conclusion
Dashboard
Story
