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

Capacity and demand tracking with Power BI

  • Capacity and Demand Tracker
  • Power BI

Customer profile

BCN were challenged to develop and enhance the Trusts new ‘Capacity and Demand Tracker’ to identify additional indicators for a daily briefing for senior managers. It needed to be in a user-friendly format for users to quickly identify issues with capacity and available demand. 

  • Client

    Cheshire & Merseyside Health and Care Partnership

  • Sector

    Healthcare

  • Project

    Capacity and Demand Tracker

  • Solution

Testimonial

We needed the solution to give us clear measures to the capacity and demand tracker but for it to be presented in a format so we can easily see where the pressure in the system is before it exceeds capacity. BCN also helped us to develop an automated daily briefing report for senior managers who are busier than ever due to Covid-19 so they can address urgent issues quickly. This simply did not exist before and is now guiding our decision-making process, putting us in a far better position to keep services running smoothly. It has really improved communication and conversations across the board.

Chris Lyons

Director of Corporate Transformation at Mersey Care NHS Foundation Trust

Challenge

Develop and enhance the Trusts new ‘Capacity and Demand Tracker’ to identify additional indicators for a daily briefing for senior managers. It needed to be in a user friendly format for user to quickly identify issues with capacity and available demand.

Solution

BCN’s Power BI and Healthcare team worked closely with Cheshire & Merseyside Health and Care Partnership to evolve their tracker and create a bespoke dashboard.

Results

The solution automatically generates a daily briefing report to senior managers across the region. All 20 Trusts in Cheshire and Merseyside can drilldown the report and show the data they need to compare and identify hotspots within the system.

  • The tracker highlights where demand is building up so action can be taken before it reaches a critical point
  • It covers a wide range of indicators across both primary and secondary care; A&E acute, care homes, domiciliary care, community and mental health

Its very well received across the organisations.

Testimonial

We’re absolutely delighted to support Chris and his team to develop the capacity and demand tracker which is improving decision-making across health and social care organisations in the whole Cheshire and Merseyside region. The easy to read bespoke report templates we developed in Microsoft Power BI enabled us to speed up the development time to ensure the capacity and demand tracker was deployed to support the regions activity during increased operational pressures due to COVID 19. We designed and implemented a Microsoft Azure Data Services architecture integrated into Power BI to optimise the ETL (extract, transform, load) process to significantly reduce the internal administration effort required for the daily briefing report to be easily shared with external stakeholders.

Taran Sohal

BCN Group

Related success stories

Back all customer stories down

01 02 03  / 03

Alder Hey Children’s Hospital

Alder Hey and Liverpool Heart and Chest NHS Trust needed to roll out Power BI across the joint analytics team. Our solution helped key stakeholders utilise and adopt Statistical Process Control (SPC) charts much more easily and efficiently for their monthly Integrated Performance Reports.

View Case Study right
  • EasySPC
  • Healthcare
  • Power BI

Hampshire Hospitals NHS Trust

Employing over 8,000 staff, Hampshire Hospitals provides acute care services to over 600,000 patients. Despite initial hesitations, the Trust were impressed with the granularity in which Public View enabled performance monitoring, benchmarking, and comparison of other Trusts, causing Hampshire to sign a 3-year contract for Public View.

View Case Study right
  • Healthcare
  • Public View

Rotherham NHS Foundation Trust

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.

View Case Study right
  • Healthcare
  • Power BI
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