Ekta Mehta, Author at CACI

Nottingham City Council to use ChildView from CACI to support its youth justice work

Posted on: 5 October 2022

“We’re looking forward to getting started with ChildView and realising the benefits that it will bring for our service and the young people who we support,” says Simon Newling-Ward, service manager at Nottingham City Council Youth Justice Service. “We need a system that will support every aspect of our work. ChildView ticks this box and further enables us to share data seamlessly and fully with other youth justice teams. With young people often moving around, it is vital that we can receive accurate and complete data on them when they come under our auspices. At the same time, it’s equally important for us to be able to share the information that we have built on a young person’s journey if they move to another local authority, in order that they can continue to receive the best support possible.”

“We are delighted that Nottingham City Council has chosen to utilise ChildView across its youth justice service,” says Phil Lucy, director, CACI’s Children and Young Persons’ team. “Working with a majority of youth justice services operating in England and Wales and their major cities, I feel that our team can support Nottingham City Council’s team and we’re excited to do just that.”

The contract was awarded to CACI via the G Cloud framework.

How North Somerset Council has taken advantage of E Forms in ChildView

Posted on:

North Somerset Council has been using ChildView from CACI since 2013. As part of its drive to derive more benefit from the system, the council started using ChildView’s E Forms functionality in 2022. Designed to give ChildView customers more flexibility in creating, linking and designing reports, E Forms enables councils and those tasked with improving outcomes for vulnerable young people to gain more insight into their work. What works? What doesn’t? Building up a database around youth justice work enables councils like North Somerset to gain deeper insight and understanding of their work.

“We made the decision to purchase the E forms module following the recent demonstration of its functionality to us by CACI,” says Nicola O’Driscoll, principle business intelligence lead at North Somerset Council. “The additional functionality gives us the ability to create and add our own forms and assessments allowing North Somerset to report at a more granular level. As a result, this will aid effective targeting of resources, give greater management oversight, providing real depth and breadth of those risk and safeguarding factors that affect the children and young people we work with.”

Being more agile with the creation of forms and reporting enables youth justice workers to define the data that they need, not just work with pre-defined data capture fields. This helps teams to research into and report on areas of their work in a more flexible manner.

Getting started with ChildView’s E Forms module was easy for North Somerset.

“In terms of the training the group experience was very diverse, from being highly experienced with the application to being novices,” explains Nicola. “All participants were able to follow the training and the feedback I have been given was; “this was one of the best training sessions I have ever attended. The instructor was really clear and engaging and was able to answer every question. It was a really positive, inclusive experience. Following training there has been an incredibly high level of enthusiasm from everybody to get stuck in. Huge thanks to Carol, who was fantastic.”

The benefits of E Forms in ChildView

Create your own forms tailored to your bespoke process
Link forms together
Locally designed forms that can be reported on
Printable versions of each form

For more information on ChildView, please visit: https://www.caci.co.uk/software/childview/

Integrated care systems – is your Trust maximising opportunities?

Posted on: 21 September 2022

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:

ICS leaders may not have sufficient time and space to deliver the radical changes needed.
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.
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.
System leaders are committed to the principle of subsidiarity and 90% say this principle already applies to their system.
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.
More support is needed to help systems contribute to local social and economic development.
There is uncertainty about how the experiences and insights of leading primary care services at neighbourhood level inform system-level planning and strategy.
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.

Challenges facing NHS Trusts – and how to tackle them

Posted on: 1 September 2022

Delivering better patient outcomes and value, while meeting targets and anticipating future needs, can be a challenge for NHS teams. There is constant pressure to do more with less, and with a high demand for service, quality is under intense scrutiny.

Even before the pandemic, waiting lists for elective treatment were growing. But by the end of 2021, 6.07 million patients were on waiting lists – the largest number since records began. As of September 2021, there were between 7.6 million and 9.1 million missing referrals of patients for elective care, and between 240,000 and 740,000 missing urgent referrals for suspected cancer.

“People will face serious health consequences as a result of delays in treatment, with some dying earlier than they otherwise would, and many living with pain or discomfort for longer than they otherwise would,” stated a March 2022 House of Commons report.

Tackling elective care challenges

The government expects the NHS to deliver around 30% more elective activity by 2024/25 than it was before the pandemic and has allocated £13.9bn in additional funding to tackle the elective backlog.

