HR Analysis For Attrition

OBJECTIVE

Organization wants to improve employee performance and improve employee retention and reduce attrition by creation a HR Analytics dashboard.

Data was imported from a CSV file which was processed for Data Cleaning and we have Removed unwanted columns AND Removed duplicate values.

1.       Requirement gathering / business requirements

2.       Data walkthrough

3.       Data connection

4.       Data cleaning / quality check

5.       Data modeling

6.       Data processing

7.       DAX calculations

8.       Dashboard lay outing

9.       Charts development and formatting

10.   Dashboard / report development

11.   Insights generation

Cards

1.       Count of Employee:

2.       Attrition: Attrition field have value as Yes and No. after creating attrition count from conditional column formatting the value gets converted into 1 and 0.

3.       Attrition Rate: create measure

Attrition Rate= sum(attrition count)/ sum(employee count)

4.       Average age:

5.       Average of monthly income (salary)

6.       Average Year: Years at company

Graphs

1.       Attrition By Education: Sum of attrition count by education field

Chart type: donut chart

2.       Attrition By Age: Create age group from conditional column formatting as 18-25, 26-35, 36-45, 46-55, 55+

Chart type: Stacked column chart

3.       Attrition By Salary Slab: Salary slab by sum of attrition count

Chart type: Stacked Bar chart

4.       Attrition By Years at Company: Years at company by sum of attrition count:

Chart type: Area chart

5.       Attrition By Job Role: Job role by sum of attrition count:

Chart type: Stacked column chart

6.       Attrition By Gender: Gender by sum of attrition count:

Chart type: Tree map

Matrix table

1.        Table created from Job role ,attrition count and job satisfaction