HR data

Project Name: HR Attrition Analysis

Description:

This project analyzes employee attrition using SQL on an HR dataset. It focuses on understanding overall attrition rates, employee demographics, and department-wise trends. The analysis includes:

Overall Attrition Rate:

Calculated the percentage of employees who left the company (attrition='Yes') relative to the total employee count.

Current Employees Count:

Determined the number of employees who remain in the company.

Average Age:

Computed the average age of employees.

Attrition by Gender:

Counted employees leaving by gender.

Drilled down to see attrition by gender among those with a High School education.

Attrition by Department:

Counted the number of employees leaving per department.

Calculated the percentage of total attrition per department.

Attrition by Age Band and Gender:

Grouped attrition by age bands and gender.

Provided percentage distribution across groups.

Skills demonstrated:

SQL queries: SELECT, GROUP BY, ORDER BY, SUM, COUNT, AVG, ROUND, CAST.

Data aggregation, filtering, and calculation of percentages.

Analytical reasoning to identify trends and patterns in HR attrition.

Outcome:

Identified key departments and demographics with higher attrition rates.

نهىلProvided actionable insights for HR decision-ma