NHS Trusts are now exploring how they can access support to meet their targets, improve the patient experience and bring down waiting times. Digitisation is being seen by many as the silver bullet that will help solve their problems.

Over the past 20 years, elective care performance has been measured primarily through wait time targets, but changes to how the NHS monitors performance has seen the advent of new activity-based targets. The pandemic enabled a level of digital transformation that might otherwise have taken several years, and Trusts are looking to capitalise on this to deliver on these activity-based outcomes.

The Elective Care Recovery Fund is a £1bn pot of government money helping the NHS get back up to speed, and to aid different healthcare systems in working closer and more collaboratively.

Funding is awarded based on performance (i.e. increases in activity such as appointments or procedures). In order to utilise the funding, Trusts need to understand where there are opportunities to increase activity, make changes to create these increases, and be able to evidence them.

Data analytics can enable them to do this through forecasting, hypothesis testing and real-time analysis of wait times and patient journeys. Any activity above 95% of 2019/20 levels is reimbursed at 120% of tariff.

Digitisation of NHS services

Remote appointments are one key element of the patient journey where savings can be made. NHS England aims for up to a third of face-to-face outpatient appointments to be avoided by 2024 – saving £1.1bn and 30 million hospital visits.

In Norwich, a virtual ward launched in 2021 has saved nearly 2,000 bed days. The ‘ward’ enables patients to receive remote care from their own homes, with up to 20 patients a day being treated. Vitals such as temperature, blood pressure and oxygen are monitored via a strap around their arm and staff carry out virtual rounds through daily phone or video calls.

More than 80% of integrated care systems (ICS) now have a digitally-supported virtual ward, and these innovative forms of patient care are demonstrating how digital technology and data systems can enable Trusts to release capacity and deliver more efficient services.

Helping Trusts invest and utilise funding

Finding a different way through the pathways and exploring where the bottlenecks are and where there is capacity in the systems, is another crucial step forward, as is access to funding.

In April 2022, a new NHS payments system was introduced that enables an agreed local plan to be put in place between ICS members, targeting volume and case mix. A provider can earn a higher tariff for activity that exceeds the levels in the plan and for scoring highly on their CQUIN indicators.

Data insight is crucial to help NHS organisations plan, operate and continually optimise resources, services, and staffing – ensuring better theatre utilisation, staff rostering, waiting list reduction, capacity planning and operational management.

Advanced data analytics also enables NHS organisations to access the right available funding to help with a holistic recovery. Optimising data enables Trusts to explore opportunities, evidence these, and show changes being made – helping Trusts plug gaps and improve the patient outcome.

Next steps for Trusts

To meet the challenges currently facing the NHS, Trusts should be considering how to augment and optimise their data capabilities. A key step is to access and consolidate data from a variety of sources to inform deep and actionable insight about patients, services, and demand.

NHS Trusts will all be at different stages of their digital journey, but any additional funding they can optimise will be crucial. To do so they will need to understand where there are opportunities to increase activity, how to make changes to create these increases, and be able to evidence them.

CACI’s solution can help Trusts get the best outcome from the new NHS payment system and additional funding, and deliver the outcomes you need. We’re proud of our long-standing relationships with many NHS organisations across all care settings. We have hands-on experience of the pressures and opportunities facing your NHS organisation and the need for trustworthy information to support transformation and sustainability. Plan a call with one of our NHS experts today and take the first step towards optimising your organisation’s data provision. Visit our website.

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

The difference between reporting and insight

Posted on: 17 August 2022

Data is no use to NHS organisations without the expertise and tools to make it actionable

Data has become more and more significant in all industries and settings. The NHS is no exception. With a huge amount of patient, service and performance data at its disposal, there should be a wealth of insight available to help shape patient care and develop the best services in every community.

But there’s a very important caveat. Everyone knows that raw data doesn’t provide actionable information. That’s why it’s generally issued in the form of reports. But what do the reports tell you?

Reporting on data is not the same as generating meaningful and transformative insight from it.

It’s common for NHS organisations to produce reports that list statistics and objects without the context or perspective that could give them meaning as a basis for decisions. These reports can tell us what has happened and provide headline figures for costs, volumes and timeframes, but they don’t reveal insight.

Drawing insight from data means looking at it through a new lens. It could mean evaluating how past performance could influence future behaviours and decisions. It could mean modelling multiple hypothetical scenarios to decide the best approach from several options.

