Skip to content

This Power BI dashboard analyzes employee attrition, visualizing key metrics such as overall attrition rate, hiring trends, and active employees by department and job role. It includes demographic insights, performance tracking, and detailed attrition analysis by various factors, helping stakeholders manage and reduce employee turnover effectively.

License

Notifications You must be signed in to change notification settings

ViralBiyawala/ATLAS-PowerBI

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ATLAS Labs Employee Attrition Dashboard | Power BI

Overview

This Power BI dashboard analyzes employee attrition, visualizing key metrics such as overall attrition rate, hiring trends, and active employees by department and job role. It includes demographic insights, performance tracking, and detailed attrition analysis by various factors, helping stakeholders manage and reduce employee turnover effectively.

Features

  • Attrition Rate Overview: Displays the overall attrition rate and hiring trends.
  • Employee Demographics: Visualizes employee distribution by age, gender, marital status, and ethnicity.
  • Performance Tracker: Tracks individual employee performance metrics over the years.
    • WorkLife Balance
    • Job Satisfaction
    • Enivornment Satisfaction
    • Relationship Satisfaction
  • Detailed Attrition Analysis: Examines attrition rates by department, job role, hire date, travel frequency, overtime, and tenure.

Screenshots

Here are some screenshots of the dashboard:

Overview Page

Overview

Demographics Page

Demographics

Model and Relationship view

Model

Full PDF Report

For a detailed view, you can download the full PDF report ATLAS_ALBS.pdf.

How to Use

  1. Open Power BI Report: Download and open the .pbix file in Power BI Desktop.
  2. Navigate the Pages: The dashboard consists of four main pages: Overview, Demographics, Performance Tracker, and Attrition.
  3. Interactive Filters: Use the interactive filters to drill down into specific segments of data.
  4. Sharing: Publish the report to Power BI Service for real-time updates and collaborative access.

Data Sources

The raw data used for analsysis is here.

The dashboard is powered by data from the following sources:

  • Employee records including hire dates, department, job roles, and performance ratings.
  • Demographic information such as age, gender, marital status, and ethnicity.
  • Performance evaluation data.

Installation

  1. Download the .pbix file ATLAS_ALBS.pbix.
  2. Open Power BI Desktop.
  3. Load the .pbix file to view the dashboard.

Acknowledgments

Contribution

Feel free to contribute by submitting issues or pull requests. For major changes, please open an issue first to discuss what you would like to change.

About

This Power BI dashboard analyzes employee attrition, visualizing key metrics such as overall attrition rate, hiring trends, and active employees by department and job role. It includes demographic insights, performance tracking, and detailed attrition analysis by various factors, helping stakeholders manage and reduce employee turnover effectively.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published