Developing and Deploying a Benefits Accelerator Dashboard Power Pages

Case Study

Benefits Accelerator Dashboard

Delivering Real-Time Benefits Realisation for NHS EPR Programmes Across Multi-Trust Collaboratives

Background: The Challenge of Scaling Benefits Realisation

Max20 delivers end-to-end project solutions across the public sector and healthcare, with a strong focus on NHS programmes. For large-scale initiatives such as Electronic Patient Record (EPR) programmes, NHS England requires Trusts not only to demonstrate delivery, but also to evidence that expected benefits and return on investment (ROI) are being realised—across areas such as patient outcomes, productivity, efficiency, and risk reduction.

Historically, benefits tracking was managed through spreadsheets and manual processes. This approach created significant challenges: data quality suffered, consistency was difficult to maintain, and timely reporting became increasingly burdensome. As programmes grew and involved multiple organisations, the limitations of spreadsheet-based tracking became untenable. A more intuitive, secure, and scalable digital solution was required.

Max20 Project Solutions and AT Technical partnered to deliver a Benefits Accelerator Dashboard for Norfolk and Waveney University Hospitals Group (NWUHG). This multi-Trust collaborative needed a single, shared platform to support benefits tracking across organisations, whilst enabling clear reporting at programme level and reducing the administrative burden on transformation teams.

Why AT Technical

AT Technical specialises in delivering bespoke solutions across the Microsoft Power Platform. Our team of Microsoft-certified consultants bring decades of combined experience delivering complex solutions in both public and private sector environments.

We understand the governance, security, and scalability requirements of NHS and public sector programmes, and we design solutions that align with enterprise standards whilst remaining flexible enough to evolve with programme needs. This combination of technical depth and sector understanding made AT Technical a trusted delivery partner for this programme.

The Challenge

NWUHG comprises three acute hospital Trusts, each with its own operational structures and benefits plans, whilst needing to operate under a single EPR programme framework. The solution had to support both local ownership and collaborative reporting. This created several interconnected challenges:

Key Obstacles

  • Fragmented data: Consolidating benefits data from multiple Trusts into a single, consistent system
  • Infrastructure dependency: Avoiding reliance on any single organisation's infrastructure, which would restrict access and collaboration
  • Manual processes: Replacing paper-based and spreadsheet-driven processes that caused delays, data loss, and inconsistent validation
  • Resource constraints: Limited internal capacity within the EPR programme to design, build, and support a digital solution

Impact Without Resolution

Without addressing these challenges, it would have been extremely difficult to maintain momentum, consistency, and visibility across Trusts and Directorates, regardless of how strong the underlying benefits strategy was. The programme risked losing credibility with stakeholders and struggling to demonstrate value to NHS England.

The Solution: Benefits Dashboard on Power Pages

AT Technical designed and delivered a secure, scalable Benefits Dashboard using Microsoft Power Pages and Dataverse as part of the wider Power Platform ecosystem. The solution provides a single source of truth for benefits management, supporting the full lifecycle from proposed benefits through to realised and retired outcomes.

Whilst the underlying architecture is standardised, the system is sophisticated enough to support:

  • Role-based access control to protect sensitive data and ensure users see only relevant information
  • Trust-level ownership of benefits and enablers, allowing individual organisations to maintain autonomy
  • Programme-level aggregation and reporting that consolidates data across all Trusts for oversight
  • Tracking of benefit values, realisation profiles, and change enablers throughout the benefit lifecycle
  • Automated workflows to support governance and review processes, reducing manual administration
Benefits Accelerator Dashboard interface showing benefits tracking and progress visualisation

The Benefits Dashboard provides an intuitive interface for tracking, monitoring, and reporting on benefit realisation across multiple Trusts.

Power BI Analytics for Real-Time Insights

Power BI dashboards surface live data for stakeholders, enabling transparent reporting and supporting informed decision-making across the collaborative. Leadership and programme teams can access real-time analytics without needing to request reports or wait for manual consolidation.

The platform is hosted independently of individual Trust infrastructure, ensuring equal access and long-term scalability. This architecture means that as the programme grows or additional Trusts join, the system can expand without infrastructure constraints.

Power BI dashboard showing real-time benefits analytics and programme metrics

Power BI dashboards provide stakeholders with real-time visibility of benefits realisation progress and programme metrics.

Technology Stack

The solution was built on the Microsoft Power Platform, leveraging a modern, scalable architecture:

📄 Power Pages
💾 Dataverse
⚙️ Power Automate
📊 Power BI
🔄 Power Platform Pipelines (ALM)

The Results: Transforming Benefits Realisation

The Benefits Accelerator Dashboard has delivered measurable improvements across the entire benefits realisation process:

✓ Standardised Benefits Capture & Governance
✓ Improved Data Quality & Consistency
✓ Real-Time Visibility with Automated Reporting
✓ Reduced Administrative Burden on Teams
✓ Scalable Architecture for Future Growth
✓ Stronger Evidence Base for ROI Demonstration

The platform now supports ongoing benefits realisation activity, not just retrospective reporting. This means the programme can actively manage and maximise outcomes, rather than simply documenting what has already been achieved.

Stakeholder Perspective: Real-World Impact

The success of the Benefits Dashboard is best evidenced by the feedback from those using it day-to-day:

"We now have a methodology and dashboard that gives real oversight. That means we can influence programmes like New Hospitals – programmes interested in what meaningful benefits realisation should look like."

– Jonathan Harrowven, EPR Transformation and Adoption Programme Manager, NWUHG

"The dashboard created a tool that was practical, and we could use even after our engagement with Max20 came to a close."

– Emily Wells, Chief Nursing Information Officer, Norfolk and Norwich University Hospitals

Key Takeaways

This case study demonstrates several important principles for healthcare transformation programmes:

  • Digital-first benefits tracking: Moving beyond spreadsheets enables consistency, speed, and confidence in reporting
  • Collaborative architecture: A shared platform that respects individual Trust autonomy whilst enabling enterprise-level visibility creates trust and adoption
  • Security and governance by design: Public sector solutions must embed compliance and security from the start, not as an afterthought
  • Practical, sustainable solutions: The best healthcare technology solutions are those that teams can own and evolve independently
  • Real-time decision-making: Automated reporting transforms benefits realisation from a compliance exercise into a strategic management tool

Learn More About Power Pages

The Benefits Accelerator Dashboard exemplifies the power of Microsoft Power Pages for building secure, scalable, multi-tenant solutions in regulated environments. If you're considering similar solutions for your organisation, AT Technical can help you design and deliver transformational technology.

Learn More About Power Pages

For more information about this project, visit Max20's case study.

Ready to Transform Your Benefits Realisation?

Whether you're managing NHS programmes, public sector initiatives, or complex enterprise projects, AT Technical can help you build solutions that drive real outcomes and demonstrate measurable value.