Data reporting is a valid exercise when you’re monitoring performance against fixed objectives. But it’s generally a historical, static activity. The data insight that NHS organisations need is about planning for the future and adjusting programmes in-flight to reflect the latest information and evolving patient needs. It’s about scenario modelling. It’s about bringing together different datasets, to gain more and more detailed and specific understanding of the causes of outcomes and what influences them. This kind of data insight is truly transformative because it allows NHS organisations to continually scrutinise, optimise and innovate in their services and care.

The impact of true insight on NHS services

Sarah Culkin, Interim Head of the Analytics Unit at NHSX, and Sukhmeet Panesar, Deputy Director within NHS England and NHS Improvement’s Data, Analysis and Intelligence Service describe the impact of data insight: “Knowledge is power. In healthcare, it is often life-saving. The NHS generates a huge amount of data which can be analysed and used to drive improvements in care and how services are run. Ultimately, data analysis results in improved patient outcomes and experience, as well as optimal use of NHS resources.”

Trusts and NHS service providers know that data is valuable. Many have already invested in data solutions and tools designed to store and analyse information. But not all are generating powerful and potentially life-saving insight. Digital insight for healthcare is a constantly evolving field, with new tools and technologies emerging to extract more relevant information. It can be hard to keep pace with the range of data resources on offer and to know how to prioritise system development and investment.

Acquiring and acting on insight demands data literacy in teams

Sarah Culkin and Sukhmeet Panesar highlight another key issue that affects many NHS organisations in their quest to use data to improve services: “In general, the NHS is failing to make the most of its data because there are not enough people with the right analytical skills to make sense of the information being collected.”

Data insight and analytics is a fast-evolving field. Without training, mentoring and support from specialists who understand the NHS environment as well as the potential of data, NHS managers and analysts cannot make informed decisions and harness the data they have to best effect. Education and skills are key – both for general data literacy in NHS clinical, management, operations and finance teams, and for analytics and technology in the data science teams who support them.

With all the data you collect, are you making the most of it to support crucial trust or service decisions and to deliver responsive, patient-centric care that meets real-time needs?

If you’d like to find out more about CACI’s Data Maturity Assessment service, or our data and analytics training, please get in touch. It’s all part of our HISC (Healthcare Insight Success Cycle) data optimisation approach for NHS organisations. Find out more by downloading our brochure Spearheading your data journey to improve patient outcomes.

Is knowledge and skills a barriers to transformative insight for your NHS organisation? Working with a specialist NHS data transformation partner could help you achieve best value from your data and budgets.

Find out how CACI’s healthcare team can provide advice on developing and maintaining your technology and offer staff training for data literacy and skills, so you can sustain your data journey from within. For further information, visit or website or get in touch with our NHS client team.

Managing patient data to guide you in the new ICS landscape

Posted on: 1 August 2022

How NHS organisations can prepare to access and contribute to a powerful pool of insight that will help them meet local needs better than ever before

When the new ICS framework rolls out, predicted for summer 2022, it should enable healthcare providers and bodies across the NHS to collaborate better than ever before, with a shared goal of providing improved patient care across the board. By moving away from fragmentation and competition, NHS services should be able to consider patient needs and pathways holistically and offer the best locally targeted overall care from a range of specialisms and organisations in a more coordinated and efficient way.

We have a real opportunity with the formation of the ICSs to change how we use data to better coordinate care and re-design our service based on the needs of our citizens… It’s a really exciting time to work in the NHS.
Ayub Bhayat, Director of insight and data platform at NHS England and NHS Improvement

NHS leaders and healthcare teams are excited about the opportunity to smash silos and break through frustrating organisational barriers to work more effectively together in this new, collaborative culture. But they’ll need the right information and tools for shared decision-making. That means bringing together data that was formerly held separately and unleashing its full potential as part of a comprehensive system of healthcare insight.

What should NHS organisations do to make sure they’re playing their part and will have access to the data and analytics they need to deliver excellent outcomes as part of their ICS?

Trusts and healthcare bodies will need to be certain they can share data securely and effectively. They’ll need systems that can bring together disparate data in actionable formats, so it can be compared and analysed at patient and pathway level. They’ll need reporting tools and dashboards that reveal insight to underpin operational and investment decisions, as well as to track the success of initiatives. They’ll need to continuously augment data, so planning and collaboration keep pace with real-time community and service needs.

