A suite of reports to manage absence levels and behaviour patterns, particularly around the management of individuals that reach trigger events that will a defined HR process, i.e. 3 absences in 3 months.
Originally designed for a client's HR Reporting Portal (previously in SSRS) it was remodelled for PowerBI as the Power suite provides a significant capability increase in usability through self service, interaction, data security and ease of use.
The full reporting suite enables:
- Analysis of the departments and sub-sections such as people, ration and composition
- Row level security on the data to enable distribution to relevant section managers
- Drill downs and drill through of data to view aggregated and transactional data
- Ad-hoc analysis via PowerBI and Excel
- Engaging infographic design incorporated for a more dynamic user experience
The solution replaces a manually intensive 2 week long quarterly production of an excel spreadsheet, with overnight processes that provide up to date, interactive and actionable information.