HR Analysis

Domain :Human Resources

Function :

The main function of this project is to analyze employee attrition and provide insights into the reasons behind it. It involves data cleaning, transformation, and analysis to identify patterns and trends that could inform strategies to reduce employee attrition.

Problem Statement

Employee attrition is a significant problem for many organizations. High attrition rates can lead to a loss of productivity, decreased morale, and increased costs associated with hiring and training new employees. However, understanding the reasons behind employee attrition can be challenging, especially if an organization lacks a centralized system to track employee data.

Objective:

Analyze employee attrition and identify key factors that contribute to it. This type analysis will help organizations develop effective strategies to reduce employee attrition and retain talented employees.
The project aims to provide insights based on these 10 analysis requests given by Human Resources

Click to view Requests
  • What is the Employee Count?
  • How many employee have left the company?
  • What is the rate of attrition?
  • Find the number of active employees after attrition.
  • What is the average age of employees that left the company and the gender?
  • Find the department wise attrition.
  • Number of employees by age group.
  • Find the job satisfaction rating.
  • Attrition by qualifications.
  • Find the attrition rate by gender.

Methodology :

The methodology for this project will involve the folloeing:

  • Data Collection: Collecting employee data, including age, gender, department, job satisfaction, qualifications, and employment status.
  • Data Cleaning and Transformation: Cleaning and transforming the data to ensure accuracy and consistency.
  • Data Analysis: Analyzing the data to identify patterns and trends related to employee attrition.
  • Data Visualization: Creating visualizations to help stakeholders understand the data and its implications.
  • Dashboard Snippet

    SQL-Analysis