Every ICS will have its own priorities, reflecting what the local community needs in terms of NHS care across the board. Different data and analysis will be needed to plan the best collaborative service provision in every area.

The overall vision is exciting, but to achieve it, organisations must identify practical steps to move from where they are today with their own data to the collaborative ICS data ecosystem. There’s an opportunity to exploit new and proven technology that manages and harnesses data to produce advanced, relevant and detailed insight.

We recommend a systematic approach to assessing where your organisation currently stands and how you can evolve your data strategy to achieve the best outcomes in an ICS. In CACI’s digital healthcare knowledge model HISC (Healthcare Insight Success Cycle), we’ve developed Discovery tools and processes that help NHS organisations do exactly that:

Describe and assess your current data strategy, systems and approach
Define your future data direction and destination as part of an ICS
Review your data security, storage and infrastructure
Build a strategy and roadmap for data insight that will improve clinical and operational delivery and performance in the ICS framework
Build a business case to connect investment in insight with tangible outcomes

CEO of NHS Confederation Matthew Taylor said in March 2022 that the use of high quality, real-time population health data will help “to shift from a system that responds to demand to a system that genuinely responds to need”, and that the NHS’ implementation of Integrated Care Systems (ICS) has the potential to “help create that enabling environment” needed to leverage data effectively.

Ruth Holland, deputy chief information officer at Imperial College Healthcare NHS Trust, went even further: “ICS’ will stand and fall on their data capability in ten years’ time. I would sternly encourage digital and data leaders to look at the costings you are putting into plans [for staff and skills] that will support the ambition.”

CACI’s specialist healthcare technology team has the experience and knowledge to support your organisation with planning and delivering an ICS data transformation programme, including training and skills transfer for your staff.

If you’d like to find out more about CACI’s HISC model for optimising NHS healthcare data, download our brochure Spearheading your data journey to improve patient outcomes. It describes in more detail how you can take action to activate data insight to reshape health and social care in an ICS.

To find out more visit our website or speak to an NHS data consultant about the results we’ve helped other organisations achieve, please get in touch with our NHS client team.

Reshaping health and social care with data insight

Posted on: 14 July 2022

How data can help you improve patient outcomes in 7 priority areas

There’s constant pressure on NHS organisations to deliver better patient outcomes and value from public funding. Demand is high and service quality is under intense scrutiny.

NHS organisations have access to a wealth of organisational and patient data. But bringing it together to produce meaningful and trusted insight is a challenge. Decision-makers and clinicians must have access to analytics and reporting in clear formats. Data insight needs to be current and available in a timely manner. Data storage and usage must also be secure and compliant, to meet NHS and national standards for patient and citizen confidentiality.

Everyone’s talking about the fact that data insight is crucial to help your NHS organisation plan, operate and continually optimise resources, services, staffing and patient experiences. But what does that mean in practice? How do you unlock the insight to make a difference today? Amongst all the competing priorities for NHS managers, how specifically can data insight change the way your organisation operates, improve patient outcomes and tackle challenges like waiting lists and staff shortages?

Working with NHS Trusts and social care organisations, we’ve seen at first hand the difference that well managed data can make to efficiency and patient care. Actionable insight to influence real-time and future service design and planning is the holy grail for driving real value from your data to help improve the performance of your NHS organisation.

But to make it happen, where do you start? How can you achieve rapid and meaningful impact from an investment of time and budget in a data project?

We’ve identified seven high value activities that our NHS customers and partners have successfully optimised using data insight. By quantifying the benefits of one or more of these outcomes for your organisation, the case for prioritising your data project becomes clearer and easier to communicate with colleagues and stakeholders.

7 priority activities that NHS organisations can drive with data

1. Model and predict demand for services

Complete and accurate data and effective analytics tools give you the power to model and predict demand for services based on specific evidence relating to your patients and community. Produce relevant reports that decision-makers can scrutinise and understand with ease, so they can support your recommendations readily.

2. Put the right staff in the right place at the right time

Effective and accurate data about demand for services and availability of staff can help you roster more effectively – reducing wait times and giving patients better experiences in your clinical organisation. This has particular value when dealing with increased absence relating to Covid.

3. Review and respond immediately to current patient needs

If you have the capability to analyse patient data in real time, you can give clinicians the information they need to make fully informed decisions in the moment about care and treatment, to achieve the best patient outcomes.

