HR Resource Dashboard

An interactive Tableau dashboard exploring HR Analytics data trends involving hiring, gender, and education.

Tools & Skills Used: Data Analysis, SQL, Excel, Power Query, Tableau, Dashboard Design, HR Metrics

📊 Heads up, mobile explorers! While these dashboards technically work on your phone, they really prefer the spacious, luxurious real estate of a full browser. Think of it like trying to watch "Lord of the Rings" on a smartwatch — possible, but... why? 😅 For the full interactive magic, hop onto a desktop or laptop!

Project Overview: Human Resources Dashboard

📂 Business Problem & Strategy

In many organizations, HR teams struggle to visualize workforce trends across departments and demographics. This project simulates a realistic scenario where leadership needs clear insights into headcount distribution, turnover patterns, and compensation equity to support strategic planning.

To address this, I developed a mock HR dashboard that mirrors challenges I’ve encountered in real-world roles—such as reconciling employee data across systems, segmenting workforce trends, and identifying areas for improvement. The project walks through my analytical process, from data prep in Excel to building insights in Tableau.

🎯 Key Questions Driving the Analysis

• Where are headcount and turnover highest across departments?
• Are there identifiable trends in hiring vs. termination over time?
• How do education levels and job roles correlate with performance ratings?
• Is there evidence of pay disparity by gender or educational background?

🛠 Methodology and Tools

• Data Preparation: Cleaned and shaped simulated HR data using Excel and Power Query to standardize formats, remove duplicates, and prepare for analysis.
• Data Modeling: Organized employee records by key dimensions (e.g., department, education, location) to enable multi-variable analysis and calculated fields in Tableau.
• Visual Analytics: Created an interactive Tableau dashboard with slicers for department, role, and education to uncover patterns in headcount and compensation.
• UX Design: Applied intentional color theming (teal/pink) and consistent layout to improve readability, navigation, and data story flow.
• Publishing: Deployed the project on Tableau Public for public access and professional portfolio visibility.

📌 Insights & Business Value

• Retention: Ops, Sales, and CS teams show highest headcount and turnover, with monthly termination spikes highlighting potential retention gaps.
• Performance: Employees with Bachelor's and Master's degrees consistently score higher on performance metrics across departments.
• Compensation & Equity: Salaries trend upward with education and role level, though gender-based differences suggest areas for deeper equity analysis.
• Strategic Impact: These insights can inform workforce planning, retention strategies, and equitable compensation reviews within HR leadership teams.