Title : HR Dashboard – Salary & Attrition Insights
Project Overview
This project involves the development of an Interactive Excel Dashboard to analyze employee data
across various departments and locations. The dataset includes important HR-related fields such as
Department, Salary, Attrition Status, and Location. Using Excel tools like pivot tables, pivot charts,
and slicers, the project creates a dynamic and interactive dashboard. The dashboard allows users to
filter data by department or location and view key HR metrics such as average salary distribution
and attrition rate trends.
The primary objective of the project is to provide HR managers with a decision-support tool that
simplifies data visualization, enhances workforce analysis, and supports strategic planning related to
employee retention and compensation management
Introduction
Human Resource (HR) analytics is a growing field that helps organizations make informed decisions
by analyzing employee-related data. Employee turnover (attrition) and salary distribution are two
critical aspects that directly affect organizational growth and efficiency. High attrition rates increase
recruitment and training costs, while improper salary distribution can impact employee satisfaction
and retention.
Importance in data analytics
Data analytics helps organizations turn raw data into insights for better decisions. In HR, it is crucial
for understanding salary distribution, monitoring attrition trends, improving employee retention, and
supporting strategic workforce planning.
Data Description
Data Overview
The dataset comprises employee records from multiple departments and locations. It includes details
such as salaries, attrition status, and work locations. This structure enables the analysis of salary
distribution, attrition trends, and department/location-wise workforce patterns.
Dataset Details (Four Columns)
The dataset includes four primary columns:
Department: The functional area of the employee (HR, Sales, IT, Finance).
Salary: The salary of the employee.
Attrition Status: Indicates whether an employee has left the organization (Yes/No).
Location: The city of posting (Mumbai, Pune, Delhi).
Analysis Dimensions
The dataset allows analysis across different dimensions such as:
Department-wise salary and attrition patterns
Location-based workforce insights
Overall attrition trends across the organization
Data Quality and Sources
The dataset is well-structured, complete, and suitable for HR analytics. It provides reliable insights for
salary comparison, attrition monitoring, and workforce planning at a macro level.
Data Analysis and Key Findings
Employee Trend Analysis
Analysis of the dataset reveals variations in salary distribution and attrition across departments and
locations. Departments like IT and Finance have higher average salaries, while HR and Sales show
relatively lower compensation. Attrition patterns indicate that some departments and locations
experience higher employee turnover.
Key Statistical Insights (Salary & Attrition by Department)
Dataset:
Visualization Gallery
Figure 1: Average Salary by Department
Figure 2: Attrition Rate by Department
Figure 3: Salary and Attrition Comparison by Location
Methodology
1. Analytical Approach
The project uses a comparative analysis, examining average salaries and attrition rates
across departments and locations to identify trends and key insights.
2. Data Collection & Validation
Employee data was sourced from internal HR records and validated for completeness and
consistency across all fields (Salary, Department, Attrition Status, Location).
3. Trend Analysis
Pivot tables and charts were used to analyze salary distribution and attrition patterns,
highlighting variations across departments and cities.
4. Visualization Creation
Charts were chosen based on the type of insight:
Bar Charts for department-wise salary comparison
Pie Charts for attrition proportion
Line Charts for salary trends over time (if applicable)
5. Narrative Development
The dashboard is structured to guide users from general workforce patterns to specific
insights, e.g., high-attrition departments or locations with salary disparities.
Tools and Technologies Used
Excel: Pivot tables, charts, slicers
Data Analysis Techniques: Comparative metrics, averages, and percentage calculations
Dashboard Design: Interactive filtering and visual storytelling
Conclusion and Key Insights
The project demonstrates that salary and attrition trends vary significantly across departments and
locations. By applying data storytelling, HR managers can quickly identify:
Departments with high turnover
Compensation gaps that may influence attrition
Location-specific workforce challenges
Implications for the Project & Learning Outcomes
This project reinforces skills in the data lifecycle: sourcing, validating, analyzing, visualizing, and
narrating HR data. The key learning outcome is the ability to create interactive dashboards that
clearly communicate analytical findings to support HR decision-making.
References
Internal HR employee data (Salary, Department, Attrition, Location)
Methodology Reference: Storytelling with Data by Cole Nussbaumer Knaflic
Tools: Microsoft Excel (Pivot Tables, Charts, Slicers)