4. Plan services effectively for better patient outcomes in critical areas

With a specialist NHS data platform like CACI’s InView, you can apply powerful analytics to dive deep into data and answer the most important questions for your organisation. Drive improved patient outcomes by tackling priority KPIs for your organisation – from waiting list monitoring, patient level costing and clinic usage to theatre utilisation and clinician availability.

5. Focus on frequent flyers

With a clear picture of frequent flyer characteristics and visit patterns from comprehensive and up-to-date reporting, you can proactively identify patients who need more support or information and help them to access the most appropriate services and treatments for their needs.

6. Integrate data to build a complete picture of demand for services

When you bring together local government and hospital data in a single, integrated data platform, you can access even richer insight into patients, services and demand. With one source of analytics and reporting, you can maximise the value of the information your organisation holds, including collaborating with other Trusts through data sharing within an ICS ecosystem.

7. Understand your patients more thoroughly and personally

Compliant data records and effective reporting gives your NHS organisation a clear picture of the demographic backgrounds of your patients. By understanding their backgrounds and lifestyles, you can shape your services and communications for better access and improved outcomes.

Every NHS organisation is different, with priorities and challenges that are unique to its community and resources. No matter where you are on your data journey or how you most urgently need to uncover and apply insight to your decision-making and planning, a tailored data transformation strategy can help you move forward. The most practical and effective approach is to outline a series of steps on that journey, making sure that you drive value from your data project as early as possible by accessing insight that supports your most pressing tactical requirements.

If you’d like to find out more about how data helps you deliver tangible improvements in key areas of your NHS organisation’s patient care, download our brochure Spearheading your data journey to improve patient outcomes. It describes in more detail how you can take action to activate data insight to reshape health and social care. It explains how CACI’s Health Insight Success Cycle is specifically designed to drive maximum value from data for NHS organisations.

To find out more visit our website or speak to an NHS data consultant about the results we’ve helped other organisations achieve, please get in touch with our NHS client team.

Mid Yorkshire Hospitals NHS Trust

Posted on: 21 June 2022

Highlights

• Bringing together a disparate reporting estate
• Move from traditional QlikView to active intelligence with Qlik Sense
• Rich visualisations inform clinical and operational decisions
• User-friendly apps and time-saving report automation
• Expert healthcare-specific support from CACI Qlik Sense consultant

About Mid Yorkshire Hospitals NHS Trust

Mid Yorkshire Hospitals NHS Trust is a local Trust providing compassionate, expert care for over half a million people every year, in their homes, in the community and across three hospital sites at Pontefract, Dewsbury and Pinderfields.

The challenge: A fresh start with reporting

Long-time CACI QlikView customer Mid Yorkshire Hospitals NHS Trust was ready to harness the full power of digital business intelligence for insight to support a forward-looking, data hungry leadership team.

Two years’ focus on putting the foundations in place to provide the data capacity and capability meant the team was ready to address its reporting estate, which had been built in a piecemeal fashion throughout the preceding years.

Ian Vause, Head of Information, sums up the challenge: “We have a big reporting estate that uses a whole lot of technologies and sources – including SQL, Excel, and Word documents as well as Qlik View. The time had come to unpick all that and start afresh. We wanted to professionalise our information team and we needed a high-performing, BI tool with all the latest capabilities to support them.”

The solution: Flexible data and dashboards for quick access to information

The Trust’s information team had an excellent, long-standing relationship in place with CACI as the Qlik license provider. Regular account meetings had maintained confidence in CACI’s Qlik knowledge and expertise. Mid Yorkshire asked CACI to provide new licenses and work with the team to transition from QlikView to Qlik Sense.

Ian explains: “Our customers today are our operational management team, rather than clinicians, but that’s changing. We’re moving towards being focused on information for clinical decision-making, to create a healthier balance between service and operational managers and clinicians and clinical managers. We’re promoting self-service, so people can quickly and easily access the insight they need. The flexible data dashboards in Qlik Sense are vital for this.”

To enable a smooth transition, Mid Yorkshire is using dual licenses, while building up its reporting estate in Qlik Sense. Information Manager Luke Elmer says, “We’re up to 25 apps in Qlik Sense now – about a quarter of the way to our final state of migrating all our reports. We now have lots of people in the team who can design apps, load data, build and deploy the front end. We’re really starting to unlock the potential of what Qlik Sense can do.”

