layer 1 layer 2 layer 3 layer 4 layer 5 abstract shapes

Reducing Rotherham's outpatient wait time by 65%

  • Power BI

Connecting multiple data sources and transforming the way their performance data is collected, presented, disseminated, and analysed, BCN harnessed Power BI to link the Trust’s data sources and create near real-time data visualisations for 250,000 outpatient appointments.

  • Customer

    • Rotherham NHS Foundation Trust
  • Sector

    • Healthcare
  • Project

    • Automated Power BI Visualisations
  • Technology

    • Microsoft Power BI


Managing complex outpatient flows had presented the Rotherham NHS Foundation Trust with a number of challenges. Before we began working with the Rotherham General Hospital team, managers and clinical staff were manually combining national and hospital-level data spread across multiple systems and spreadsheets. This laborious process meant snapshot reports could only be produced either weekly or monthly – and they were out of date within an hour. As a consequence, service managers had only a rudimentary grasp of capacity and demand and waiting lists remained stubbornly high.

BCN’s expertise in healthcare led them to use Microsoft Power BI to link data sources and create near real-time data visualisations for 250,000 outpatient appointments.


Rotherham General Hospital’s new system based on Power BI:

  • reduced outpatient waiting lists by 65% in some areas after just 6 months generating an annual cost saving of £800,000.
  • combined data from national hospitals (e.g. eRS) with the hospital’s own database
  • provided organisation wide access from desktop PC and the cloud
  • collated information in clear and simple interactive visual charts
  • improved the management of finances, HR, theatres, outpatient and A&E
  • provided data on which timely resource allocation decisions could be based
  • equipped frontline staff and managers with real time data tools
  • provided analytics data on which to better predict future needs.
  • reduced internal technical resource requirements by automating many processes.


We can very quickly plug into different sources of local and national data and all the visualisations update automatically in real time – you don’t need someone to refresh it manually.

James Rawlinson

Director of Health Informatics

BCN's Holistic Approach

Constrained by funding pressures, the Trust rolled out the system at minimal cost and almost instantly recouped the investment many times over by recording the dramatic results mentioned above after just six months.

Rotherham Hospital deals with around 75,000 A&E patients, 55,000 inpatients and 250,000 outpatient attendances each year.

We worked closely with the Trust’s operational and IT teams to address their key objectives and used our expertise in Microsoft BI as the key to developing bespoke processes which solve many of the organisation-wide data issues.

BCN took a holistic approach to bringing the data to life. This involved collating, automating and linking data and also representing the data in visually appealing, interactive charts that make life much easier for managers, frontline staff and decision-makers on all levels.


Power BI presents engaging visualisations across multiple platforms and fits with our cloud first strategy, enabling staff and partners to access information from any connected device, with a low TCO. It’s been a real game-changer for us. It’s being used daily, on an operational level to manage performance around activity, finances, HR, theatres, outpatient and A&E.

James Rawlinson

Director of Health Informatics

Related success stories

Back all customer stories down

01 02 03  / 03

NHS Liverpool CCG

Acting on a referral from two NHS organisations, Liverpool CCG approached BCN to replace a Power BI Covid-19 dashboard within a 14-day deadline, and move their existing performance data into an optimised, easy-to-use analytics reporting system

View Case Study right
  • Azure
  • Healthcare
  • Power BI

East London NHS Foundation Trust

East London NHS Foundation Trust (ELFT) is renowned across the UK’s public health sector as a pioneer of continuous quality improvement. ELFT now uses SPC Charts to provide its teams with intelligent insights in near real-time to support the prediction of future trends, the identification of variations and data-informed decision-making.

View Case Study right
  • EasySPC
  • Healthcare
  • Power BI

Walsall Healthcare NHS Trust

Walsall NHS Foundation Trust wanted to replace their existing intranet with the LiveTiles Enterprise and Reach platform to improve workplace communication and upgrade user experiences.

View Case Study right
  • Healthcare
  • LiveTiles
prev prev

Ready to grow your business? Let’s talk tech.

Follow the link or speak to one of our experts on 0345 095 7000

Get in touch down down down