Uncovering the power of Power BI: embedding new practices, empowering users & the handover process

Uncovering the power of Power BI: embedding new practices, empowering users & the handover process

In our previous blog in this three-part series, we explored the ‘meal delivery model’ for the Power BI platform and the tools and teams required to bring this model and its methodology to life. In the final blog of this series, we’ll assess how new practices can be embedded and users empowered as the solution build is underway, as well as how to effectively carry out the handover process for a seamless go-live. 

To read our full whitepaper that outlines additional methodology and best practices to unlock all that Power BI has to offer, click here.   

Embedding new practices and empowering your users

To effectively embed new practices and empower users, evaluating training and resources will be fundamental for a successful Power BI migration. Conducting a training and resource assessment to evaluate users’ training needs and ensure they’re equipped with the necessary skills and confidence to use Power BI will be key to maximising its value. Planning a range of training for various users will be particularly impactful in this case, as will offering the right training to the right users. Communicating expectations, project and migration updates and overarching benefits will also be critical, especially when users are asked to contribute and to change established practices. 

The handover process

Prior to going live, ensuring the necessary solution documentation is in place for both user and developer reference will be vital. Holding handover sessions for your BI team, your IT team and management, unifying support and resources and making sure the helpdesk is both responsive and reactive to any technical issues that arise will bolster this.  

To help determine response times for any technical issues arising, users’ needs that would have arisen during the discovery phase of the project must be understood. Departmental or team champions for non-technical Power BI users can therefore bolster outcomes in these circumstances, and managed support can alleviate the burden of updates and adaptations in fast-changing NHS environments.  

Time must be allocated for handover sessions for the BI team, IT team and management. This will serve as an additional opportunity to reiterate the benefits of the new PowerBI solution along with a practical introduction. Consistent monitoring and feedback should be sought out to refine helpdesk processes and continue deriving the full benefits that the solution can provide as the handover stage continues.  

While PowerBI is an exceptionally flexible platform and will expand and adapt to accommodate new data and reporting requirements, having the necessary development resources available to make changes and upkeep the solution will be paramount. 

How CACI can help

Migrating to PowerBI enables NHS stakeholders to achieve new strategic goals and transform their analytical capabilities. CACI understands the value that migrating to PowerBI can bring, which is why we have developed our own set of best practices and key principles for PowerBI migrations within the NHS. We strive to deliver a seamless migration built on our extensive experience in NHS data and technology, prioritising stakeholder engagement, providing reliable reporting, secure data sharing and self-sufficient BI capabilities for data-driven decision-making. 

For more information or help with Power BI project planning, delivery or ongoing managed services, contact us today. To learn more about how you can tap into the power of Power BI, our whitepaper outlines the best practices and methodology that will boost your understanding and usage. 

Read the rest of the series here:

  1. Uncovering the power of Power BI: discovery & delivery framework
  2. Uncovering the power of Power BI: ‘meal delivery’ model & critical resources

Uncovering the power of Power BI: ‘meal delivery’ model & critical resources

Uncovering the power of Power BI: ‘meal delivery’ model & critical resources

In our previous blog in this three-part series, we uncovered the value of thorough discovery and how to build a successful project delivery framework. Today, we’ll explore the ‘meal delivery model’ for the Power BI platform and the tools and teams required to bring this model and its methodology to life.  

To read our full whitepaper that outlines additional methodology and best practices to unlock all that Power BI has to offer, click here. 

What is the ‘meal delivery’ model for Power BI?

The ‘meal delivery’ model is an analogy for Power BI data insight in NHS systems, stemming from a challenge of making data insight (food) available to a range of different NHS users (eaters). In this context, there are a range of preferences and capabilities among Power BI users and audiences to consider. Therefore, data architecture must enable the experiences and nuances within them, catering to the specific needs of various users: 

  • Analysts: These users will need direct portal access to usable data building blocks and analytics tools. With the ‘meal delivery’ model in mind, these users will need to select quality ingredients to make a meal for themselves.  
  • Executive users: These users need dashboard access to pull reports from selected datasets. They will want the ingredients packaged and provided along with a basic recipe to make the meal in a way that best suits their individual needs.  
  • Report consumers: Finally, these users will need Power BI reports sent direct to their inbox or accessible from Teams. They will want the meal delivered to them, ready to eat. 

The people and tools that make it happen

Using all the insights that have been discovered, a plan can be created to maximise Power BI benefits and meet all identified requirements, goals and constraints. The development process and method will determine the pace of the Power BI implementation and the level of disruption to business as usual. It will also define a team’s size, roles, skills required and cost of resources. An Agile Scrum Project method can be utilised here to maximise developer and user collaboration and allow for continuous improvement across each sprint to incorporate change in a controlled way without derailing the project’s progress.  