CACI is a trusted partner, offering second-line support, knowledge and guidance on Qlik as well as delivering an ongoing managed service for upgrades and maintenance. CACI’s Qlik for healthcare consultants have also delivered training and onboarding days for new starters.

The power of Qlik Sense

Qlik Sense is a modern cloud analytics platform that helps organisations close the gaps between data, insights and action with real-time, Active Intelligence. It brings data and analytics together seamlessly in an end-to-end, real-time analytics data pipeline. Organisations can free their data from silos. Users can easily find relevant data, enrich it and create derivative data. Qlik Sense empowers more people in the organisation to discover and understand insights, from anywhere with world-class analytics.

The benefits: User-friendly visual insight for operational and clinical decisions

According to Luke Elmer, “Users say that the ability to refresh reports in a timelier manner is really helpful. Before, refreshing any report weekly or monthly was time-consuming, because it generally needed various logins and manual data transfers. Now we have them set up in Qlik Sense, people have near real-time insight without all the preparation – some apps refresh constantly and automatically.”

Ease and efficiency are key benefits. “The speed of Qlik Sense transactions is a big move forward,” Luke confirms. “Some of our data tables have a million plus rows – you can’t do much in Excel with that. We can now refresh reports quickly and cut and slice the data effectively – that means we can extract more relevant and granular insight.”

Qlik Sense offers the Information Team and its Trust customers rich data visualisation capability. Ian says, “We work in conjunction with or customers to build apps that work for them and that they, as non-technology people, can use. The visualisation is a key aspect of the functionality. Historically we only had the most basic line and bar chart visualisations. We can drill through the data easily in these visualisations – it’s very powerful. For example, we can show process flows using Sankey charts. People really like the tree maps and the geographic maps, where we plot postcodes to show where patients are coming from.”

Luke adds, “It’s also much simpler to train people to produce these visualisations in Qlik Sense than in Excel – it has some of this kind of functionality now but nowhere near as much.”

CACI has a strong standing in the NHS. We choose to continue working with CACI because of our good relationship over many years – there’s trust and understanding there. The consultants are available and responsive to questions at any time and go out of their way to provide extra information or demonstrations when we need them. We’re very happy with the relationship management, response and support.
Ian Vause, Head of Information, Mid Yorkshire Hospitals NHS Trust

Cambridge and Peterborough NHS Foundation Trust

Posted on:

Highlights

• Specialist PLICS solution built for NHS Trusts
• Supports Critical Care Board operations
• Blended financial and patient insight for clinicians and managers
• User-friendly, intuitive dashboards for immediate visibility
• Expert, responsive training and valuable User Group support

About CPFT

CPFT is an NHS health and social care organisation that provides services in inpatient, community and primary care settings. The Trust’s services support adult mental health, older people and adults, and children, young people and families. Its biggest bases are the Cavell Centre in Peterborough and Fulbourn Hospital, Cambridge, but its 4,000 staff are based in more than 50 locations, supporting a population of nearly one million people

The challenge: Finding an intuitive PLICS solution to suit CPFT’s workstyle

With new PLICS regulations in force from 2020 for Mental Health, CPFT needed to update its systems to comply. The Trust was in the process of implementing a new e-patient record system, so requested a PLICS deadline extension to 2021, which was granted.

Michelle Barnes, CPFT’s Assistant Director of Finance, explains: “We knew that the regulation would soon be extended to its Community operations, so we decided to deploy a PLICS solution for both Mental Health and Community. We particularly wanted to find a system that felt intuitive to our team, so we could get the most value and efficiency from it.”

CPFT decided to replace its existing software outright, rather than upgrading it. The team selected CACI to integrate and implement our Synergy 4 patient level costing solution in a competitive process delivered through the NHS procurement framework.

The solution: Leading, specialist capability and supportive deployment

Michelle Barnes says, “We had demonstrations of four different systems. We particularly liked the logic of Synergy 4 – it matched how we approach things in our day-to-day work. For example, it uses familiar language and terms in allocations and apportionments. Other systems that we reviewed seemed either too basic or too convoluted.”

Finance Assistant Michelle Clarke adds, “We had been using Excel for a lot of our costings, which had its limitations. Some of the solutions we evaluated were still spreadsheet-based – we wanted to move away from this to a specialist system. We liked the way the outputs were presented and being able to customise the dashboards, so we could choose what we wanted to see.”

