Manual and time-consuming reporting<\/h2>\n\n\n\n
Dean Russell, Head of Temporary Staffing at the Trust, had previously been using raw data from the RLDatix Optima rostering system for reporting and analysis, which was challenging due to the sheer amount of data he was dealing with and the time it took to download, export and then upload into their BI tool. For Dean, who regularly needed a clear view of bank and agency data, viewing and analysing week-onweek workforce data was a simple task within RLDatix Optima, but long-term trend analysis over two years or more, was much more time-consuming. The team would need to download 104 separate reports, wait 6 hours each time whilst they downloaded and then manually run queries on them. The Trust wanted to move away from operating according to the \u2018feel of things\u2019 and employ a more evidence-based way of working, putting data at the forefront of their decision-making.<\/p>\n\n\n\n
Powering their BI with RLDatix DataHub<\/h2>\n\n\n\n
With a data-first mindset, the Trust decided to start using RLDatix DataHub to feed their workforce data into their business intelligence tool \u2014 which immediately empowered them with insights they\u2019d
never had access to before. The Trust is looking at improving planning and oversight within the organisation and one such measure is looking at the distribution of leave across the financial year. But with over 900 cost centres across the Trust and the sheer amount of data, it was something they had never been able to produce before.<\/p>\n\n\n\n
Visibility of this information at a local level only meant no one had complete oversight for the entire Trust, which often led to staff building up leave and requesting time off at the same time \u2014 resulting in The access to up-to-date workforce information via their BI tool has been transformative for Dean and his team. FOI requests are a regular occurrence and the team would spend weeks collating all the information manually. They are now automatically feeding this data directly into a dashboard in their BI tool, allowing them to respond quickly. <\/p>\n\n\n\n Dean has built a dashboard encompassing all regular requests the team receives \u2014 so if someone asks him how many off-framework bookings they had last month, he can just click a button and share.<\/p>\n\n\n\n \u201cOne of the most powerful things has been theeasy accessto up-to-date data. The ability to pull out what you need really quickly is helping usto makeinformed decisions and dispel myths,\u201d commented Dean.<\/p>\n<\/blockquote>\n\n\n\n As part of a wider Trust initiative to reduce agency spend, Dean and his team have set up a dedicated dashboard for clear visibility of when rosters are being sent out, when shifts are being sent to bank and the average time to fill \u2014 helping to identify trends in booking behaviours.<\/p>\n\n\n\n By feeding this data into their BI tool, they have been able to triangulate it with demographical data from their ESR. The team can now see who is picking up shifts and why, helping to understand what motivates people and supporting them to fill shifts before going to agency.<\/p>\n\n\n\n The transparency of data gives the Trust confidence in the decisions they are making. The triangulated data means they can easily see and evidence the positive impact their decisions are having on agency spend.<\/p>\n\n\n\n \u201cPublishing rosters six weeks in advance and sending them to bank sooner helps to increase fill rates. This is best practice that all healthcare organisations know. We now have the evidence to back this up and demonstrate it, which has made it so much easier to convince the Trust that priorities need to change and it needs to be about planning ahead. The transparent data is having a big impact, it\u2019s empowering people to change mindsets and behaviours.\u201d Dean Russel, Head of Temporary Staffing, Mid and South Essex NHS Foundation Trust<\/em><\/p>\n<\/blockquote>\n\n\n\n \u201cIt\u2019s not useful to simply see agency use going up and down. What isreally useful is having visibility of behavioural analysis and trends on thingsthat might impact agency usage. Thisis helping usto The big benefit for Mid and South Essex has been the triangulation of data. They have started triangulating their workforce data with multiple other sources, such as ESR, vacancy, budget establishment and spend data.<\/p>\n\n\n\n The team now have a connected view of workforce data and vacancies from each cost centre, making it simple to pinpoint areas that are operating outside the vacancy numbers they are established for.<\/strong><\/p>\n\n\n\n With workforce data automatically available in their BI tool, the Trust can now easily reconcile their demand templates and Finance Standard Rosters (FSRs), showcasing the monthly ESR budget and vacant duties, highlighting any disparities between demand and capacity.<\/p>\n\n\n\n\n\n In the long term, Dean wants to triangulate workforce and patient activity data, so the Trust can spot trends such as the types of patients coming in and when \u2014 and how that impacts sickness, fill rates, bank and agency usage.<\/p>\n\n\n\n From this, they will get a true idea of the driving forces behind bank and agency usage, allowing for better workforce planning. Dean would also like to incorporate machine learning and generative AI reports, helping them to identify things they can\u2019t see from a surface-level analysis. From there, the Trust can build an interventional framework to mitigate risk and introduce positive change.<\/p>\n\n\n\n
lots of leave carryover and requirements to fill the shortages with bank or agency staff. This information will be automatically fed into the Trust\u2019s BI tool via RLDatix DataHub, making it available at the touch of a button \u2014 which will be a game changer, according to Dean. <\/p>\n\n\n\n![\"\"](\"https:\/\/www.rldatix.com\/en-uki\/wp-content\/uploads\/sites\/6\/2025\/11\/image-1.png\")
<\/figure>\n\n\n\n\n
Feeding workforce data into BI \u2014 timesavings<\/h2>\n\n\n\n
![\"\"](\"https:\/\/www.rldatix.com\/en-uki\/wp-content\/uploads\/sites\/6\/2025\/11\/Feeding-workforce-data-into-BI-1024x445.png\")
<\/figure>\n\n\n\nSupporting agency reduction<\/h2>\n\n\n\n
\n
understand why it\u2019s going up and down. It\u2019s providing us a layer of transparency we didn\u2019t have before,\u201d said Dean.<\/p>\n\n\n\nTriangulating data<\/h2>\n\n\n\n
Looking to the Future<\/h2>\n\n\n\n
![\"\"](\"https:\/\/www.rldatix.com\/en-uki\/wp-content\/uploads\/sites\/6\/2025\/11\/iStock-2153183376_edited-1024x691.jpg\")
<\/figure>\n\n\n\n