Turnover Analysis Dashboard by Elizabeth WaweruTurnover Analysis Dashboard by Elizabeth Waweru

Turnover Analysis Dashboard

View completed workapp.powerbi.com

๐Ÿ“‰ Turnover Analysis Dashboard โ€“ April 2025

A Power BI dashboard that provides a deep dive into employee turnover patterns using real-world HR data. The dashboard helps uncover trends in employee tenure, industry attrition, coaching influence, and gender-based turnover to support better decision-making in HR strategy.
๐Ÿ”— Live Dashboard: Click to View

๐Ÿ“Œ Table of Contents

๐Ÿง  Overview

This HR analytics dashboard explores trends and patterns related to employee turnover. The visualizations help HR professionals and business leaders understand key drivers of attrition across age, gender, industry, and coaching status.
The dashboard was built using Microsoft Power BI and incorporates interactive filtering and storytelling elements for a smooth user experience.

๐Ÿ” Key Insights

Total Employees: 1,129
Turnover Rate: 50.6%
Average Tenure: 36.63 months
Coached Turnover: 56.82%
Non-Coached Turnover: 51.39%

๐Ÿง‘โ€๐Ÿคโ€๐Ÿง‘ Gender Turnover Breakdown

Females: 436 of 853 left (higher attrition)
Males: 135 of 276 left

๐Ÿข Top 5 Professions by Average Tenure

Teaching, PR, Sales, Other, Marketing

๐Ÿญ Top 5 Industries by Turnover

Retail, State, Transport, Telecom, Real Estate

๐Ÿ’ผ Wage Classification

Greywage (low wage): 11.25%
Whitewage (standard wage): 88.75%

โš™๏ธ Dashboard Features

๐Ÿ”Ž Filters for Age Group and Mode of Transport
๐Ÿ“Š KPI Cards for quick snapshot of metrics
๐Ÿ“ˆ Line and bar charts for profession and industry analysis
๐Ÿงฎ Donut charts for gender and wage breakdown
๐Ÿงฉ Interactive segmentation by turnover and coaching

๐Ÿ“ Dataset

This dashboard is based on a real-world HR dataset created by Edward Babushkin as part of his work on predicting employee turnover.
Dataset includes anonymized employee-level data:
Gender
Age Group
Industry
Profession
Coaching Status
Tenure
Grey/White Wage Classification
Turnover Label

๐Ÿ›  Technologies Used

Power BI for data modeling and dashboard development
DAX for calculated measures and KPIs
Power Query for data cleaning and transformation
GitHub for project documentation and versioning
PowerPoint for theme design

๐Ÿ–ผ๏ธ Screenshots

Dashboard Preview

๐Ÿ™Œ Credits

Special thanks to Edward Babushkin for providing the original dataset and insightful blog on employee turnover analytics.

1 like ยท 12 views ยท May 28, 2025

Created a Power BI dashboard analyzing employee turnover patterns for HR strategy.