Atlas Labs HR Dashboard
Quick Summary
Goal: Track various HR metrics, including demographics, salary, department distribution, number of employees, attrition rates, and employee performance details (e.g., start date, last review, job satisfaction, and ratings).
Process: Data was provided by the company (simulated dataset). The dataset was analyzed and visualized using Power BI, with multiple pages and bookmarks for easy navigation.
Insights:
Total Employees: 1,470, with 1,233 active and 237 inactive employees.
Attrition Rate: 16.1%, varying significantly by department, tenure, and job role.
Demographics:
The majority of employees fall between 20-39 years old, with fewer employees in the younger or older brackets.
The employee base is diverse in gender, ethnicity, and marital status.
Performance Metrics:
Employees are assessed on job satisfaction, relationship satisfaction, work-life balance, manager ratings, and environment satisfaction.
Attrition Analysis:
Sales Representatives and Recruiters have the highest attrition rates.
Employees who travel frequently tend to have higher attrition.
Overtime requirements correlate with higher attrition rates.
New hires (1-2 years tenure) experience the highest turnover.
Project Summary
The Atlas Labs HR Dashboard project focused on analyzing key human resources metrics to gain insights into workforce demographics, salary distribution, attrition trends, and employee performance. The dashboard was developed to provide HR professionals and management with an interactive tool to explore workforce data and make data-driven decisions.
Using Power BI, the project transformed raw HR data into an interactive, multi-page dashboard with drill-through functionality and bookmarks for seamless navigation. The dashboard enables users to explore company-wide trends and drill into individual employee details.
Project Environment
Tools and Technologies Used:
Power BI – Data visualization, dashboard creation, and interactive filtering.
Context & Business Purpose:
Analyzed HR metrics for Atlas Labs to identify workforce trends, track employee performance, and assess attrition risks.
Explored departmental distribution, salary averages, and demographic patterns.
Provided insights into why employees leave and what factors impact retention.
Constraints & Limitations:
No significant constraints; the data was pre-cleaned and provided as a first-party dataset.
Scope and Project Steps
Objectives:
Provide an overview of employee demographics, salaries, and department distributions.
Analyze attrition rates across different variables (job role, tenure, travel, overtime, etc.).
Track individual employee performance based on ratings, job satisfaction, and review history.
Major Steps in Analysis:
Data Understanding: Reviewed HR dataset provided by Atlas Labs.
Data Preparation: Used Power BI for category validation (e.g., date formatting, department classification).
Dashboard Design:
Created overview pages for quick insights into workforce metrics.
Developed drill-through pages for detailed analysis of individual employees and attrition drivers.
Used bookmarks for easy navigation.
Insights Generation: Explored key findings related to attrition rates, salary trends, and employee performance.
Ensuring Accuracy & Reliability:
The dataset was first-party HR data, ensuring accuracy and relevance.
Power BI was used to validate category integrity and maintain clean data structures.
Data Sources and Data Gathering
Source:
First-party HR data from Atlas Labs, ensuring reliability.
Cleaning and Preparation:
The dataset was already clean, but Power BI was used to validate date fields, salary ranges, and department classifications.
Challenges:
No major challenges; data was provided in a structured format.
Data Checks and Summary Metrics
Key Statistics Analyzed:
Total Employees: 1,470 (1,233 active, 237 inactive).
Attrition Rate: 16.1%, with significant variation by department and job role.
Demographics:
The largest age group is 20-39 years old, with fewer employees under 20 or over 50.
Employee base includes diverse gender and ethnic backgrounds.
Salary Trends:
Average salaries vary by ethnicity and job role.
Performance Ratings:
Employees are rated on job satisfaction, work-life balance, manager feedback, and environmental satisfaction.
Unexpected Trends & Patterns:
Sales Representatives and Recruiters have the highest attrition rates, indicating potential issues in these roles.
Employees with frequent travel are more likely to leave.
Overtime contributes to higher attrition—employees required to work overtime have a significantly higher turnover rate.
New hires (1-2 years at the company) experience the highest attrition, suggesting challenges in employee retention.
Dashboard Build
Visualizations Created:
Multi-page interactive dashboard with bookmarks for easy navigation.
Overview page showing total employees, active vs. inactive employees, and attrition rate.
Demographics page covering age, gender, marital status, and ethnicity trends.
Performance tracker with individual employee metrics on job satisfaction, manager rating, and work-life balance.
Attrition analysis page with detailed breakdowns by job role, tenure, travel frequency, and overtime status.
Design and Usability Considerations:
Used contrasting colors for readability and clear data visualization.
Ensured even spacing and balance for an intuitive layout.
Created bookmarks for seamless navigation, reducing clutter and making the dashboard user-friendly.
Main Takeaways:
Attrition rates are highest in sales and recruiting roles, highlighting potential retention issues.
Frequent travel and overtime contribute to employee turnover.
New hires struggle with retention, suggesting a need for improved onboarding or employee support.
Salary trends vary by department and ethnicity, providing insights for HR decision-making.
The interactive Power BI dashboard allows HR managers to explore workforce data efficiently, identifying trends and potential areas for improvement.