Once CPFT had selected the CACI solution, CACI’s trainers booked in working sessions to upload data and support the CPFT team to embed their financial model. CACI delivered training on the features and functions of the system, in context of CPFT’s particular approach, and provided a high-level reference guide.

Michelle Barnes says, “CACI made us feel confident that they were on our wavelength whenever we asked questions about the system.” Michelle Clarke agrees: “We worked with two different trainers, who were both really knowledgeable. They always understood what we needed – we felt the system was in our control from day one.”

The benefits: Secure PLICS reporting and accurate, relevant Trust-wise insight

Synergy 4 provides granular, detailed and accurate information that CPFT can use in an intuitive and collaborative way across the Trust. Michelle Clarke affirms: “Synergy 4 gives us a lot more flexibility with the dashboards – we can share the information with clinical managers and show them the fluctuations, in more detail. You can customise it for wards, teams and communities. Before we only had average contact and bed days – now we can have much more detail when we talk about what services cost.

“Before, we basically divided total costs by the number of patients to calculate patient-level costings. Now, we have so much more scope to be detailed and to layer financial information with demographics and population data. For example, we can apply postcodes and look at metrics like staff downtime and travel time for patients.”

Michelle Barnes adds, “When we move into Critical Care boards, we’ll have to split our contract into two, for north and south. The extra information we can extract from PLICS at GP practice level will really help us see how to split that contract.”

Peer advice and experience from the Synergy User Group

Both Michelle Clarke and Michelle Barnes agree that CACI’s Synergy User Group is an additional benefit that they’ve not experienced before. The User Group brings together NHS organisations from around the country in an online forum and for regular virtual meetings and clinics. This means the CPFT team can question other users with similar approaches and organisations and share their own best practice knowledge and tips. The User Group is led by CACI’s Synergy lead, who has a wealth of knowledge about how the solution works and how it can best deliver on Trusts’ priorities. Trusts can feed back to CACI about new functionality they’d like to see and upcoming requirements, so CACI can continue to evolve Synergy to anticipate and meet the latest needs.

Michelle Barnes says, “The User Group forum feels like it belongs to the Trusts – it’s not a sales update for CACI. It’s a chance to ask each other questions, as well as the CACI consultants. For example, peers might demo what they’re doing with reports – it’s a really good forum because it shows how people use the system in practice. It’s truly collaborative and interactive. Spin-off groups have emerged for different aspects, like the dashboards. And it’s so useful to be able to talk directly to other mental health and community trusts, because our needs can be different from acute trusts.”

It’s a strong relationship – we’ve had great support and interaction with everyone from the account manager to the trainers and helpdesk. We had a few IT issues, related to our firewall and making connections through it. CACI’s consultants were really responsive and came back to us very quickly to get this sorted. They were always progressing what they needed to and checking that things were satisfactorily resolved. The Synergy User Group is great – it helps us continue to explore and make the most of the solution, to deliver more decision insight and value for our Trust.”
Michelle Barnes, Assistant Director of Finance, CPFT

Torbay and South Devon NHS Foundation Trust

Posted on: 20 June 2022

Highlights

• One version of the truth instead of diverse standalone solutions
• Insight for decision-making, financial measurement and forecasting
• Local customisation to keep pace with change
• Fully maintained solution to reduce in-house IT burden
• Supports latest statutory reporting and ongoing change

About Torbay and South Devon NHS Foundation Trust

Torbay and South Devon NHS Foundation Trust provides acute health care services from Torbay Hospital, along with community health services and adult social care. It was the first Trust in England to integrate hospital and community care with social care.

The Trust has around 6,500 staff and 800 volunteers. It runs Torbay Hospital as well as five community hospitals and other local clinics. It provides health and social care to the local population, with around 500,000 face-to-face contacts in patients’ homes and communities each year, serving a resident population of approximately 286,000 people, plus about 100,000 holiday visitors at any one time in the summer season

I’d be happy to recommend this product to any other NHS Trust. InView gives us the flexibility to work around a stable core product — and the support from CACI is outstanding.
Stephen Judd, Informatics: Head of Data Engineering – Strategy and Improvement, Torbay and Devon NHS Foundation Trust

The challenge: Inadequate legacy systems and disparate, incomplete data

