: HR ANALYTICS (Practical)

Paper Code: 
25MBB326
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 Outcomes (COs)

Course

Learning outcome

(at course level)

Learning and teaching

strategies

Assessment Strategies

Course Code

Course Title

25MBB326

HR ANALYTICS

(Practical)

 

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

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

CO357: Analyse the HR Value Propositions with HR Analytics.

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

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

CO360: 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:
• McGrawHill Publishers (23 titles), https://www.expresslibrary.mheducation.com/bookshelf
• Economic Outlook
• https://www.jigsawacademy.com/blogs/business-analytics/
• https://www.geeksforgeeks.org/
• https://www.youtube.com/watch?v=qBdWiq5D9P4
Journals:
• https://vciba.springeropen.com/
• https://appliednetsci.springeropen.com/

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