Executive Program In HR Analytics

Module Name 

Topics 

Introduction to the Program: A Strategic Perspective of HR Analytics 

• Aligning HR Analytics & Organisational 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 & 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 an 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

15 Hours Tableau Masterclass

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

HR Data Analyst 

Diversity and Inclusion Analyst 

Talent Analyst 

Performance Analytics Manager 

Workforce Planner 

Learning and Development Analyst 

Compensation Analyst 

HR Metrics and Reporting Specialist 

Employee Engagement Analyst 

Organisational Development Analyst