With Power BI project delivery being split into two workstreams— one being data and infrastructure, the other reporting— this method offers the flexibility to continuously embed best practices and ensure data and infrastructure workstreams do not diverge.  

How CACI can help

Migrating to PowerBI enables NHS stakeholders to achieve new strategic goals and transform their analytical capabilities. CACI understands the value that migrating to PowerBI can bring, which is why we have developed our own set of best practices and key principles for PowerBI migrations within the NHS. We strive to deliver a seamless migration built on our extensive experience in NHS data and technology, prioritising stakeholder engagement, providing reliable reporting, secure data sharing and self-sufficient BI capabilities for data-driven decision-making.  

For more information or help with Power BI project planning, delivery or ongoing managed services, contact us today. To learn more about how you can tap into the power of Power BI, our whitepaper outlines the best practices and methodology that will boost your understanding and usage. 

In the upcoming and final blog in this series, we’ll investigate new practices to be embedded and how to empower your users to ensure a successful handover. 

Read our previous blog in the series ‘Uncovering the power of Power BI: discovery & delivery framework’ here

Uncovering the power of Power BI: discovery & delivery framework

Uncovering the power of Power BI: discovery & delivery framework

NHS organisations that pursue data transformation will achieve substantial changes in their data-driven decision-making that ultimately improves efficiency, quality and patient experience. Power BI is an optimal contender for NHS organisations seeking a complete data transformation. However, achieving this and reaping its many benefits requires a carefully planned migration process, necessitating a partnership with a reliable data partner that possesses innate experience.  

Having worked with many NHS organisations over the years to plan and implement data migrations, this three-part blog series is developed from the principles of our Power BI migration methodology and real-world experience of NHS data projects, sharing key questions you should consider asking and areas to address to ensure a successful migration to Power BI. 

As such, the series begins with understanding the value of thorough discovery and how to build a successful project delivery framework. To read our full whitepaper that outlines additional methodology and best practices to unlock all that Power BI has to offer, click here. 

The value of thorough discovery

Unearthing all the information that will influence and affect your migration is a vital—albeit lengthy— first step. Skimping on discovery can compromise the solution’s effectiveness. 

Stakeholder mapping and collaboration

Stakeholder mapping and collaboration can make a significant impact to help define migration goals, as it will unearth possible issues and harvest key requirements to define migrations goals. Workshops with key stakeholders can aid this process, helping establish users’ needs and gauging their use of the Power BI platform. 

Conduct a current state analysis

Reviewing current data architecture, data processing locations and transformation methods will help you intrinsically understand stored data and information flows. During this review, inefficiencies within the operating landscape where your new solution will be situated can be identified and a solid foundation for new data architecture objectives can be built and defined. 

Building the project delivery framework

Building a successful project delivery framework will begin with defining features and functionalities required, including visualisations, connectivity, AI functions, data modelling and relationships between datasets. Ensuring you have a single version of the truth that is built on high quality data will also be critical. Reporting and analysis must also be transparent, enabling users and auditors to visualise how figures are produced. To facilitate this, solutions and configurations by audience type should be proposed to ensure users’ needs and Power BI access requirements will be met. 

Furthermore, developing a full target data architecture and identifying software/licensing requirements based on an assessment of your current analytics development process and available resources will be an integral part of the development of this framework. Availability will also need to be considered, as will security across all apps, including different access levels and permissions. 

How CACI can help

Migrating to PowerBI enables NHS stakeholders to achieve new strategic goals and transform their analytical capabilities. CACI understands the value that migrating to PowerBI can bring, which is why we have developed our own set of best practices and key principles for PowerBI migrations within the NHS. We strive to deliver a seamless migration built on our extensive experience in NHS data and technology, prioritising stakeholder engagement, providing reliable reporting, secure data sharing and self-sufficient BI capabilities for data-driven decision-making. 

For more information or help with Power BI project planning, delivery or ongoing managed services, contact us today. To learn more about how you can tap into the power of Power BI, our whitepaper outlines the best practices and methodology that will boost your understanding and usage. 

Stay tuned for the next blog in this series, where we’ll explain the ‘meal delivery model’ and the teams and tools that activate it. 

Insights from the Northumbrian Water Innovation Festival 2024

Insights from the Northumbrian Water Innovation Festival 2024

Attending the Northumbrian Water Innovation Festival last month was a very informative experience for our CACI Mood team, filled with insightful discussions and ground-breaking innovations. Held at Newcastle Racecourse, the festival brought together 3,000 people from 32 countries, creating a vibrant and diverse atmosphere. As a proud sponsor, we had the opportunity to support this great event and showcase Mood’s innovation capabilities at our exhibition stand. 