South Devon and Torbay has used InView for many years, with the original solution implemented in 2006. More recently, the Trust has experienced challenging times in its IT division, with tight budgets limiting staff and resources. This led to key systems becoming outdated, through lack of investment in upgrades and system replacements.

The resourceful IT team used workarounds and in-house development to bridge gaps and connect systems, to draw essential clinical and financial insight from the Trust’s data, stored in disparate sources.

Head of Data Engineering Stephen Judd says, “On top of this, since Covid, there have been big organisational changes in the Trust, including new wards, which affected the data we work with. And a lot of our lookup tables were based on old national standards. Although we had a made series of updates to the standards and data dictionary, our Patient Administration System (PAS) and InView hadn’t caught up.”

In 2020, Torbay and South Devon received funding to upgrade their SQL server and jumped at the chance. Stephen Judd says, “We knew we needed to upgrade the InView system as well and seized the opportunity to present a business case for this. It was accepted – but we needed to implement by the end of the financial year – less than four months away. Normally, we would have planned twice as long for this type of data warehouse project.”

The solution: A new, fully functional InView database and support to prepare and migrate

CACI agreed to work with Stephen and his team to deliver a new InView data warehouse against the tight deadline. Stephen explains, “CACI provided overall consultancy to plan the data warehouse migration. With many vacancies in our data team, we also used CACI consultants to backfill. Due to time and resource constraints, we didn’t have as much engagement with the information team and data team as we wanted. Moreover, some of our old source systems and extracts didn’t have an Information Asset Owner or anyone who understood the data architecture fully. We had to do a lot of interrogation analysis to bridge this knowledge gap. We wouldn’t have been able to deliver the project without CACI’s support with this.”

CACI’s consultants worked with Stephen’s team to implement the latest version of the InView data warehouse for healthcare organisations. It brings together feeds from in-patient, outpatient, critical care, the old maternity system, neo-natal and paediatric and some community and extended data (from InfoFlex) that adds richness and detail to patient records – for example, information from GP discharge letters.

Torbay and South Devon’s core project embraced the core data feeds they knew best. Stephen’s team set a stretch goal to bring some of the Trust’s community data in. This was particularly challenging, as it was poorly defined and spread over eight systems.

Stephen says, “Some of the services had started setting up their own booking systems outside our main PAS and using InfoFlex. Drawing on CACI’s expertise and resources, we were able to merge these in, which has made our data more complete and accurate again.”

To improve outputs and reporting, the team replaced a daily, fixed format export routine originally written in the 1980s. They built new feeds for demographic, inpatient and outpatient data from the SWIFT bed management system.

The benefits: Data best practice from a proven solution and trusted partner

Torbay and South Devon NHS Trust could have chosen to build its own custom solution. But InView has a powerful advantage. Stephen explains: “If we create anything bespoke, we have to support it. And we don’t have capacity.”

There has been a big shift because of Covid – the NHS is moving towards a more standardised national view of income. “InView means we can accommodate national SUS calculations and keep pace as our obligations increase each year, because it uses a recognised best practice approach. With InView, we have a proven, standard platform and can make local adjustments for a perfect fit to our organisation,” says Stephen.

For ongoing support, CACI’s team is responsible for upgrades and loading new tariffs. Stephen can focus his own engineers on getting the data right. This is key, because some of NHS England’s payment to the Trust relies on it. Stephen gives an example: “We discovered that a percentage of our outpatient activity had the wrong consultant speciality, which potentially reduces our national NHS income. With CACI maintaining InView, I have the resources to investigate and rectify that type of issue.”

“The beauty of working with CACI is that they take ownership of everything they promise in the scope of the agreement, and fix it. They provided excellent project management. I didn’t have to chase up work or check every detail – you can only do that with real trust in the team’s capability and judgement to escalate when needed.”

“The InView data warehouse is a product that will last us ten or more years – it’s our one source of data for all key reporting so it’s a critical solution for the Trust. Amongst the many programmes I’m responsible for, it was a relief not to have to worry about this one, because CACI has earned our trust and confidence throughout a long working relationship. CACI’s engineers are extremely experienced and were able to jump in, ask intelligent questions, and deal with unfamiliar and unusual data feeds and systems! The project manager provided excellent communication throughout, so I didn’t need to intervene and always knew the latest status and progress.”
Peter Sheard, IT Programme Manager, Torbay and South Devon NHS Foundation Trust