How Devon Partnership NHS Trust Streamlined Reporting Processes to Maximize Top-Down Performance
Company Size
1,000+
Region
- Europe
Country
- United Kingdom
Product
- Dundas BI
Tech Stack
- SQL Server Reporting Services (SSRS)
- SharePoint
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Customer Satisfaction
- Productivity Improvements
Technology Category
- Analytics & Modeling - Real Time Analytics
- Functional Applications - Remote Monitoring & Control Systems
Applicable Industries
- Healthcare & Hospitals
Applicable Functions
- Business Operation
- Quality Assurance
Use Cases
- Predictive Quality Analytics
- Remote Asset Management
Services
- Software Design & Engineering Services
- System Integration
About The 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.
The 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.
The 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.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Hospital Inventory Management
The hospital supply chain team is responsible for ensuring that the right medical supplies are readily available to clinicians when and where needed, and to do so in the most efficient manner possible. However, many of the systems and processes in use at the cancer center for supply chain management were not best suited to support these goals. Barcoding technology, a commonly used method for inventory management of medical supplies, is labor intensive, time consuming, does not provide real-time visibility into inventory levels and can be prone to error. Consequently, the lack of accurate and real-time visibility into inventory levels across multiple supply rooms in multiple hospital facilities creates additional inefficiency in the system causing over-ordering, hoarding, and wasted supplies. Other sources of waste and cost were also identified as candidates for improvement. Existing systems and processes did not provide adequate security for high-cost inventory within the hospital, which was another driver of cost. A lack of visibility into expiration dates for supplies resulted in supplies being wasted due to past expiry dates. Storage of supplies was also a key consideration given the location of the cancer center’s facilities in a dense urban setting, where space is always at a premium. In order to address the challenges outlined above, the hospital sought a solution that would provide real-time inventory information with high levels of accuracy, reduce the level of manual effort required and enable data driven decision making to ensure that the right supplies were readily available to clinicians in the right location at the right time.
Case Study
Gas Pipeline Monitoring System for Hospitals
This system integrator focuses on providing centralized gas pipeline monitoring systems for hospitals. The service they provide makes it possible for hospitals to reduce both maintenance and labor costs. Since hospitals may not have an existing network suitable for this type of system, GPRS communication provides an easy and ready-to-use solution for remote, distributed monitoring systems System Requirements - GPRS communication - Seamless connection with SCADA software - Simple, front-end control capability - Expandable I/O channels - Combine AI, DI, and DO channels
Case Study
Driving Digital Transformations for Vitro Diagnostic Medical Devices
Diagnostic devices play a vital role in helping to improve healthcare delivery. In fact, an estimated 60 percent of the world’s medical decisions are made with support from in vitrodiagnostics (IVD) solutions, such as those provided by Roche Diagnostics, an industry leader. As the demand for medical diagnostic services grows rapidly in hospitals and clinics across China, so does the market for IVD solutions. In addition, the typically high cost of these diagnostic devices means that comprehensive post-sales services are needed. Wanteed to improve three portions of thr IVD:1. Remotely monitor and manage IVD devices as fixed assets.2. Optimizing device availability with predictive maintenance.3. Recommending the best IVD solution for a customer’s needs.
Case Study
HaemoCloud Global Blood Management System
1) Deliver a connected digital product system to protect and increase the differentiated value of Haemonetics blood and plasma solutions. 2) Improve patient outcomes by increasing the efficiency of blood supply flows. 3) Navigate and satisfy a complex web of global regulatory compliance requirements. 4) Reduce costly and labor-intensive maintenance procedures.
Case Study
Harnessing real-time data to give a holistic picture of patient health
Every day, vast quantities of data are collected about patients as they pass through health service organizations—from operational data such as treatment history and medications to physiological data captured by medical devices. The insights hidden within this treasure trove of data can be used to support more personalized treatments, more accurate diagnosis and more advanced preparative care. But since the information is generated faster than most organizations can consume it, unlocking the power of this big data can be a struggle. This type of predictive approach not only improves patient care—it also helps to reduce costs, because in the healthcare industry, prevention is almost always more cost-effective than treatment. However, collecting, analyzing and presenting these data-streams in a way that clinicians can easily understand can pose a significant technical challenge.
