AKTU HR Analytics Using Power BI (BMBAHR04) Syllabus PDF – MBA (Business Analytics) 4th Semester
HR Analytics Using Power BI BMBAHR04
All syllabus, notes, question bank & PYQ for this subject
- English
- Semester 4
- 0 downloads
- 0 views
Syllabus — HR Analytics Using Power BI
Download PDFBMBAHR04 · 3 credits · L-T-P 3-0-0
Course Objectives
- 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.
Unit 1: Foundations of HR Analytics and Power BI Overview (8 Hours)
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
Unit 2: Workforce Planning, Recruitment & Selection Analytics with Power BI (8 Hours)
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
Unit 3: Performance, Training & Compensation Analytics Using Power BI (8 Hours)
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)
Unit 4: Monitoring Interventions & Employee Well-being Analytics (8 Hours)
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
Unit 5: HR Metrics Dashboarding and Storytelling in Power BI (8 Hours)
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 Outcomes
| CO Code | Course Outcome Statement | Bloom’s K Levels |
|---|---|---|
| CO1 | Understand the fundamental concepts of HR analytics and the role of Power BI in visualizing HR data | K2 |
| CO2 | Apply HR forecasting, recruitment, and performance metrics using Power BI tools and techniques | K4 |
| CO3 | Analyze workforce trends and training ROI through interactive dashboards and visuals | K4 |
| CO4 | Design and interpret dashboards for compensation planning, attrition, and HR interventions | K5,K6 |
| CO5 | Demonstrate data-driven HR storytelling and connect HR analytics to organizational goals | K5 |
Suggested Readings
Text Books
- HR Analytics: Understanding Theories and Applications by Dipak Kumar Bhattacharyya, Publisher: SAGE Publications
- Data-Driven HR: How to Use Analytics and Metrics to Drive Performance by Bernard Marr, Publisher: Kogan Page
- Microsoft Power BI Cookbook by Brett Powell, Publisher: Packt Publishing Tools & Online Resources:
- Microsoft Power BI Desktop (Free software for hands-on practice)
- Power BI Service (cloud publishing and collaboration)
- HR dashboards on PowerBI.com (samples)
- Microsoft Learn – Power BI modules (https://learn.microsoft.com/en-us/training/powerplatform/power-bi/)
- DAX Guide (https://dax.guide) for advanced calculations
- ExcelHR, HRAnalyticsHub, Kaggle for sample HR datasets
Ratings & Reviews
No reviews yet — share your experience with this item.