HR Power BI Dashboard & KPI Reporting
Workforce analytics and management reporting
The Problem
HR leadership lacked real-time visibility into workforce metrics. Reports were manual, inconsistent, and often outdated by the time they reached decision-makers.
What I Built
Built a connected Power BI dashboard suite with automated data refresh, interactive filtering, drill-down capabilities, and KPI tracking for strategic workforce insights.
My Role
Led dashboard development from requirements gathering to deployment. Created data models, DAX measures, and interactive visualizations.
How It Works
Star schema data model for optimal query performance
DAX measures for YoY comparisons, turnover rates, tenure analysis
Row-level security for sensitive HR data
Drill-through pages for detailed analysis
Automated refresh via Power BI Service
Key Takeaways
Data modeling is the foundation of effective dashboards
User training is as important as dashboard design
Iterative feedback improves adoption