HR_Data_Analysis

HR Data Analysis Project

Welcome to the HR Data Analysis project repository. This project utilizes Tableau and SQL to analyze and visualize human resources data, providing valuable insights into our organization's workforce.

Project Highlights:

• Data Analysis: Explore key HR metrics, trends, and patterns to make informed decisions related to talent management and employee engagement.

• Interactive Visualizations: Utilize Tableau to create interactive and insightful data visualizations that enable easy exploration of HR data.

• SQL Queries: Leverage SQL to efficiently query and manipulate HR data, enabling deeper analysis and reporting.

• Insightful Reports: Generate reports and summaries to facilitate data-driven decision-making processes within the HR department.

Key Features:

• Interactive Tableau dashboards
• SQL scripts for data manipulation and analysis
• Comprehensive HR data visualizations
• Insights and recommendations for HR strategy

Feel free to explore the project's code, visualizations, and findings. We welcome contributions, suggestions, and collaboration from the community to further enhance our understanding of HR data.

Let's Start Visualization with Tableau First --

1. Counting Total Employess

2. Counting Total Attrition

3. Counting Attrition Rate

4. Active Employees

5. Avgerage Age

6. Attrition By Gender

7. Department wise Attrition

8. No of employees by Age Group

9. Education Field Wise Attrition

10. Job Satisfaction Rating

11. Attrition Rate by gender for different Age Groups

12. Final Result Dashboard

Let's Start Verify this Data with SQL

1. Counting Total Employess

Query :

select count(distinct emp_no) as Employee_Count from hrdata;

Result :

2. Counting Total Attrition

Query :

select count(attrition) as Attrition_Count from hrdata where attrition = 1 ;

Result :

3. Counting Attrition Rate

Query :

select ( (select count(attrition) from hrdata where attrition = 1 )*1.0 / sum(employee_count))*100 as 'Attrition Rate' from hrdata;

Result :

4. Active Employees

Query :

select count(active_employee) as 'Avg. Age' from hrdata where active_employee = 1;

Result :

5. Avgerage Age

Query :

select sum(age) / count(emp_no) as 'Active Employee' from hrdata where active_employee = 1;

Result :

6. Attrition By Gender

Query :

select gender , count(attrition) as Attrition_Count from hrdata where attrition= 1 group by gender order by count(attrition) desc;

Result :

7. Department wise Attrition

Query :

select department , count(attrition) as Attrition_Count from hrdata where attrition= 1 group by department order by count(attrition) desc;

Result :

8. No of employees by Age Group

Query :

select age , count(attrition) as Attrition_Count from hrdata where attrition= 1 group by age order by count(attrition) desc ;

Result :

Note -- The above image does not have complete data

9. Education Field Wise Attrition

Query :

select education , count(attrition) as Attrition_Count from hrdata where attrition= 1 group by education order by count(attrition) desc;

Result :

10. Job Satisfaction Rating

Query :

select job_role , job_satisfaction, count(job_satisfaction) as 'Total Rating' from hrdata group by job_satisfaction, job_role ;

Result :

Note -- The above image does not have complete data