An Inspiring Setting for Innovation 

From the outset of the event, it was clear that this was not just another industry conference; it was an opportunity to break down barriers, open dialogue, and explore new ideas in a completely different context.  

The festival’s structure, which included a record 37 sprints, facilitated rapid problem-solving and idea generation. These sprints were filled with thought-provoking discussions, and we were lucky to hear insights from the likes of British Olympians Steve Cram CBE and Ellie Simmonds, who shared valuable perspectives. 

Specific Innovations and Collaborative Approaches 

One of the most striking aspects of the festival was the diversity of participants, which included suppliers like us, industry veterans, and aspiring professionals. This diversity enriched every discussion with fresh insights and novel approaches, underscoring the value of varied viewpoints in problem-solving.  

Notable innovations included solutions for improving water quality, achieving net zero emissions, and reducing pollution and leakage. A particularly impactful sprint, led by data-giant Cognizant, focused on leveraging AI technology to enhance the health of local rivers. 

Overcoming Business Challenges 

The festival also highlighted the importance of overcoming challenges through collaboration. The structured yet flexible format of the workshops, including design sprints and daily dashes, ensured that participants remained focused and productive. These sessions were expertly guided by sprint leads, facilitating a collaborative environment where participants could step out of their usual roles and approach problems from different angles. 

Personal and Professional Insights 

Engaging with a diverse group in a non-work environment allowed me to gain new perspectives on the challenges facing our water sector clients. It was refreshing to address issues in a setting where creativity was encouraged, and there were no predefined expectations about the “right” way to approach a problem. Professionally, the festival highlighted the importance of stepping outside our usual routines to generate actionable ideas. 

The Value of Participation 

Participating in the festival was more than just a productive use of time; it was an investment in the future of our water industry. The insights gained and connections made will undoubtedly contribute to more effective and innovative solutions for our clients.  

The festival demonstrated that breaking away from conventional settings and embracing a more open and creative approach can lead to endless possibilities. 

Looking Forward 

Moving forward from the festival, we hope apply elements of it to foster a more open and creative environment in our meetings and workshops. Encouraging diverse participation and thinking outside the box will continue to drive innovation in our projects and add value for our clients.

The Innovation Festival was a remarkable experience that highlighted the power of creativity, diversity, and open collaboration. I am eagerly looking forward to seeing the outcomes of this festival and am confident they will drive positive change in the water sector and beyond.

For more details on the festival, visit www.innovationfestival.org. 

Discover the power of Mood here.

What is InView? 

What is InView? 

InView is CACI’s data platform that is specifically designed for the NHS. It is modular by design with over 30 modules out of the box, and makes data sharing for ICS simple and efficient through its standardisation and safety in data management. The flexibility, maintenance and content provided by a standard data platform built in-house can only go so far. Considering the many pressures faced by NHS Trusts daily, they need a data platform that supports—rather than hinders– them.  

InView empowers NHS Trusts nationwide to enhance their reporting and unlock the potential of their data by ensuring that all data reporting is correct, consistent and complete within a singular integrated solution that will transform patient care outcomes. 

But how exactly does InView work? And what makes it so beneficial for the NHS? This blog will dive into everything you need to know about InView so you can make informed decisions about your own data platform. 

How does InView work? 

To meet the high volume of mandated statutory changes and local reporting requirements, your Trust should be equipped with a solid data platform that is easy to use and fully maintained. InView is risk-free*, robust and easily maintained, ensuring that you and your Trust can meet these requirements by providing all key statutory outputs and fully maintaining them in line with NHS change notifications as part of core product releases.  

Designed and built in a way that promotes rapid implementation of a solution within a Trust, InView secures you with plenty of pre-built content from all disparate data sources in one unified, trustworthy solution. Each of InView’s 30 modules is built from a sophisticated, layered design that will keep future maintenance costs down and future proofing up. Its layers include: 

  • Acquisition Layer: This layer accepts the data from incoming data sources and is designed to accept data in a raw format prior to any data checking.  
  • Integration Layer: As the middle ground between the Acquisition layer and the upcoming Translation layer, this layer moves data from one source to the other and performs matching between data sources. Trust-specific business rules are implemented and dictate how incoming data affects the information stored in the data warehouse.  
  • Translation Area: Data quality and integrity checking are carried out during this layer. This part of the processing also restructures data into a “star schema” model.  
  • Data Model: The aforementioned “star-schema” model is created at this layer, which is optimised for ad-hoc querying and historical data storage. It supports the historical storage of fact data, manages changes to dimensional data and hierarchical structures and ensures historical reporting is conducted effectively.
  • Serving Layer: This layer interacts with the InView user graphical user interface (GUI) to simplify configuration. Database views can be created at this layer to support reporting with minimal effort required from the end user. Real time data can also be presented at this layer, and non-InView data can also be combined to supplement any data you need to report on. 
  • Compliance Layer: This layer is where all statutory outputs are maintained and released to the Trust. 

