insightsoftware Case Studies How Devon Partnership NHS Trust Streamlined Reporting Processes to Maximize Top-Down Performance

Edit This Case Study Record

	How Devon Partnership NHS Trust Streamlined Reporting Processes to Maximize Top-Down Performance insightsoftware

How Devon Partnership NHS Trust Streamlined Reporting Processes to Maximize Top-Down Performance

insightsoftware

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Healthcare & Hospitals
Applicable Functions	Quality Assurance Business Operation
Use Cases	Predictive Quality Analytics Remote Asset Management
Services	System Integration Software Design & Engineering Services
Challenge	Devon Partnership NHS Trust was facing challenges with their existing SharePoint portal and SQL Server Reporting Services (SSRS) which were used for reporting. The SharePoint portal was becoming overpopulated with Excel and SSRS reports, leading to difficulties in locating specific reports and slower operation speeds. The reports also appeared outdated, leading to low adoption rates and challenges in implementing a performance management culture. The reports were also difficult to develop and maintain, making it challenging for the Informatics team to deliver valuable data to the consumers in a meaningful way and in a timely fashion. The Trust needed to streamline reporting processes, increase user adoption, and reduce the number of requests to the Informatics team. Read More
About Customer	Devon Partnership NHS (National Health Service) Trust is located in south west England and provides publicly funded health services both locally and nationally. The Trust caters to individuals with varying mental health complications, learning disabilities, alcohol and drug addictions, eating disorders and more. The organization is passionate about promoting good mental health and well-being and strives to use its expertise and resources, in conjunction with its partnerships, to deliver exceptional quality services that are safe and focused on people’s recovery. At any given time, there are roughly 20,000 patients being supported through any of the Trust’s services. The Informatics team within the Trust services the organization by resolving hundreds upon thousands of information requests that are amassed from both external sources as well as from employees within the Trust. Read More
Solution	Devon Partnership NHS Trust evaluated several Business Intelligence vendors including Qlik, Tableau and Dundas Data Visualization. They found that Dundas’ platform, Dundas BI, was more developed for end-to-end functionality than the other vendor’s offerings, and was less complicated in regards to connecting to data warehouses and linking to SQL Server with pure or parameterized SQL queries they have already developed for previous reports. The Trust discovered that the ability to connect to a variety of data sources was an innate feature of Dundas BI, which would eliminate additional layers of processing for them. Dundas BI allowed the Trust to connect directly with their existing databases and warehouses, limiting the amount of data-prep required to perform data discovery, filtering, sorting, grouping and drill-downs. Dundas BI’s web and mobile-optimized dashboards provided the Trust the ability to build, share and view fully interactive dashboards directly in their HTML5 browser, without the need for a desktop application. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Healthcare & Hospitals

Applicable Functions

Quality Assurance

Business Operation

Use Cases

Predictive Quality Analytics

Remote Asset Management

Services

System Integration

Software Design & Engineering Services

Challenge

Devon Partnership NHS Trust was facing challenges with their existing SharePoint portal and SQL Server Reporting Services (SSRS) which were used for reporting. The SharePoint portal was becoming overpopulated with Excel and SSRS reports, leading to difficulties in locating specific reports and slower operation speeds. The reports also appeared outdated, leading to low adoption rates and challenges in implementing a performance management culture. The reports were also difficult to develop and maintain, making it challenging for the Informatics team to deliver valuable data to the consumers in a meaningful way and in a timely fashion. The Trust needed to streamline reporting processes, increase user adoption, and reduce the number of requests to the Informatics team.

About Customer

Devon Partnership NHS (National Health Service) Trust is located in south west England and provides publicly funded health services both locally and nationally. The Trust caters to individuals with varying mental health complications, learning disabilities, alcohol and drug addictions, eating disorders and more. The organization is passionate about promoting good mental health and well-being and strives to use its expertise and resources, in conjunction with its partnerships, to deliver exceptional quality services that are safe and focused on people’s recovery. At any given time, there are roughly 20,000 patients being supported through any of the Trust’s services. The Informatics team within the Trust services the organization by resolving hundreds upon thousands of information requests that are amassed from both external sources as well as from employees within the Trust.

Solution

Devon Partnership NHS Trust evaluated several Business Intelligence vendors including Qlik, Tableau and Dundas Data Visualization. They found that Dundas’ platform, Dundas BI, was more developed for end-to-end functionality than the other vendor’s offerings, and was less complicated in regards to connecting to data warehouses and linking to SQL Server with pure or parameterized SQL queries they have already developed for previous reports. The Trust discovered that the ability to connect to a variety of data sources was an innate feature of Dundas BI, which would eliminate additional layers of processing for them. Dundas BI allowed the Trust to connect directly with their existing databases and warehouses, limiting the amount of data-prep required to perform data discovery, filtering, sorting, grouping and drill-downs. Dundas BI’s web and mobile-optimized dashboards provided the Trust the ability to build, share and view fully interactive dashboards directly in their HTML5 browser, without the need for a desktop application.

Impact #1	The Trust was able to streamline reporting processes and increase user adoption.
Impact #2	The Trust was able to reduce the number of requests to the Informatics team.
Impact #3	The Trust was able to transition from older, outdated paginated styles of reporting services towards more modern and personalized interfaces.

Impact #1

The Trust was able to streamline reporting processes and increase user adoption.

Impact #2

The Trust was able to reduce the number of requests to the Informatics team.

Impact #3

The Trust was able to transition from older, outdated paginated styles of reporting services towards more modern and personalized interfaces.

Benefit #1	Completion rates of checks have increased by over 20%
Benefit #2	Over 500 users regularly accessing their reports

Benefit #1

Completion rates of checks have increased by over 20%

Benefit #2

Over 500 users regularly accessing their reports

Download PDF Version

Overview

How Devon Partnership NHS Trust Streamlined Reporting Processes to Maximize Top-Down Performance

Operational Impact

Quantitative Benefit