Just built an interactive Workforce
Nikhil Mishra
Just built an interactive Workforce Analytics Dashboard in Excel
This project focuses on analyzing employee distribution, compensation trends, and hiring patterns (2015–2025) — all inside Excel.
Key highlights:
• Connected to a SQL database for dynamic data handling
• Used Power Query + Pivot Tables for transformation & modeling
• Implemented VBA Macros for automation (refresh, navigation, insights)
• Designed an intuitive UI with drill-down insights
What it delivers:
✔ Salary distribution & employee segmentation
✔ Department-wise workforce trends
✔ Hiring trend analysis over time
✔ Automated employee insights (highest paid, tenure, etc.)
This project pushed me to go beyond basic Excel and treat it like a full analytics tool instead of just a spreadsheet.
Still improving — next step is taking this level of analysis into Power BI & Python.
#Excel #DataAnalytics #Dashboard #SQL #DataScience #BusinessIntelligence #Automation
Like this project
Posted Apr 15, 2026
Just built an interactive Workforce Analytics Dashboard in Excel This project focuses on analyzing employee distribution, compensation trends, and hiring pat...
Likes
0
Views
0
