Your AI roadmap starts here
AI Pathfinder
layer 1 layer 2 layer 3 layer 4 layer 5 abstract shapes

From SPC Charts to Scalable Insight: Supporting Quality Improvement Across 215 Mental Health Wards

  • EasySPC
  • Power BI

Client Profile: Royal College of Psychiatrists

Royal College of Psychiatrists Logo

The National Collaborating Centre for Mental Health (NCCMH) at the Royal College of Psychiatrists (RCPsych) launched its Culture of Care programme to improve quality and culture across inpatient mental health services nationwide.

Covering 58 NHS trusts and independent providers of mental health, learning disability and autism inpatient care, and around 215 mental health wards, the programme set out to bring greater visibility of key quality improvement (QI) metrics, ensuring wards were safe and equitable places to be cared for, and fulfilling places to work.

But delivering that vision meant overcoming a significant challenge: how to turn huge amounts of fragmented, multi-source data into something consistent, reliable, secure and scalable.

Working alongside RCPsych, BCN provided the tools, expertise and hands-on support needed to build strong data foundations for scalable, multi-organisation insight, into live, accessible dashboards.

  • BCN Services Provided

    • Dashboard development
    • Automated SPC charts
    • Data modelling and architecture
    • Access and hosting solutions
  • Key Technologies

The Challenge

The Culture of Care programme was ambitious by design. Data needed to be collected at ward level across dozens of organisations, each with their own processes, systems and constraints.

In practice, this meant chasing data from multiple people, receiving it in different formats, and working within strict data-sharing rules while trying to build a consistent view of performance across the programme. With large volumes of data but no clear route forward, BCN needed to approach the technology from multiple angles.

Key challenges included:

  • Inconsistent data inputs from multiple NHS trusts
  • The need to standardise and integrate data into a single view
  • A requirement for secure access control, ensuring each trust could see only its own data in detail, and only top-level insight from other trusts

All while making sure the solution was practical, minimised manual effort, and supported ongoing programme delivery.

Quote

To build a system which can potentially take data from 60 trusts and integrate that into one platform has been quite a challenge.

Helen Greenwood

Research and Design Officer

The Solution

From SPC requirement to full data ecosystem

RCPsych initially approached BCN with a specific need. They wanted a simple way to create SPC charts within Power BI, so they could turn ward-level data into visually meaningful dashboards, fast. They needed to make data easier to understand, easier to act on, and easier to share.

QI Data Analyst at RCPsych Ami Saito said finding the right technology partner was key. “With the combination of Power BI and SPC charts, BCN was the only one that offers this simple solution.”

But as the programme evolved, so did the scope of the solution. What started as a straightforward tooling requirement quickly became a broader data challenge, and BCN’s role expanded to match.

As part of this programme, two distinct datasets and dashboards were required.

  1. Survey dashboard – This collected new data via Jotform directly from patients at relevant NHS Trusts. The data fed directly into the dashboard live. BCN helped setting up the secure dataflow into the Power BI dashboard through Power Automate.
  2. Proxy data (collected from relevant NHS Trusts) – This collected pre-existing data from relevant NHS Trusts. This required cleaning and processing for standardisation.

BCN also set up the row level security, making sure Trusts can’t see each other’s data, while allowing internal coaches to oversee all the Trust/Ward data.

It was no longer just about providing and implementing EasySPC; our teams were working closely with the RCPsych team to build a complete, scalable data approach.

The project included:

  • Dashboard development in Power BI, combining SPC charts and other visualisation charts
  • Data modelling and structure, enabling consistent reporting across multiple sources, such as incident data and survey data
  • Automation and data capture, reducing manual workload and improving reliability
  • Data flow and architecture design, ensuring information moved securely and efficiently at all points, from collection to visualisation
  • Row-level security, allowing each trust to see its own data alongside aggregated programme data
  • Access and hosting solutions, including licence options for users without Power BI requirements

Far from a single, simple tool, the result was a connected system designed to handle the realities and complexities of sensitive, multi-organisation data at scale.

The Delivery

Collaborative problem-solving at every stage

One of the defining aspects of the project was its complexity, and the need to quickly adapt as new challenges arose.

Data arrived in different formats at different times. Building a consistent pipeline required ongoing collaboration, multiple trials, and technical input from both sides. Solutions were tested, refined and revisited as new challenges emerged, from data delays to evolving security requirements. Iteration became the order of the day.

Working alongside the RCPsych team as a hands-on partner, we were able to:

  • Refine how data was collected and standardised
  • Design and optimise data flows
  • Implement security models that balanced access with governance
  • Continuously improve the dashboard experience as the programme progressed

Crucially, as the system developed, so did the team’s confidence in working with Power BI, SPC and data-driven reporting.

The Outcome

By the end of the programme, RCPsych had established a workable, scalable approach to multi-organisation reporting.  This has enabled:

  • Secure, role-based access to data at both trust and aggregate level
  • Introducing live dashboards for a national programme
  • Greater visibility of ward-level data across the programme
  • Reduced manual effort through automation and structured data flows
  • Increased internal capability in data visualisation and SPC-led insight

While formal evaluation of the outcomes is still underway, the infrastructure and approach developed through the Culture of Care programme provide a strong foundation for future quality improvement initiatives.

Early feedback on the dashboards is positive, from a range of People, from Ward staff to Trust Data & Insight teams, as well as NHS England. Many also expressed interest in learning more and gaining similar insights on developing dashboards.

A true partnership

Beyond the technology, the relationship between RCPsych and BCN played a key role in the success of the project.

“The relationship with BCN was really close-knit,” said Ami Saito, RCPsych QI Data Analyst.

What began as a search for a specific SPC capability evolved into a broader collaboration, combining tools, expertise and problem-solving to support a complex, high-impact programme of improvement.

Client Quote

With 58 organisations including NHS trusts and independent sector providers, and over 200 NHS mental health care wards, it was a big quality improvement programme. BCN were a true ‘partner’ in every sense.

Helen Greenwood

RCPsych Research and Design Officer

Looking ahead

The Royal College of Psychiatrists Culture of Care programme highlights what’s possible in healthcare settings when the right data foundations are in place. 

For organisations looking to deliver quality improvement at scale, the challenge is rarely just about tools. It’s about making data relevant, useable, secure and meaningful across teams, organisations and systems. 

And that’s where the right technology partner can make the world of difference. 

As the Culture of Care programme shows, combining the right tools with the right expertise can turn even the most complex data challenges into clear, actionable insight at scale. 

Ready to start making meaningful improvement in your organisation?

Get in touch today to see how we can turn your data into insight your teams can actually use.

Learn more down down down