HR ANALYTICS

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

This course will enable the students to equip them with the essential skills and knowledge necessary to data-driven decision in HR

Course Outcomes: 

Course

Learning outcome (at course level)

Learning and teaching strategies

Assessment Strategies

Course

Code

Course

Title

24MHR326

HR

Analytics

(Practical)

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

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

CO165: Analyze the HR Value Propositions with HR Analytics.

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

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

CO168: 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

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

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

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

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

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