Zain The AnalystAvailableCase Study
Data Analysis and Visualization
HR Analytics Dashboard
A Power BI dashboard that helps understand employee attrition, salary, satisfaction, workforce distribution, and HR trends.
Key Metrics Analyzed
Total Employees1,470
Attrition Rate16%
Average Age37
Average Daily Rate$802
Average Hourly Rate$66
Average Salary$6,503
Average Working Years7
Overview & Objectives
This project analyzes HR employee data using Power BI. It helps users understand employee attrition, workforce distribution, salary patterns, job roles, business travel behavior, satisfaction scores, and demographic trends.
The dashboard includes three report pages. The first page focuses on overall HR KPIs, attrition by role, gender, age group, training history, and marital status. The second page analyzes satisfaction scores, monthly income, business travel, department attrition, and waterfall impact. The third page focuses on workforce distribution, salary slabs, business travel, education fields, and attrition trends.
Project Goal
Build a clear Power BI dashboard that helps HR teams explore employee attrition, salary patterns, satisfaction scores, and workforce trends.
The Business Problem
HR data can be difficult to understand when employee information, salary, attrition, satisfaction, department, education field, and travel behavior are analyzed separately. The business needed one clear dashboard to understand why employees leave, which roles are affected, and how salary, travel, and satisfaction relate to attrition.
Methodology
My Approach
- 1I cleaned and prepared the HR employee dataset.
- 2I created Power BI measures for attrition rate, employee count, average age, average salary, hourly rate, daily rate, and working years.
- 3I designed dashboard pages for HR overview, satisfaction and income analysis, and workforce distribution.
- 4I added visual comparisons by job role, gender, department, age group, marital status, education field, salary slab, and business travel.
Implementation
Roadmap Execution
Data Preparation
Cleaned and prepared the HR employee dataset for analysis.
Data Modeling
Created the Power BI data model for employees, departments, job roles, salary, education, satisfaction, and business travel.
DAX Development
Built measures for total employees, attrition rate, average age, average salary, daily rate, hourly rate, and working years.
Dashboard Design
Designed HR overview, satisfaction and income analysis, and workforce distribution pages.
Attrition Analysis
Created visuals to analyze attrition by job role, gender, department, age group, marital status, education field, and travel history.
Final Formatting
Formatted KPI cards, bar charts, line charts, donut charts, pie charts, gauges, scatter plots, and waterfall visuals for clear HR reporting.
Key Features
HR KPI overview
Attrition rate analysis
Attrition by job role
Attrition by age group
Gender distribution
Marital status distribution
Satisfaction score analysis
Monthly income by job role
Income by gender and education field
Business travel analysis
Employee count by education field
Salary slab analysis
Department attrition analysis
Waterfall impact analysis
Business Impact
Helps HR teams identify high-attrition groups
Makes workforce trends easier to understand
Shows salary and satisfaction patterns clearly
Supports better employee retention decisions
Reduces manual HR reporting work by using one interactive Power BI dashboard
Challenges Overcome
- Combining employee, salary, department, travel, and satisfaction fields into one dashboard
- Making attrition patterns easy to understand
- Showing salary and income differences clearly
- Comparing employee groups across departments, roles, age groups, and education fields
- Designing simple HR visuals for quick decision-making
Outcomes
Final Outcomes & Learnings
- The final dashboard gives a clear view of employee attrition, workforce structure, salary trends, satisfaction scores, and HR performance indicators.
- Users can quickly identify high-attrition roles, compare employee groups, analyze salary patterns, and understand workforce behavior across departments and travel groups.
Project Gallery & Screenshots
Technologies Used
Power BIPower QueryDAXExcelData ModelingData Visualization
Data Sources
HR employee datasetEmployee attrition dataSalary dataJob role dataDepartment dataBusiness travel dataSatisfaction score data
Need similar outcomes in your business?
Let's scope your metrics and construct dashboards tailored to your parameters.