Where can InView be deployed? 

InView can be deployed either on premise, in the Cloud, or hosted in CACI’s HSCN environment. Once deployed, our highly skilled technical experts forming the Managed Services team will work alongside you to ensure that you and your Trust are constantly supported after InView goes live. We will support you throughout the entire project implementation through fully transferring the necessary skills that will help you and your Trust feel more self-sufficient when using InView. 

Benefits of using InView 

NHS Trusts need accurate, reliable and readily available data for critical reporting and decision making. While this is crucial, it can be one of the biggest challenges for data professionals across the NHS to overcome. InView’s range of benefits can help you and your Trust overcome these challenges through its: 

  • Consistency: As a proven in-house solution that promotes a single version of the truth 
  • Availability: As a maintained product that can supply end-to-end reporting and can be implemented with all local rules correctly applied to incoming data
  • Efficiency: As a partner that is committed to continuously enhancing its solution
  • Flexibility: As an easy-to-use, extendable solution that is tailored to your Trust’s requirements and ensures your Trust will adapt to changes quickly 
  • Reliability: As a modern, interactive solution that allows for sharing not only within your organisation, but with ICS partners and NHSE too.  
  • Volume: As a solution that reduces the onus of statutory changes on the Trust 
  • Low cost of ownership: As a low total cost of ownership solution with maintained product content and changes that a Trust can action themselves. 

InView use cases 

InView produces a single, governed version of the truth that will drive consistent numbers that will enhance decision making, financial measurement, forecasting and information sharing across your Trust. By leveraging InView, you can present data for all purposes from one cohesive source to your Trust’s existing BI Toolset, which will simplify the reporting process and minimise the training needed for your Trust’s analysts.  

To get a sense of just how streamlined these processes within your Trust can be, take a look at some our of client case studies: 

CACI as your InView provider 

CACI has been providing Trusts with a solution that evolves and meets the demands of NHS reporting for over 20 years. Our very own data platform, InView, integrates all disparate source systems to optimise reporting across your Trust. By removing the statutory maintenance burden and time-consuming running of mandated reporting datasets, you and your Trust can focus on achieving priorities while meeting requirements and responding to any ad-hoc or urgent changes as they arise. To top it off, you will gain access to a user community for collaborative content and idea generation and learn how you can further enhance your own InView experience through other users’ takeaways. 

To learn more about InView and how our data warehouse solution could help your organisation, visit our InView page.  

*Risk-free for mandated statutory requirements 

How Synergy revitalised Dorset HealthCare’s costing team

How Synergy revitalised Dorset HealthCare’s costing team

Background:   

Dorset HealthCare University NHS Foundation Trust offers a range of mental health and physical health services to people of all ages from children to elderly. These services are delivered in both hospital and community-based settings.

The costing team at Dorset HealthCare has long used CACI’s patient-level costing solution, Synergy, to reach various goals due to its high-quality outputs and proven abilities in easing the National Cost Collection submission process. According to Chris Badminton, Head of Income & Costing at Dorset HealthCare University NHS Foundation Trust, “I couldn’t see how another provider could compare with its capabilities.” 

Challenge:   

As long-time Synergy users, Dorset HealthCare’s costing team knew that CACI’s patient level costing solution would help them navigate their most pressing challenges, such as: 

  • Acquiring the necessary patient level costing information that would inform decision-making about clinical care at Dorset HealthCare, which had been exceedingly difficult. 
  • The team was previously equipped with indecipherable data. It was input manually into spreadsheets and could not supply the necessary intelligence to overcome hurdles. “Without Synergy4, we’d never be able to generate outputs to support the challenges that we faced,” Chris explained. 
  • They struggled to get results out to stakeholders or present the results in a dashboard format that could be shared internally. 
  • Limited engagement from the necessary stakeholders became a blocker when trying to make the most of data and tools available to the costing team.  

Solution:  

Through Synergy, Dorset HealthCare has been overcoming challenges and revitalising their costing teams’ capabilities in several impactful ways. For example, consultancy and support from CACI in the form of a help desk has helped keep the costing team up-to-date and running smoothly.

