HR Analytics Dashboard — Excel Project

Excel dashboard for HR analytics, attrition insights, workforce demographics, and employee satisfaction reporting.

Dashboard Preview

Overview

This project presents an interactive HR analytics dashboard built in Microsoft Excel. It helps HR teams quickly understand employee attrition, workforce distribution, demographic patterns, and satisfaction indicators.

The dashboard is designed as a business intelligence case study: turning raw HR data into actionable visuals for decision-making.

Business Questions

• What is the overall attrition rate?
• Which age groups, education levels, or job roles show higher attrition?
• How is the workforce distributed by gender, department, and age?
• Which employee segments may need retention-focused action?
• How can HR leaders monitor workforce health more efficiently?

Key Insights Covered

• Employee count and attrition overview
• Attrition by age group
• Attrition by education background
• Gender and department distribution
• Job satisfaction / workforce-related breakdowns
• Interactive filtering for deeper exploration

Tools Used

• Microsoft Excel
• Pivot Tables
• Pivot Charts
• Slicers
• Dashboard layout and visual design

Files

HR Analytics.xlsx   Main Excel dashboard workbook
gif.gif             Dashboard preview animation
README.md           Project documentation

How to Use

1. Download HR Analytics.xlsx.
2. Open it in Microsoft Excel.
3. Use slicers/filters to explore the HR metrics.
4. Review patterns in attrition and workforce distribution.

Portfolio Context

This project demonstrates practical analytics storytelling: cleaning and summarizing HR data into a dashboard that helps non-technical stakeholders make faster decisions.

Author

Built by Dirga Halim Susilo.
Portfolio: dirgahalimsusilo.site