UNIQUE SERIES AKTU Syllabus
BMBAHR04

HR Analytics using Power BI

L-T-P3-0-0 Session2025-26 TypeTheory
Appears in 1 semester

MBA Business Analytics · Sem 4 (Specialization: Human Resource Management (HR))

Download PDF

Syllabus

5 units · 40 lecture hours
Unit1

Unit 1: Foundations of HR Analytics and Power BI Overview

8 hrs

Introduction to HR Analytics, Evolution from HRIS to data-driven decision-making, Overview of HR metrics and their strategic significance, HR analytics frameworks: LAMP, HR Scorecard, Workforce Scorecard, Overview of Power BI interface, Importing HR data from Excel/CSV/SQL, Data types, data modeling basics, Hands-on: Building your first Power BI HR report

Unit2

Unit 2: Workforce Planning, Recruitment & Selection Analytics with Power BI

8 hrs

Quantitative and qualitative dimensions of HR forecasting, Methods of HR demand forecasting, Data preparation for workforce analytics, Building forecasting visuals in Power BI (line charts, KPIs), Recruitment funnel metrics: sourcing, screening, selection, Analyzing selection model reliability and bias, Visualizing attrition and turnover risk using Power BI, Predictive hiring using trend visuals and filters

Unit3

Unit 3: Performance, Training & Compensation Analytics Using Power BI

8 hrs

Performance evaluation data preparation, Creating dashboards for performance tracking, Measuring training effectiveness using HR KPIs, Predicting training needs and skill gaps, Designing compensation metrics (pay ratio, equity, benchmarks), Power BI visuals for salary analysis (histogram, matrix), Competency scorecards and promotion decisions using slicers and filters, DAX functions to calculate HR indicators (Average, % Growth, Ratio)

Unit4

Unit 4: Monitoring Interventions & Employee Well-being Analytics

8 hrs

Tracking impact of HR interventions (L&D, engagement, retention), Using Power BI for stress level and pulse survey analysis, Moderation and mediation insights using calculated columns, Data-driven decisions using scenario analysis, Visualizing pre/post-intervention trends, Using Power BI Q&A and smart narratives for insights, Building HR evidence-based dashboards with annotations

Unit5

Unit 5: HR Metrics Dashboarding and Storytelling in Power BI

8 hrs

Types of HR metrics: recruitment, development, performance, retention, Building KPI tiles and drill-through dashboards in Power BI, Advanced HR dashboards: Attrition, DEI, training ROI, Use of bookmarks, filters, tooltips for HR storytelling, Visual best practices for HR reporting, Publishing HR dashboards on Power BI Service, Case study: End-to-end HR dashboard development and presentation

Course Objectives5 points
  • Introduce the concepts, techniques, and business applications of HR analytics with practical implementation using Power BI.
  • Equip students with skills to visualize and analyze workforce data using Power BI dashboards.
  • Develop the ability to track, store, retrieve, analyze, and interpret HR metrics for evidence-based decision-making.
  • Apply statistical and visualization techniques to measure recruitment, performance, training, and compensation metrics.
  • Demonstrate how HR results can be connected to business outcomes using Power BI dashboards.
Course Outcomes (COs)5 outcomes

After completion of the course student will be able to:

  1. CO1Understand the fundamental concepts of HR analytics and the role of Power BI in visualizing HR dataK2
  2. CO2Apply HR forecasting, recruitment, and performance metrics using Power BI tools and techniquesK4
  3. CO3Analyze workforce trends and training ROI through interactive dashboards and visualsK4
  4. CO4Design and interpret dashboards for compensation planning, attrition, and HR interventionsK5, K6
  5. CO5Demonstrate data-driven HR storytelling and connect HR analytics to organizational goalsK5

Suggested Readings

  1. & Tools

Textbooks

  1. HR Analytics: Understanding Theories and Applications by Dipak Kumar Bhattacharyya, Publisher: SAGE Publications
  2. Data-Driven HR: How to Use Analytics and Metrics to Drive Performance by Bernard Marr, Publisher: Kogan Page
  3. Microsoft Power BI Cookbook by Brett Powell, Publisher: Packt Publishing Tools & Online Resources:
  4. Microsoft Power BI Desktop (Free software for hands-on practice)
  5. Power BI Service (cloud publishing and collaboration)
  6. HR dashboards on PowerBI.com (samples)
  7. Microsoft Learn – Power BI modules (https://learn.microsoft.com/en-us/training/powerplatform/power-bi/)
  8. DAX Guide (https://dax.guide) for advanced calculations
  9. ExcelHR, HRAnalyticsHub, Kaggle for sample HR datasets

Official AKTU syllabus

This subject is on page 40, 41 of the original AKTU PDF.

Official AKTU syllabus PDF ↗