“I access the helpdesk quite a bit. [The help desk] is always incredibly helpful and we always get the solutions and the answers that we desire,” Chris explained. “I also have regular customer care meetings and they’re really useful as well.” 

CACI’s Synergy User Group has also helped inform Dorset HealthCare’s clinical care planning and patient engagement strategisation through knowledge sharing opportunities with other NHS organisations.

“The Synergy User Group is also a great space for sharing and understanding how other [NHS Foundation Trusts’] challenges are being dealt with and for idea sharing,” Chris continued. “This has been really useful not only for the use of the product, but for understanding what the outputs need to be in order to get that engagement internally to support how we deliver clinical care at Dorset HealthCare.”

Synergy has also bolstered the costing team’s management abilities ahead of annual National Cost Collection (NCC) submissions.

“With regards to the National Cost Collection of the mandatory element of the functionality, that has far exceeded my expectations,” Chris continued. “The piece of work that’s been developed by [CACI] makes our management process on an annual basis incredibly easy.” 

Results / Benefits:   

Overall, the costing team’s evolution as a result of Synergy has been, as Chris stated, “over and above”.

“The speed of [Synergy] and the way that you can calculate and produce results is phenomenal… including its usability and how intuitive it is,” Chris continued. “It’s above what we would’ve expected.”  

Equipped with Synergy data, Dorset HealthCare’s costing team is now developing analysis to support decision making for their improved access to psychological therapies (IAPT) service. Currently, the data that Chris has presented back to the organisation through Synergy is being deciphered, and the costing team is finding ways to reiterate the analyses for other areas of the Trust.

“I think [this service] is going to become something that is rolled out across all services within our mental health function to enhance the care that an individual could receive,” Chris explained. “It’s on the cusp of becoming something big for good evidence that has been supported by Synergy.” 

Outcomes/Future:    

Going forward, Dorset HealthCare hope to receive a regular analysis that can be used across the organisation to guide the way that clinical care at Dorset Healthcare should be delivered and further improve patient outcomes. Not only would a regular analysis enhance patient experiences, but it would also encourage the costing team’s conscious, intelligent allocation and spending of funds. 

In the meantime, the costing team will continue focusing their efforts on health inequalities. They are currently looking into deprivation data, a process that involves manually exporting data from government and other websites to generate data that can be compared against or linked to existing patient level activity data used for Dorset HealthCare’s costing submissions and costing reports. The goal is that the costing team will eventually be able to use or link the data to compare results to other NHS organisations. This would help them better understand what a patient’s pathway looks like, the costs associated with specific types of care and how Dorset HealthCare can learn from other organisations to apply best practices to their own. 

 

How InView enhanced Stockport’s data collection & processing capabilities

How InView enhanced Stockport’s data collection & processing capabilities

Background:  

When Stockport NHS Foundation Trust first looked to procure a data warehouse, they were adamant about choosing a provider with a proven track record and experience of delivering products and services to the NHS. Following recommendations and success stories from other users of CACI’s NHS data warehouse solution, InView, it was clear that a partnership with CACI would guarantee Stockport a smooth process with a mature and established provider. 

Challenge:  

Stockport needed one platform that would contain all data in one place to simplify the collection process and help the team regain control of their data. Over the years, numerous reporting database tables evolved to the point that multiple individual servers were created. This resulted in many duplications with multiple databases across multiple tables, data not being consolidated or structured, analysts having to work across servers and inconsistent information being produced. Having one unified platform would ensure that everyone would pull data from the same source and would avoid analysts working in silos and creating their own new sources of data. A consolidated data platform would provide much needed resilience and structure. 

Stockport also wanted to take control of their statutory data processing and reporting. They needed flexibility and control over their own data developments, including more automated data submissions and reporting. 

Solution:

CACI’s InView equipped Stockport with a mature data platform that has defined all statutory returns and commissioning datasets. It supports the team’s existing grouping and pricing processes and significantly reduces their month end manual processing, freeing up their time to dedicate their efforts to additional data analysis instead.

Through InView, the team also gained access to a unique support desk headed by a team of CACI’s technical experts, ensuring that any issues arising at Stockport could be mitigated precisely and timely.

“You don’t normally get someone that could just as easily have developed the product on a support line. [Our CACI support lead] knows InView inside out… not only does he know the products, but he also knows NHS data quite well,” Rory MacDonald, Lead Analyst at Stockport, explained. 

“We have a lot of confidence in the fact that CACI’s [team of customer care individuals] understand NHS data and keep up to date on policy decisions to be able to respond quickly to changes,” Debbie Hope, Chief Data Officer at Stockport, continued.

