👥 Employee Workforce Dashboard Project

---

🧾 Overview

This project presents an interactive Employee Workforce Dashboard built using Microsoft Excel.
The dataset includes employee records such as personal details, job information, department, business unit, salary, hiring & exit dates, and status.

The dashboard provides visual insights into employee distribution, attrition patterns, and workforce demographics, along with dynamic interactivity using VBA Macros.

---

📂 Dataset Info

• Total Records: 729 employees
• Departments: 6
• Exited Employees: 101
• Highest Annual Salary: $1,408,000
• Columns include: EEID, Full Name, Gender, Age, Job Title, Department, Business Unit, Annual Salary, Bonus, Hire Date, Exit Date, Status

---

✅ Features

• 🔹 Total Employees
• 🔹 Active vs. Inactive Employees
• 🔹 Top 10 Highest Paid Employees
• 🔹 Employees by Age Group
• 🔹 Employee Count by Department
• 🔹 Years of Service & Age by Gender
• 🔹 Exit Count by Age Group and Gender
• 🔹 Exit Count by Gender and Department
• 🔹 Macro-Enabled Buttons for Interaction (Full Screen & Refresh)

---

📌 Highlights

• Built an interactive HR analytics dashboard in Excel to analyze data for 729 employees across 6 departments, integrating slicers and pivot charts for dynamic insights.
• Visualized key HR metrics such as active vs. exited employees (101 exits), top 10 earners (up to $1.4M/year), and age group distributions to support workforce planning and retention analysis.
• Automated functionality using VBA Macros, including buttons for full-screen view and dashboard refresh, enhancing usability and professional presentation.

---

🧠 Insights You Can Draw

• Current active workforce and attrition rate
• Highest-paid employees
• Departmental distribution of employees
• Age and experience distribution
• Exit trends segmented by age, gender, and department

---

📎 Tools Used

• Microsoft Excel
• Pivot Tables / Charts
• VBA (Macros)
• Slicers
• Data Visualization & Reporting

---

🛠️ How to Use

1. Download the Excel file from this repository
2. Open the file and enable Macros
3. Use slicers to filter and explore data dynamically
4. Click the buttons to toggle Full Screen or Refresh the dashboard

---

🚀 Lessons Learned

This project helped me:

• Improve my HR data analysis skills
• Automate actions using VBA Macros in Excel
• Design a clean, functional, and interactive dashboard
• Translate raw HR data into valuable insights for decision-making

---

📷 Dashboard Preview

🔗 Click to view full image

---

📥 Download

👉 Download Excel Dashboard File (.xlsm)