Our clinicians and managers have an ever increasing need for readily available information that can be used for:
- redesign of care
- implementation of evidence-based practice
- inform decision making
- continuous improvement
Historically our main method for capturing and reporting data was static reporting. Answering questions through information required a high level of technical ability (SQL skills) and in-depth knowledge of the data structures. The users (front line clinical staff, clinical leaders and managers) have relied on our Health Intelligence Service analysts to extract data and craete reprorts. This is a time-consuming process, involving multiple steps and competing priorities and users experience long delays for information.
What are we trying to achieve?
We wanted to implement a business intelligence tool that is agile and interactive, with a self-service capability.
Business intelligence (BI) tools are a type of application software designed to retrieve, analyse, transform and report data for business intelligence. The tools offer a suite of software applications including digital dashboards, data mining, and predictive analytics integrated into workflow. BI tools create automated reports and dashboards for users to slice and dice data on their own and perform their own reporting.
Our key objectives were to:
- empower all users, at all levels, to maximise their decision making capacity based on accurate, relevant and meaningful information
- enable the DHB to become a data driven, clinically led, outcomes-focused organisation
- reduce risk through increased knowledge of adherence to safety and quality initiatives and variations in practice and outcomes
- improve opportunities for successful planning and execution of clinically led service redesign through enriched knowledge and understanding of systems, processes and outcomes
What have we done?
We have implemented Qlik Sense as our an enterprise-wide business intelligence tool as part of our Data Discovery project. Our target is to have 1000+ information users by 2019.
- Created a governance model and established a Steering Group and a Working Group
- Developed simple data explorers that existed as static reports, focusing on core clinical data sets for Inpatient & Theatres, Emergency Department, and Outpatients
- Migrated apps that we had previously developed with QlikView over to Qlik Sense: Quality and Safety Markers; Patient and Whānau Care Standards data including: audits for falls, pressure injury, infection control (commode cleaning, contact precautions, hand hygiene and facilities cleaning); and patient experience results (Friends and Family Test)
Qlik Application Candidates
The Qlik Sense programme includes the development of dashboards to visualise clinical pathways, clinical excellence metrics, variation in and cost of care, and allow general exploration of clinical data. Qlik Sense apps are prioristised based on clinical champions and strategic priorities.