Business intelligence

Our BI is a healthcare business intelligence and data warehousing module with a flexible, robust and powerful toolset.

It can be used to create, manage and maintain highly-configurable reports and dashboards, manage patient flow, BI and emergency care and inpatients, automate the production of statutory reporting and commissioning data sets, and trap and resolve data quality issues.

Fully integrated with the EPR, BI can replace existing information management systems. Data can be integrated from other systems, cross-linked with System C products, stored, analysed and presented according to local and national requirements.

BI is built in the UK to current NHS standards, including Referral to Treatment, Commissioning Data Sets, Contract Allocation, Maternity Services Data Set, Healthcare Resource Groups and the Prescribed Specialised Services Commissioning Tool.

BI utilises the full capabilities of the industry-leading Microsoft SQL Server database management system, offering reporting and analysis services. 

Integrated features

• Fully integrated with EPR: full reporting dataset is available in near real time
• Live data feeds: subset of current bed status, bed flow, emergency care and inpatients’ data for patient flow management
• Parallel database: reports do not compromise operational performance of PAS
• Industry-standard data warehouse methodology: used for fast data retrieval
• Integrated active directory security: includes ability to anonymise and pseudo anonymise patient level data
• Template reports: pre-configured with a suite of standard operational, management and dashboard reports for out-of-the-box reporting during deployment
• Reporting tools: powerful and flexible reporting toolset enables the creation of reports, scorecards and dashboards. Supports both published reports and ad-hoc reporting
• External data: ability to integrate data from 3rd party systems
• Data extracts: locally configurable data extract capability
• Platform for complex analytics and data science
• Prediction: (developed in conjunction with Nottingham University Hospitals NHS Trust) for emergency care attendances and emergency admissions
• Flexible contract allocation rules can be amended to make contracting decisions on any data items, in any linked activity tables, without requiring a software update
• Regular product releases including National ISNs and product enhancements to support changing NHS requirements

BI and Vitals together have the capability to make real-time performance on the critical clinical issue of sepsis, visible in all clinical areas. One third of deaths in the hospital in 2014-15 were coded as having a sepsis related diagnosis. BI Data Visualisation will enable continuous assurance that all patients developing sepsis receive optimal care. Speed and consistency are key to surviving sepsis. Not all deaths are avoidable, but we’ve already seen approx. 10% drop in sepsis associated deaths since beginning to deploy Vitals. A system that enables us to monitor delivery of the sepsis care bundle real-time, allowing everyone to see if we have small delays, will build on the improvements in mortality already achieved, whilst also reducing the costs of providing outstanding care.

Dr. Robert Allcock MA (Cantab et Oxon) BMBCh FRCP (Edin) Consultant Chest Physician and Clinical Lead for Health Informatics at QE Gateshead