Implementing a new data solution to reduce reporting times and centralise data

Surrey and Borders Partnership NHS Foundation Trust

Implementing a new reporting solution, DataHub

Surrey and Borders were looking for ways to reduce further time spent on manual reporting of rostering data, as well as ways to import data from across their organisation into a central data warehouse to facilitate analysis and triangulation. To help achieve these two goals, they joined one of RLDatix’s Early Adopter Programs in October 2022.

They implemented a new reporting system, DataHub, which safely and securely delivers structured workforce data from Optima directly to a business intelligence tool or data warehouse.

“It’s been absolutely fantastic to work with DataHub. Accessing the data has been really quick and easy.”

Craig la Buscagné, Workforce Intelligence Manager Surrey and Borders Partnership NHS FT

Automating reports through DataHub

The first issue Surrey and Borders were looking to solve was the large amount of time spent on manually creating the same reports on a daily or weekly basis. Since implementing DataHub, the Trust has been able to automate a key report, Unavailability of staff, which feeds into a Covid return that is sent daily to NHS England.

The report was created using the workforce data from Optima and delivered by DataHub directly into the Trust’s BI Tool each day. Now, when these reports are needed, the appropriate stakeholders simply go into their BI Tool and view the latest version of the reports, which are automatically updated via the DataHub. This massively reduces administrative time. Around 1 hour per day has been saved through automating reports with data imported through DataHub.