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 |
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 |
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.
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.
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.
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.
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.
• Pratyush Banarjee, Jatin Pandey & Manish Gupta. (2015). Practical Applications of HR Analytics. Sage Publications.
• Deepak Kumar Bhattacharyya. (2017). HR Analytics. Sage Publications.
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 [2]
• Economic Outlook
• https://www.jigsawacademy.com/blogs/business-analytics/ [3]
• https://www.geeksforgeeks.org/ [4]
• https://www.youtube.com/watch?v=qBdWiq5D9P4 [5]
Journals:
• https://vciba.springeropen.com/ [6]
• https://appliednetsci.springeropen.com/ [7]
Links:
[1] https://managementb.iisuniv.ac.in/courses/subjects/hr-analytics-practical-0
[2] https://www.expresslibrary.mheducation.com/bookshelf
[3] https://www.jigsawacademy.com/blogs/business-analytics/
[4] https://www.geeksforgeeks.org/
[5] https://www.youtube.com/watch?v=qBdWiq5D9P4
[6] https://vciba.springeropen.com/
[7] https://appliednetsci.springeropen.com/
[8] https://managementb.iisuniv.ac.in/academic-year/2025-2026