Stockport was also able to identify gaps in the recording of patient observations, with a customised InView module specially developed by another one of CACI’s delivery support leads to enhance Stockport’s reporting capabilities. Through InView, the team could rest assured that all statutory elements would be addressed and that building any added functionalities within the platform would be done quickly and easily.  

The latest enhancement that CACI’s delivery support lead is developing for Stockport is for their audiology data extraction and collection, whereby data is extracted from their system and data quality reports are being created to find any issues. This helps Stockport streamline some of their diagnostic waiting times reporting.  

Results / Benefits:  

  • According to Rory, CACI’s consultancy and support has far exceeded the organisation’s expectations. “The consultants were all really good in terms of both their technical expertise and dynamic advice,” he commented. 
  • A noticeable reduction in the overall time spent processing overnight. After setting up a delta load, Stockport realised that every piece of information in their system dating back from the 1980s was being copied over. This process took progressively longer each day because the amount of data being copied over was continuously increasing. They worked with CACI on setting up a delta load where they could identify using interface messages, pull any necessary information and load it into the data warehouse, which significantly sped up the processing time.  
  • The availability of data. “It’s available to be reported on from early in the morning,” Rory explained. 
  • The enhanced data warehouse solution allowed Stockport to produce their own national CDS extracts. “We were reliant on and restricted to the pace of our PAS supplier previously for the development of those extracts when there were national changes,” Debbie explained. “We’ve removed that reliance and taken full control of those national extracts.” 
  • Moving away from manually processing commissioner assignment within the PAS system. “It was a very manual process for using the contracting functionality within our patient administration system to assign the Commissioner for who pays for a particular piece of activity,” Rory explained. “Now that we’ve got all the national commissioner assignment method (CAM) rules written in the data warehouse, we’ve been able to switch off the functionality on the PAS system and transform the work of our data quality team.”  

Outcomes/Future:   

Stockport’s future ambitions include completely switching off all of the old servers with the legacy reporting databases so that the organisation can have only one development server and one production server for the data warehouse. They are also keen to increase the provision of real-time reporting. CACI will continue to support Stockport by analysing patient flow and frequently refreshing in-patient data to help Stockport understand exactly who is in the hospital at that time, what service they may be waiting for and how waiting times can be reduced, and overall support with the maintenance of their data warehouse. 

Delivering data & insights to provide Bright Horizons with a new approach to childcare

Delivering data & insights to provide Bright Horizons with a new approach to childcare

Highlights

• Bespoke data dashboard and InSite tools
• Acorn geodemographic data for multiple propositions and locations
• Customer and employee profiling to assess community need
• Enabling demand-led growth for genuine customer value
• Rapid report generation to inform many stakeholders

About Bright Horizons

Trusted by families to look after their children for over 30 years, Bright Horizons is an award-winning nursery provider. The company operates over 300 community and workplace nurseries throughout the UK: each is individually designed to serve the needs of its community. Bright Horizons provides tailored childcare for corporate clients and for families, at home, at work and in local settings.

The Challenge

Bright Horizons initially approached CACI for data to support their new site opening and acquisition insight programme. Property Asset Manager Oliver Brookes needed reliable data that was quick and easy to interpret for new site and location decision-making.

Marketing Manager Eddie Thorogood saw a further opportunity to use demographic data to support Bright Horizons’ proposition development and to better understand existing as well as potential catchments.

The Solution

CACI provided Acorn demographics, profiling and mapping, giving insight into specific postcodes and communities. High level demographic maps are instantly visible in InSite’s Locator tool.
Eddie explains: “The blend of data creates reliable and up-to-date information about the demand for our services, to support decision-making about how and where we can expand our operations so we can deliver high quality childcare where it’s needed. It also helps us improve our business model, so we can manage our portfolio and flex and balance our sites to meet changing needs.”

The Benefits

Bright Horizons’ three pillars are ‘people, quality, growth’. Eddie emphasises, “We’re not about just growing for the sake of it. We always want to be where we are needed – where parents can find us and our services will be useful. With this data insight at local level, we can provide a clear picture of community and workplace need to our senior leadership team, so they can sign off new facilities.”

Eddie explains

We have a complex business where everything is audience-centric, so we have multiple offerings. It’s a deeply human business – it’s all about nurturing young children.
The CACI data and dashboard reporting gives us tools to look through every single lens, to understand all the factors that matter to people.

Eddie Thorogood, Marketing Manager, Bright Horizons

Find out more

Please view the full customer story here. If you want to learn more or have any questions please get in touch with us.

Why NHS costing systems can’t stand still

Why NHS costing systems can’t stand still

The NHS landscape is constantly evolving – it’s the responsibility of trusted solution partners to keep pace with NHS organisations and contribute expert data knowledge to help them on their journey 

