Adepoju Temitope Elizabeth

Data Analyst | Relationship Officer | Turning Data into Insights and Impact

View the Project on GitHub Temitopeadep/data-analyst-portfolio

HR-EMPLOYEE-ATTRITION-DASHBOARD

Project Overview

This HR Employee Attrition Dashboard was developed to help HR professionals generate actionable insights that can reduce employee attrition and improve workforce retention strategies.

Data Source

Tools

Data Cleaning

All data cleaning and transformation were carried out in Excel:

  1. Removed redundant columns
  2. Renamed columns for clarity
  3. Dropped duplicate records
  4. Cleaned inconsistent entries
  5. Removed missing (NaN) values
  6. Performed data transformation for analysis readiness

Data Analysis

Demographics

Summarized employee statistics, including age group, gender, distance from home, and marital status. Provided insights into workforce diversity and commuting patterns for informed decision-making.

Turnover Analysis I

Offered insights into employee attrition by department, job role, business travel, and tenure in the current role. Helped identify areas needing better workforce management and retention strategies.

Turnover Analysis II

Explored attrition by job level, overtime, performance rating, monthly income, and attrition increase levels. Provided critical insights for effective HR strategies and decision-making.

Employee Wellness

Analyzed employee wellness factors, including monthly income, hourly rate, relationship satisfaction, performance rating, environmental fit, job involvement, and work-life balance. Highlighted insights to guide HR in developing employee-friendly policies.

Results and Findings

Dashboard Visuals

HR ATTRITION DASHBOARD

DEMOGRAPHICS

TURNOVER ANALYSIS I

TURNOVER ANALYSIS II

EMPLOYEE WELLNESS

Recommendations


This project demonstrates how Tableau can transform HR data into actionable insights that support employee engagement, wellness, and retention strategies.

Tableau Public Linkedin