HR Analytics Excel Dashboard

This project in the field of human resources examines how employees at various levels within an organization are leaving their jobs. The analysis of attrition rates takes into account several factors, including the employees' monthly earnings, the year of their last promotion, their job roles, and their work-life balance. This analysis is conducted for employees in various departments.

Data Points Analyzed:

1. Average Attrition rate for all Departments

2. Average Hourly rate of Male Research Scientist

3. Attrition rate Vs Monthly income stats

4. Average working years for each Department

5. Job Role Vs Work life balance

6. Attrition rate Vs Year since last promotion relation

Tools used:-
Microsoft Excel
Dataset Details:- 
• Domain : HR Analytics
• Project Name: Employee Retention
• Dataset Name: HR_1 & HR_2
• Dataset Type: Excel Data
• Dataset Size: 50k records each

16 Sep 2023

Keywords
Data Manipulation
Statistical Analysis
Data Visualization
Presentation
Dashboard Report
Problem Solving
Critical Thinking
Domain Knowledge
Advance Excel

Creating portfolio made simple for

Trusted by 39100+ Generalists. Try it now, free to use

Start making more money