← Home

Employee Attrition Dashboard & Analytics

Role

Data Analyst

Keywords

Year

2025

← Home Employee Attrition Dashboard & Analytics Table of Contents About Problem Report Objectives Analysis Process Insights Summary Recommendations What I’ve Learned Other Projects Let’s Work Together

About

Live Demo

Employee Attrition Dashboard - Video Demo

Demo for my Employee Attrition Dashboard, a submission I made for the NextGen Analytics 2025 competition and was awarded champion for.

https://www.youtube.com/watch?v=BrA2nzTtzPE

Slides

Employee Attrition - Slides.pdf

https://drive.google.com/file/d/1OjkOgeo28mCehLoyT8hEtxpXVYBYyD0c/view?usp=sharing

Project Review

Why are employees at corporation ABC leaving? What can leaders do to decrease attrition rate?

My analysis (as a part of the NextGen Analytics competition) provides the solutions through a clear 5-step analysis process.

The final outcome includes:

a Power BI dashboard with the most crucial metrics, advanced features to improve UI/UX and analysis quality (such as tabs, parameters, advanced measures and visualizations, Machine Learning)

a set of slides

and a video presentation.

Tech Stack

Power BI

Python

Canva

Hi! The detailed blog article for this project is not yet completed. In the mean time, please check out this quick summary and the resources above to know about the context of the project.

Problem

Corporation ABC has been struggling with high attrition rate among its employees for the past few years. As a Data Analyst at the corporation, my mission is to investigate the root cause of the problem and collaborate with other stakeholders to deploy a solution.

Report Objectives

Analysis Process

Finding the root cause of any issue is never easy. There are million factors that can affect said problem. Hence, I devised a 5-step process to make sure I tackle the most important factors first and therefore save everyone’s time.

Insights

After Exploratory Data Analysis, I plotted out graphs that I think can answer certain hypotheses about the root cause of employee attrition.

Ultimately, I concluded with 3 main causes to employee attrition:

Convenience

Work Allocation

Recognition

Each cause is illustrated in the following graph, which shows how much time it needs to change each said cause. Of course, the speed denoted is only a quick assumption for reference, the actual speed to adopt changes may vary.

The image below describe one of such insights. Read the slides above to discover more insights.

Summary

To sum up, I discovered three main factors that may lead to employee attrition:

Convenience

Work Allocation

Recognition

Recommendations

Based on each factor, I created a table and propose an action plan for each stakeholder level.

Of course, this is just an initial proposal based on my insights and knowledge. Upon more discussion with other stakeholders, we can refine this plan to make it more detailed and suitable to one’s needs.

What I’ve Learned

This is one of the most complex analysis projects that I’ve done, not because it uses complex Power BI techniques, but because I’ve used a more structured process to problem-solving.

In this project, I did not start slamming the most fancy Data Science mechanisms right away, but I did thorough research in how to conduct a proper analysis first.

And I think it payed off very well - the initial problem was discrete, with so many variables that accompanied the dataset. The final output reduces the problem to three main factors, which is accompanied with an action plan that the corporation can refine right away.