Skip to content

README.md

Latest commit

 

History

History
57 lines (38 loc) · 2.33 KB

README.md

File metadata and controls

57 lines (38 loc) · 2.33 KB
Raw

📊 HR Analytics Dashboard | Workforce Insights & Retention Strategies

Project Overview

  • Description: Designed an interactive HR analytics dashboard using Power BI to analyze employee attrition trends and workforce performance. This project provides data-driven insights into salary impact, department-wise attrition, tenure-based trends, and age distribution, helping HR teams optimize retention strategies. Key techniques include data preprocessing, visualization, and predictive analytics to enhance employee engagement and reduce turnover rates.

Objective

  • Identify key drivers of emplyee attrition within an organization.
  • Provide data-driven insights to HR teams for better retention strategies.
  • Visualize patterns using interactive dashboards for a clear understanding of workforce trends.

Data Collecting and cleaning

  • Imported raw data HR Analytics dataset into Power BI.
  • Processed data using Power BI Query Editor,handling:
    • Null values and missing entries
    • Duplicate records
    • Data type corrections

Key Findings

  • Salary impact: Emplyees earning below 5000 rs are most likely to leave.
  • Departments Trend: Highest attrition rate observed in Lab Technicial roles.
  • Age Factor- Emplyees ageed 25-32 years tend to leave the company more often.
  • Experience Influence: Emplyees staying for 1-5 years are more likely to quit.
  • Geographical Trens: Location-based analysis identifies retention challenges.

Dashboard Features

  • Attrition Rate Overview: Summary of total emplyees vs those who left.
  • Salary Analysis: Effect of salary levels on attrition.
  • Department-wise Attrition: Breakdown by roles and function.
  • Tenure based Insights: Attrition trends across different experience levels.
  • Age distribution impact: Visual representation of age-based attrition.

Technology stack

  • Power BI
  • Excel
  • SQL

Conclusion

  • This HR Analytics Dashboard provides valuable insights into employee retention strategies. By addressing key issues like salary gaps, department- specific challenges, and age-related attrition, organizations can enhance employee engagement and reduce turnover rates.

Repository Links

Dataset:https://github.com/TheMLengineer07/Power-BI-HR_data-analysis-/blob/main/HR_Analytics.csv Dashboard:https://github.com/TheMLengineer07/Power-BI-HR_data-analysis-/blob/main/power%20bi%20dashboards.pdf