HR Analytics

8 Hours Introduction to HR Analytics: Evolution of HR Analytics, HR information systems and data sources, Evolution of HR Analytics; HR Metrics and HR Analytics; Intuition versus analytical thinking; HRMS/HRIS and data sources; Analytics frameworks like LAMP, HR Scorecard & Workforce Scorecard.

8 Hours Human Resource Planning and forecasting: Quantitative and Qualitative Dimensions of HR Planning, Methods and Techniques of HR Demand Forecasting, Data Base for Manpower Forecasting. Recruitment and Selection Analytics: Evaluating Reliability and validity of selection models, Finding out selection bias, Predicting the performance and turnover.

8 Hours Performance Analysis: Predicting employee performance, Training requirements, evaluating training and development, Optimizing selection and promotion decisions, Analyzing and Classifying training needs, Measuring training effectiveness, Predicting training effectiveness and performance. Designing a Compensation System: Understanding compensation Analytics, quantifiable data, Factors affecting Compensation & Benefits, Analytics for compensation planning, Competency Scorecard.

4 Hours Monitoring impact of Interventions: Tracking impact interventions, Evaluating stress levels and value-change. Formulating evidence based practices and responsible investment, Evaluation mediation process, moderation and interaction analysis.

8 Hours Applications of HR Metrics and Creating HR Dashboards: HR Metrics, Types of HR Metrics, Staffing Metrics, Training and Development Metrics, Application-oriented Exercises : Dashboards: Few Key Excel Add-ins/Functions to Help Create Dashboards, Name Range, The Developer Tab, Form Controls, Important Excel Formulas Useful for Creating Dashboards, VLOOKUP, INDEX, SUMIF, AVERAGEIF and COUNTIF, Application of Excel Functions in Creating HR Dashboards, Storyboarding: Connecting the Dots and Integrating the Findings.