HR Analytics Dashboard

The Challenge

HR business partners were piecing together attrition and headcount metrics from spreadsheets exported manually from the HRIS each month, with no consistent definitions across departments. By the time a report was finalised, the data behind it was already weeks old — making proactive retention efforts nearly impossible.

The Approach

The goal was a single semantic model that HR could trust and explore on their own, refreshed often enough to actually act on.

• Consolidated employee data from multiple HRIS exports into a single SQL Server staging layer.
• Built a star-schema semantic model with DAX measures for attrition, tenure, and performance-band breakdowns.
• Used Power Query for repeatable, auditable data cleansing instead of manual spreadsheet edits.
• Designed drill-through pages so business partners could move from company-wide trends down to individual department detail.

The Results

HR went from waiting on a monthly export to checking a live dashboard whenever they needed it — and trusting the numbers when they did.

Key Takeaways

Giving HR a single, well-modeled source of truth mattered more than any individual chart. Once the definitions were consistent and the refresh was daily, business partners started spotting attrition risk in days rather than discovering it a quarter too late.