Real time performance against SQF reporting standards
With an agreed prioritised backlog of metrics, we embarked on a delivery phase focused on development of vertical slices across the tech stack to maximise value for our end-users throughout the project.
It’s often tempting to work horizontally in dashboard development, trying to finalise the data ingestion layer before moving onto the scripting for all data sources and metrics, and only then starting to develop the dashboard. The end-users only see the dashboard, so they don’t realise value until the end phase of the project. By slicing the project vertically, we’re able to create a tight feedback loop with our users as they are seeing tangible value in the dashboard during the entire delivery cycle and have a chance to provide feedback throughout.
A final output of the project was a Power BI dashboard, deployed within the provider’s existing Microsoft technical ecosystem. The dashboard offered 2 views for the user; an overview and comparison. For the purposes of data privacy, we have used dummy data and a fictional organisation in the below dashboard examples.
SQF dashboard | monthly snapshot
View interactive dashboard in Playground by Aginic
The overview allowed users to see a quick snapshot by month, of their performance against metrics aligned to the 8 SQF standards. Results were grouped at a facility, state and organisation level.
Each standard occupies a section within the dashboard linked to the SQF reporting framework, totalling 42 indicators (sample subset of metrics above).
The tool primarily incorporates measures of consumer experience as well as care plans, mandatory training modules, incidents and hazards, pastoral care visits and more. Information can be filtered down to a particular facility and reporting month. The team leveraged pre-existing technical infrastructure and data from a broader data platform project, encompassing a suite of reporting across the wider providers group level, leading to faster and more efficient deployment of the reporting solution.
SQF dashboard | portfolio comparison
The comparison report offered a 1 page view across all facilities and metrics to highlight learning opportunities for those facilities with a lower risk profile than others. It also allowed a quick snapshot into the gaps where data hasn’t been collected for that particular facility or month. Creating this feedback loop is crucial to engage with users, as they can now clearly see the impact of accurately recording vital data points as part of their daily processes.