HR ANALYTICS

Paper Code: 
24MBB326
Credits: 
4
Contact Hours: 
60.00
Max. Marks: 
100.00
Objective: 

The course will enable students to effectively utilize HR analytics tools and techniques to enhance HR decision-making, create HR dashboards, perform descriptive analytics, and apply predictive HR analytics for optimizing HR processes and measuring HR value propositions.

Course Outcomes: 

Course

Learning outcome

(at course level)

Learning and teaching

strategies

Assessment Strategies

Course Code

Course Title

24MBB326

HR ANALYTICS

(Practical)

 

CO394: Apply analytics in problems related to human resource management.

CO395: Compare HR metrics and types of analytics and Decision tools in HR.

CO396: Analyse the HR Value Propositions with HR Analytics.

CO397: Communicate data driven insights of HR analytics using data visualization techniques like dashboards using MS Excel.

CO398: Implement predictive models and Data Visualization for Key HR processes.

CO399: Contribute effectively in course-specific interaction.

Approach in teaching: Interactive Lectures, Group Discussion, Tutorials, Case Study

 

Learning activities for the students:

Self-learning assignments, presentations

Class test, Semester end examinations, Quiz, Assignments, Presentation

 

12.00
Unit I: 
Introduction to HR Analytics

Meaning, Evolution of HR analytics, Benefits of HR Analytics, Challenges with HR Analytics, strategic focus on HR Analytics; HR analytics process and  LAMP framework. HR Analytics and changing role of HR Manager.

12.00
Unit II: 
HR Business Process and HR Analytics

Introduction, HR Research Tools and Techniques, Data Analysis for HR, Parametric and Non-Parametric Tests, HR Metrics-Recruitment Metrics, Training and Development Metrics, HR Scorecard, HR Dashboards, HR Analytics as a tool for HR decisions, Compelling reasons for HR Analytics.

12.00
Unit III: 
Forecasting & Measuring HR Value Propositions with HR Analytics

Introduction, Value Propositions and HR Decisions, Sustainability in HR Decisions, HR Optimization through HR Analytics, HR Forecasting, HR Plan and HR Analytics, Predictive HR Analytics.

12.00
Unit IV: 
Creating HR Dashboards using Microsoft Excel

Functions to help create dashboards- Name Range, The Developer Tab, Form Controls.

Excel Formulas for creating dashboards- VLOOKUP, INDEX, SUMIF, AVERAGEIF, COUNTIF.

Story Boarding- Connecting the Dots and Integrating the Findings.

12.00
Unit V: 
Descriptive Analytics

Overview of Selected Tools for Conduction HR Analytics: MS Excel, R. Tableau, Power BI, Python, SPSS, PSPP.

Descriptive Analytics in HR: HR Dashboards using MS Excel, Slicing and Dicing of HR Data using MS Excel Pivot Table Applications, Data Visualization for Key HR processes.

 

Essential Readings: 
  • Pratyush Banarjee, Jatin Pandey & Manish Gupta. (2015). Practical Applications of HR Analytics. Sage Publications.
  • Deepak Kumar Bhattacharyya. (2017). HR Analytics. Sage Publications.

 

References: 

Suggested Readings:

  • James, E.R. (2017). Business Analytics. UK: Pearson Education Limited.
  • Rama Shankar Yadav & Sunil Maheshwari. (2021). HR Analytics. Willey.

E resources:

Journals:

 

Academic Year: 
2024-2025
  • Printer-friendly version
  • PDF version