Executive Program in HR Management

Executive Certification Program in Advanced 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