Everyone’s talking about finance collaboration in the new Integrated Care System (ICS) structure, but it’s not easy for anyone to make headway in this unfamiliar landscape. It’s not as if the decks have been cleared to make time and space to understand and address the opportunity: NHS leaders and finance teams are still grappling with everyday pressures and priorities within their own Trust. ICS is another challenge to add, albeit one that offers excellent opportunities to improve patient care and experiences. 

Up to now, costing data has been used by NHS Trusts for national cost collection (NCC) and internal service line reporting. Solutions like CACI’s Synergy 4 help Trusts to make this happen in the most efficient and integrated way possible and to gain greater value from their data for service design and improvement. But now, there’s a new challenge level. How can Trusts also share and embrace costing data from other Trusts within their ICS?  

The rewards of understanding and analysing patient pathways across organisations 

In principle, it’s clear that a holistic approach to analysing patient pathways – spanning acute, mental health, ambulance and social care organisations and community settings – has the power to greatly improve patient outcomes and experiences as well as delivering better value and efficiency to ease the burden on NHS care teams. But the practical processes and channels for sharing data and insight are far from clear. 

CACI’s NHS engagement team has been working closely with our NHS clients to understand the complex considerations around sharing data between Trusts in a secure way that produces reliable and meaningful information that can help develop patient-centric services and make the most of NHS resources.  

Trusts are engaging with a range of new data challenges for ICS  

Information Governance (IG) for shared data is a key concern for NHS finance teams. Data must be anonymised, in order to protect patient confidentiality, but Trusts must be able to match patient identifiers to understand the end-to-end pathway through multiple touchpoints and organisations. 

Finance teams are also keen to understand more about the quality of data that could be shared by other Trusts. Data formats may be an issue: there are multiple systems and data sources in use, even within individual Trusts, which can make it hard to match data and adopt a holistic approach. With clinical decisions and budget allocation potentially riding on the analysis, it’s critically important that pooled data is accurate, de-duplicated and in comparable formats, to avoid inaccuracies. Reporting on insight from shared data can produce unfamiliar results in the broader ICS context: for NHS leaders to trust the integrity of the data and analysis, these results need to be clearly presented and explained. 

These are uncharted waters for NHS Trusts, for the new ICS organisations and for data solution partners like CACI. It’s not surprising that most efforts to launch costing data-sharing projects have so far been tentative. We’ve talked to finance managers who have shared data to explore the opportunity – generally they’ve done this in manual and fragmented ways, such as emailing manually created data files. This is clearly not a scalable approach for time-poor NHS finance teams, even if the attendant data protection and security issues could be resolved. 

 Operational finance teams can see the potential, but many are worried about IG, concerned about undermining their own Trust’s financial priorities within the ICS and don’t have the time or the mandate to focus on unpacking the issues. It’s already creating frustration. Some NHS leaders have a management accountancy background: they don’t yet have the data literacy training or experience to champion or direct a completely new costing data-sharing approach with confidence. This is a challenge we’ve also recognised: CACI’s Healthcare Insight Success Cycle (HISC) includes data literacy training modules which can help increase knowledge and confidence. 

Collaboration with solution partners can enable ICS collaboration 

How can NHS Trusts and ICS organisations break down these barriers and access the resources they need to unlock the potential of data-sharing? Partners like CACI can help to shoulder some of the load by ensuring that technology and data solutions are continually evolved and adapted to handle the emerging opportunities and challenges. Driven by the feedback and hands-on experience we gain from our NHS colleagues, we’re working on our Synergy proposition to develop the data-sharing, analytics and IG capabilities that will support the emerging ICS data-sharing requirement. 

We know that ICS organisations are at different stages of their thinking about Trusts. They also have diverse levels of capability, resources and experience in producing Trust-level service insight from costing data. Everyone has a different starting point for their new ICS data-sharing journey.  

How does your Trust’s approach and experience to date match up with our current understanding of the ICS landscape? At CACI, we’re highly aware that priorities, issues and opportunities are constantly evolving within the NHS. We’re rising to the challenge of delivering a costing proposition that’s built for the complex demands of today and tomorrow, supporting better outcomes for patients, better decision information for clinicians and better use of resources for the NHS. We want to support Trust finance and analytics teams by sharing our NHS data knowledge to help build data literacy among NHS leaders, so they can champion ICS from a position of understanding.   

That’s why we are working alongside our NHS colleagues, engaging with their current challenges and offering data strategy, process and capability insight to help them move forward on the journey, as we evolve our Synergy proposition.

