This project is a comprehensive HR Analytics Dashboard built using Power BI, aimed at providing insightful visualizations to understand employee demographics, performance, attrition trends, and more. The dashboard serves as a decision support tool for HR managers and business analysts.
The HR Analytics Dashboard helps organizations analyze:
- Workforce structure
- Attrition patterns
- Employee satisfaction
- Job roles and departments
- Work-life balance
- Performance and promotions
The goal is to improve HR strategies and support data-driven decision-making using visual insights.
- Interactive Filters: Analyze data by department, gender, age group, etc.
- Attrition Analysis: Track who is leaving and why.
- Employee Demographics: Insights on gender, marital status, education, etc.
- Departmental Overview: Compare performance and attrition across departments.
- Work-life Balance: Evaluate employee satisfaction indicators.
- KPI Cards: At-a-glance metrics like total employees, average age, attrition rate, etc.
The dataset used in this project is included as a CSV file: HR-Employee-Attrition.csv.
AgeAttritionBusinessTravelDepartmentDistanceFromHomeEducationEducationFieldEnvironmentSatisfactionGenderJobRoleJobSatisfactionMaritalStatusMonthlyIncomeNumCompaniesWorkedOverTimePerformanceRatingRelationshipSatisfactionStockOptionLevelTotalWorkingYearsTrainingTimesLastYearWorkLifeBalanceYearsAtCompanyYearsSinceLastPromotion
✅ This dataset is based on a fictional HR database. It has been commonly used for learning HR analytics, including by IBM.
- Open the file
HR Analytics Dashboard.pbixusing Microsoft Power BI Desktop. - Make sure the dataset file
HR-Employee-Attrition.csvis located in the same folder as the.pbixfile. - Interact with filters, slicers, and visualizations.
- You can also connect the PBIX to another HR dataset using Power Query.
- Power BI Desktop
- DAX (Data Analysis Expressions)
- Power Query
- CSV (Comma Separated Values)
- Install Power BI Desktop
- Clone this repository:
git clone https://github.com/manishdevdi/HR-Analytics-Dashboard.git- Open HR Analytics Dashboard.pbix in Power BI Desktop.
- If prompted, relink the dataset HR-Employee-Attrition.csv.
Contributions are welcome! Fork the repo, make your changes, and submit a pull request.
This project is licensed under the MIT License.
For more details, see the LICENSE file.
📌 Author: Manish Devdi
📌 GitHub: manishdevdi 📌 LinkedIn: Manish Devdi
⭐ If you like this project, give it a star! ⭐