03Workforce analytics
Employee voices.
A clearer picture.
Transforming 2,650+ exit-survey responses into clear workforce insights and reducing reporting time by 50%.
- Organisation
- Department of Communities WA
- My role
- Data & IT Intern
- Focus
- Workforce analytics
- Year
- 2025
Employee voices.
One clearer view.
The challenge
Start with the
business question.
Make a large collection of exit-survey responses easier to analyse and explore for People & Culture stakeholders, while reducing the effort involved in manual reporting.
My contribution
From understanding
to delivery.
Within the Reporting, Insights & Analytics team, I transformed survey responses using Power Query, developed DAX measures and built an interactive dashboard. I also cross-checked more than 500 data points as part of validating the analysis.
- 01
Prepare the responses
Cleaned, unpivoted and normalised survey records in Power Query.
- 02
Build useful measures
Used DAX and SQL integration to support the analysis and reporting.
- 03
Make patterns readable
Created targeted visuals and slicers so stakeholders could explore the results.
- 04
Check the evidence
Cross-verified more than 500 data points and considered how findings should be communicated.
50% less time spent on manual reporting.
The interactive Power BI dashboard brought together 2,650+ exit-survey responses and reduced reporting time by 50%, making the information easier for the team to explore.
Relative reporting effort, with the previous process indexed to 100%.
What I took away
People data represents real experiences. Checking the measures, considering missing information and explaining limitations are all part of responsible analysis.
The figures describe project scale and reporting outcomes. No employee records, survey responses or internal dashboard screenshots are displayed.