Res Consortium Changes the Conversation In Healthcare by Turning Heavy Reports into Performance Dashboards













Company Overview:

Res Consortium is a Management Consulting Organization built to improve performance of healthcare providers in the UK. By using Sisense as an embedded analytics solution as well as their own internal data analysis methodologies, Res Consortium delivers performance dashboards that allow customers to quickly and easily analyze and visualize big healthcare data. With three divisions that offer training and management skills, business systems such as Sisense, and a consultancy to interpret insights, Res Consortium is changing the way people approach healthcare performance.

Challenge:

Over the last 15 years, the National Healthcare Service (NHS) of the UK increased their spending from 70 billion British pounds to 150 billion British pounds. In order to improve their efficiency and cut costs, the NHS created dedicated internal organizations to measure the performance of organizations against each other, and to publish and distribute the data in performance reports.

The problem was, the healthcare data was very complex—big, scattered and siloed– limiting the reports to focus on one area of measurement or one organization per report, and were published as static PDF documents. Users were unable to compare to other organizations or integrate across different sets of data, giving them an isolated view of their performance. Data regarding each area, such as clinical performance, cost performance, and staff and patient surveys were reported in separate and heavy 50-page plus documents that required time and research to see a bigger picture across platform.

That’s where Res Consortium came in with the goal of providing performance dashboards that showed the data across the platform in an intuitive way. In the past Res Consortium was producing dashboards using Excel with protection keys to protect sensitive patient data, but they started looking for a BI platform that could move the dashboards to a web-based environment as well as to more efficiently and quickly handle the amount of complex data typical in healthcare. With a background in engineering, Mike Stedman, the Operations Director at Res Consortium, understood the value in visualizing all data in an interactive way so that organizations could not only measure their performance but understand problem areas:

Sisense Res Consortium Dashboard
Sisense Res Consortium Dashboard showing percentage of abuse from patients

“If you want to change behavior, you need to talk about why before how. We use data visualization with Sisense’s performance dashboards to allow users to drill down into problem areas and compare to other organizations and see the ‘why’—thereby changing the narrative. Then, people are inspired and able to seek ‘how’ others perform better.”

Mike Stedman, the Operations Director at Res Consortium

While organizations within the NHS are using Res Consortium to try and identify problems areas and improve efficiency, typical clients of Res Consortium are also pharmaceutical companies that are trying to access the NHS by building and visualizing a story around a particular disease, therapy or medicine they are interested in improving: “Sisense allows us to monetize the ability to make data into a greater narrative in order to commercialize it and tell a specific story,” explained Mike Stedman.

Solution:

After undergoing a Sisense evaluation, Res Consortium saw that Sisense would allow them to easily and quickly incorporate relevant public data, no matter how big or siloed, and mash it up with other data sets to create a useful, cross-organization dashboard.

For example, every year the NHS receives survey data from over 200,000 staff members. While the NHS provides a 60-page PDF document report with results, it is unengaging and has low readership. Res Consortium used the same data to create a Sisense dashboard that spanned over a number of years and that ranked over 8,000 practices and hospitals based on performance in over a dozen different areas with Sisense’s mapping function. Users can drill down into any hospital with such granularity, they are able to see various areas where performance is stronger or weaker and even choose a preferred hospital or practice based on the results.

res consortium sisense dashboard

“Sisense lets us take data and make it useful, dynamic and interesting. So, instead of just seeing their own data, users such as a Director of Workforce, can compare performance and can create benchmarks”

Mike Stedman, the Operations Director at Res Consortium

Another benefit of Sisense is how easy it is to share dashboards within an organization and how intuitive the dashboards are—allowing users to independently analyze and uncover insights. “Sisense is an engagement and diagnostic tool. We use it to engage people in our organization, understand what the challenges are, and quickly see why something has gone up or down without spending hours on research. Sisense makes data current, accessible, and dynamic, and we can get a dashboard up and running and published in no time,” said Mike. Though patient records are confidential, Res Consortium deploys a protective non-public facing server with anonymized patient information and uses Sisense data governance to manage users and viewers.

Res Consortium also uses Sisense to track and monitor the usage of the dashboards in their own systems. By using Sisense internally, Res Consortium can better understand and monetize their clients’ usage by measuring how frequently users are accessing dashboards.

Results:

Sisense allows healthcare companies to frame the debate by showing users what’s important to them, in an easy to understand way. Mike explains how easy it is to inspire change once relevant information is quantified and relatable. “With Sisense dashboards, we show the context of how others are doing compared to you and in which areas, and that inspires healthcare providers to want to know why and how,” said Mike.

The chief executive of Tees, Esk & Wear Valley NHS Trust started using Res Consortium’s dashboards as a mechanism to isolate challenges and highlight successes, which has served as a powerful springboard for discussing performance improvement with his board of directors. For example, this Tees, Esk & Wear Valley dashboard reveals that the organization is excelling in mostly all areas, except staff safety and abuse by patients and staff, allowing Tees, Esk & Wear Valley to identify and direct efforts on the problem area:

sisense dashboard res consortium GP performance

“The ability to use Sisense to see beyond the data to the underlying correlation and causality, where the strengths and weaknesses lie, is incredibly empowering—especially in the healthcare industry where we treat individual patients with varying personal needs.”

Mike Stedman, the Operations Director at Res Consortium

The most powerful example of a healthcare insight uncovered using Res Consortium occurred when a pharmaceutical company that specialized in Parkinson’s Disease approached Res Consortium. While Parkinson’s Disease is initially managed using oral tablets, as the disease progresses, patients experience rigidity and have trouble swallowing medication. It is only during those final years of care that doctors begin to prescribe patients medication in the form of patches or injections–which is significantly more expensive than oral tablets.

Yet, this particular pharmaceutical company wanted to prove that it was actually more cost effective to use the more expensive patches and injections earlier on in the disease, because the patient did not require as much hospitalization in the long run–benefiting both the patient and the healthcare system.

Res Consortium discovered this insight by analyzing hospitalization records and over 700 million lines of prescribing data in Sisense ElastiCube. “By using the fast speed Sisense ElastiCube we were able to drill down into data at the practice level, of over 8,000 practices, to see what doctors are prescribing and how much hospitalization their patients need,” Mike explained. After proving that the cost of one offsets the cost of another, their client is currently publishing a scientific paper based on the research Res Consortium provided.

Closing:

Res Consortium is changing the way people understand healthcare performance–both by inspiring behavioral improvement and by helping the healthcare system be more efficient with budget and patient care. Using Sisense as an embedded analytics solution and as their own internal data analysis methodologies, Res Consortium is able to quickly turn heavy reports into interactive, visual dashboards, allowing their customers to easily analyze complex healthcare data and change the narrative across the entire healthcare industry.

All Case Studies View Live Demo