This project focuses on analyzing employee attrition using SQL Server and Power BI. The objective was to understand workforce trends and identify key factors contributing to employee attrition through data-driven insights.
The project follows a simple and practical workflow, starting from raw data exploration in SQL to building an interactive dashboard in Power BI.
- SQL Server
- Power BI
- IBM HR Analytics Dataset
- Imported HR employee data into SQL Server
- Performed initial data exploration using SQL queries
- Created derived columns such as:
- Age Groups
- Attrition Flag
- Used SQL to calculate key HR metrics like:
- Total employees
- Attrition count and attrition rate
- Department-wise and age group-wise attrition
- Connected Power BI directly to SQL Server
- Built an interactive dashboard to visualize insights
- Overall employee attrition rate across the organization
- Departments with higher employee turnover
- Age groups more affected by attrition
- Gender distribution of employees
- Relationship between job satisfaction and attrition
HR-Analytics-SQL-PowerBI/ │ ├── sql/ │ └── hr_analysis.sql │ ├── powerbi/ │ └── HR_Analytics_Dashboard.pbix │ ├── images/ │ └── dashboard.png │ └── README.md
- All data transformations and calculations were handled using SQL
- Power BI was primarily used for visualization and interactivity
- The project is designed to reflect a real-world beginner-level data analytics workflow
Devendra Patil