Please join the conversation through our user groups and round tables or get in touch directly to share your priorities and issues and pose any questions that we could help you answer through our NHS data experience and expertise. Contact consultant Susan Brooks in CACI’s NHS team.

Integrated care systems – is your Trust maximising opportunities?

Integrated care systems – is your Trust maximising opportunities?

Since 2018, the NHS has seen Trusts building closer relationships with local councils and other important strategic partners such as the voluntary, community and social enterprise sector.

The 2021 NHS Long Term Plan cemented an integrated care system (ICS) that would build on lessons learned and invest in keeping people healthy, while setting future social care priorities.

The introduction of ICS throughout the NHS, along with the government’s new Health and Care Bill, brings health care under one umbrella, and highlights the importance of data sharing to enable joined up support across the NHS, local councils, and other partners.

ICS is helping change attitudes to data sharing and how data can be used to improve service provision. This presents a huge opportunity for NHS organisations to improve services and accelerate elective care activity. It enables better use of data by consolidating, managing and sharing it more efficiently and easily, resulting in better care through more easily pinpointing where problems or hurdles exist.

While Trusts will have a wealth of organisation and patient data, bringing it together to produce meaningful insight that can drive decision making and improvements, and access additional funding, is crucial.

Joining up health services

The Health and Care Bill changes how the NHS is structured and puts ICS on a statutory footing, enabling partnerships that better join up health and care service, improve the community’s health, and reduce health inequalities. Benchmarking across Trusts becomes possible, enabling more effective and consistent patient outcomes.

Each ICS is led by an Integrated Care Board (ICB), which will have responsibility for NHS functions and budgets across the ICS. The system sees 42 new ICBs replace Clinical Commissioning Groups (CCGs), with a change from 106 CCG geographic areas to 42 ICBs.

Currently, much of the work with data in the NHS focusses on delivering upon statutory requirements. But moving forward, data will also become a tool for planning and measuring, informing decision making for improvements to clinical practise and leveraging data to improve the cost of care and the patient experience.

Sharing information across Trusts enables benchmarking of services, while patient pathways remain the priority at all touchpoints. Technology can be used to leverage knowledge of the environment and constraints and provide a proactive view of activity. This will allow Trusts to have a much clearer view of the entire patient journey, and will be the start of the changing future of healthcare.

It will help ICS to look ahead at long-term population heath needs based on demographic data, and better understand future problems – enabling a next level of planning that may not previously have been considered.

The current state of integrated care systems

The NHS Confederation, which supports and speaks for the healthcare system in England, Wales and Northern Ireland, has carried out a review of ICS progress in 2021/22.

In the first of what will be annual reports into the evolution of ICS, it highlights what is working well and where it feels improvements are needed. These include:

  1.  ICS leaders may not have sufficient time and space to deliver the radical changes needed.
  2.  ICSs should make decisions at the most local level possible and be empowered to define what metrics they will be assessed on based on local priorities.
  3.  One of the biggest strengths of ICS so far has been improving joint working between partner organisations. Around 90% of system leaders believe they have been able to effectively improve joint working.
  4.  System leaders are committed to the principle of subsidiarity and 90% say this principle already applies to their system.
  5.  Another strength of ICS has been local workforces. ICS leaders feel they are making significant contributions to mitigate workforce pressures and improve working culture, with nearly 80% confident to deliver a ‘one workforce’ approach by July 2022.
  6.  More support is needed to help systems contribute to local social and economic development.
  7.  There is uncertainty about how the experiences and insights of leading primary care services at neighbourhood level inform system-level planning and strategy.
  8.  The biggest obstacle to further progress is national workforce shortages. The NHS Confederation is seeking amendments to the health and care bill to strengthen the duties of the Secretary of State for workforce planning, and has asked the government to develop and publish a health and care workforce strategy as a priority.

Taking the next steps forward

Data insight is crucial to help Trusts improve patient outcomes and drive cost savings. But finding the best approach to accessing the right funding and realising your digital strategy presents its own challenges.

CACI’s NHS services portfolio demonstrates our ability to support data projects at any stage of the data lifecycle, helping Trusts determine local priorities, accelerate timelines, maximise staff resources, improve joint working, and plan strategically for the future. And we combine all this with our wide experience of healthcare customers.

Data can become the building blocks of your solutions, showing you where services are at capacity, how to redesign them to avoid bottlenecks, and how to meet challenges and maximise opportunities.

Plan a call with one of our NHS experts today and take the first step towards optimising your organisation’s data provision. 

Read our latest blog ‘Challenges facing NHS Trusts – and how to tackle them’.

And for more expert insight, download our essential whitepaper – Elective Care, how NHS changes are bringing opportunities for Trusts and patient care.