Skip to content

Latest commit

 

History

4 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 

Repository files navigation

📊 HR Analytics Dashboard

This project,presents an interactive Power BI dashboard that provides insights into employee attrition, performance, and satisfaction using HR analytics data.
It empowers HR managers and stakeholders to analyze employee job satisfaction, work-life balance, training opportunities, and attrition patterns, enabling data-driven decisions for improving retention and workforce performance.


🔎 Overview

  • 🎯 Analyze factors influencing employee attrition and satisfaction.
  • 📈 Visualize performance ratings from both self-assessment and manager reviews.
  • 🏢 Drill down into employee demographics such as department, gender, and education levels.
  • 🔧 Explore the impact of work-life balance, overtime, distance from home, and salary on retention.

📂 Datasets Used

1️⃣ Fact PerformanceRating

  • PerformanceID: Unique identifier for each review
  • EmployeeID: Employee reference
  • ReviewDate: Date of performance review
  • Satisfaction ratings and metrics: environment, job, relationships, training, work-life balance
  • Self and manager performance ratings

2️⃣ DimEmployee

  • Employee demographics: name, gender, age, ethnicity, marital status, state
  • Work characteristics: department, salary, stock options, overtime status, distance from home
  • Employment history: hire date, years at company, promotions, attrition status

3️⃣ SatisfiedLevel

  • SatisfactionID, SatisfactionLevel (ranging from “Very Dissatisfied” to “Very Satisfied”)

4️⃣ RatingLevel

  • RatingID, RatingLevel (from “Unacceptable” to “Above and Beyond”)

5️⃣ EducationLevel

  • EducationLevelID, EducationLevel (from “No Formal Qualifications” to “Doctorate”)

🔔 Key Insights Provided

  • 🔹 Attrition Analysis: Identify drivers of employee turnover
  • 🔹 Performance Review Visualization: Compare self-ratings vs manager evaluations
  • 🔹 Satisfaction Monitoring: Track work-life balance and satisfaction by department and demographics
  • 🔹 Training Analysis: Assess correlation between training opportunities and performance/satisfaction
  • 🔹 Demographic Trends: Understand impact of factors like business travel, education, and age on attrition and performance

▶️ Usage Instructions

1️⃣ Open in Power BI:
Open the provided .pbix file in your Power BI Desktop app.

2️⃣ Connect to data:
Load the accompanying datasets.

3️⃣ Explore the dashboard:
Use filters and slicers to drill into specific segments (departments, demographic groups, etc.).

4️⃣ Interpret results:
Gain actionable insights to improve employee retention and performance evaluation processes.


📝 Conclusion

This HR Analytics Dashboard delivers a comprehensive view of employee attrition, satisfaction, and performance patterns.
By leveraging these insights, organizations can enhance HR decision-making, improve employee retention, and foster a positive workplace environment.


👤 Author: Chanikya Kothi

⭐ If you find this project useful, feel free to ⭐ star the repository or contribute enhancements!

About

Interactive Power BI dashboard for HR analytics — visualize employee attrition, performance, satisfaction, demographics, and training insights.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors