24 October 2023 | NEWS

Healthcare Analytics: Northern Region Health Coordination Centre (NRHCC)

Visualising population health and closing equity gaps

“I want to ensure that we have a strong Pacific voice in the analytics that we do.”

Namoe Tuipulotu, Head of Pacific Intelligence & Insights, Te Whatu Ora

Data played a critical role in informing the pandemic response in Aotearoa New Zealand.

Data analytics was used to monitor the spread of the Covid-19 virus, identify hotspots, and make decisions about public health interventions.

In the Northern region of the country, analytics was also used to target people most at-risk for complications from the virus.

Māori and Pacific regional coordination hubs had direct access to a Covid-19 dashboard, displaying clinical risk scores for local people who had tested positive.

Namoe Tuipulotu – Head of Pacific Intelligence & Insights, Te Whatu Ora, was working in the Pacific Hub at the time and says it is important to have Pacific people developing these types of dashboards if they are meant to reflect and show what’s happening for Pacific communities.

“By doing that, you get a true understanding of what the system is delivering as a whole, but also

get a better understanding of where Pacific people fit in that space,” she says.

Te Pae Tata Interim Health Plan 2022 says the interpretation and use of intelligence about communities will be led and interpreted by those communities, including Pacific people and Tāngata whaikaha – disabled people.

Tuipulotu says there is an intention to build an intelligence function within Te Whatu Ora Pacific Health Directorate.

“I want to ensure that we have a strong Pacific voice in the analytics that we do,” she says.

“It is about building relationships and partnerships across the system, but also making sure that we have key people in roles to provide the translation between what is happening in the business and how we present information to the communities that need it.”

Northern Region Health Coordination Centre (NRHCC)

As the Covid-19 pandemic spread around the world in early 2020, health districts in the Northern region of New Zealand worked rapidly to develop a regional view of hospital capacity and occupancy.

The Covid-19 Dashboard was used to support Covid-19 testing, vaccination, managed isolation and community care and is being expanded to other areas such as planned care, pulling from national datasets.

Developing a regional view

In March 2020 the Northern region was planning for an inundation of Covid-19 cases and for the hospitals to be overwhelmed, says former Head of Analytics at Waitematā, Delwyn Armstrong.

This meant the regional analytics teams, which includes Auckland, Counties Manukau,Waitematā and Northland Districts, were initially focused on getting a regional view of hospital capacity and occupancy.

Within three weeks, the team had developed a regional data store and soon after they had visibility of real time hospital capacity and occupancy across the region: something never achieved before. Due to the success of New Zealand’s lockdown, the hospital view was not as urgent as predicted, but as testing ramped up the dashboard was used to display a regional view of Covid-19 test results.

Armstrong, who is now Director Health Analytics and Insights, TeWhatu Ora – Health New Zealand, says after vaccinations began the dashboard displayed immunisation data and was also used to monitor people in quarantine or managed isolation.

When the Delta wave hit, it started to be used in relation to patient care, helping to direct ambulances carrying Covid-19 patients by identifying sites with ‘Covid-ready’ beds to care for them, she says.

As the level of infection increased, the majority of Covid patients were now in the community, and the focus turned to predicting who might need high-level care.

Visualising a clinical risk score

As the number of Covid-19 cases quickly grew, the regional dashboard was populated with more and more data.

This enabled the regional team, led by health informatics fellow at the i3 Institute for Innovation and Improvement, Cheng Kai (CK) Jin, to create a machine learning algorithm to predict the risk of hospitalisation.

Data around demographics, vaccination status, long term conditions, medications, and test results was used to create the clinical risk score, which was then automatically calculated and displayed in the operational dashboard.

This helped clinicians decide who needed to be seen and whether they met criteria for anti-viral drugs and pulse oximeters for monitoring in the community.

“The dashboard enabled data driven allocation of health services,” says Armstrong.

Data was shared with primary health organisations twice a day, so general practitioners could see all of their patients who had recently tested positive and what their risk scores were.

The Māori and the Pacific Regional Coordination Hubs had direct access to the dashboard.

Namoe Tuipulotu, Pacific
Workforce Lead, Te Whatu
Ora – Health New Zealand

“Analytics is about shifting from counting widgets to starting to understand outcomes and how we can know we are truly making a difference for our patients.”

Data enabling an equity focus

Namoe Tuipulotu – Head of Pacific Intelligence & Insights, Te Whatu Ora, was working in the Pacific Regional Coordination Hub when she got involved in developing the dashboard.

“It is really important that we have Pacific people developing these types of dashboards if they are meant to reflect and show what’s happening for Pacific communities,” she explains.

Tuipulotu says the clinical risk score was particularly useful for identifying high risk patients and visualising who had been contacted or assessed within 24 and 48 hours. This information could be filtered by ethnicity and age group.

“It enabled us to see whether we were serving our Pacific people appropriately,” she says.

For example, a user could extract a list of high-risk Pacific patients who had tested positive in the last 24 hours.

“In my experience if you can’t tell the clinicians who a particular patient is they may lose trust in the data, but we were able to get down to NHI (National Health Index) level data, allowing clinical teams at the hub to sense check whether or not the data was accurate, which really helped with data quality,” Tuipulotu explains.

“It highlighted to the director of Pacific Health, who could feed up to the Executive Leadership Team, what was being done by these Pacific hubs and providers. It was really helpful to be able to drill down in different ways, because the data my manager might want would not necessarily be the same as what the doctor on call that day would want to see.

“Data is power so having this information readily available was extremely important during the pandemic,” says Tuipulotu.

“Having the right data also makes your processes so much more efficient.”

Delwyn Armstrong, Director
Health Analytics and
Insights, Te Whatu Ora –
Health New Zealand

“The dashboard enabled data driven allocation of health services.”

A scalable platform for the future

The NRHCC regional data store was originally hosted on-premise, but was shifted to the cloud as the amount of data coming in started to multiply, ultimately holding around four million Covid-19 test results.

Armstrong says this was “a real step change”.

“It was hard, but it really changed things for us in terms of scalability,” she explains.

The Covid-19 Dashboard now has around 60 different pages and Armstrong describes it as “like a big web site, providing windows to multiple different data sets in a completely integrated way”.

Data is key to the health system’s planning to enable it to ‘catch-up’ on services and care that was unable to be delivered during lockdown.

Armstrong says a range of initiatives are now underway, such as bringing together all planned care data, in order to nationally tackle wait lists.

“We’re looking to use various data sources to target the people who’ve been waiting the longest and who have the greatest need,” she says.

“Having these analytics tools means that decision makers can put in different scenarios to look at how we can shape our services.”

Tuipulotu strongly believes that “if you’ve got the right information readily available, you can make better decisions.

“Analytics is about shifting from counting widgets to starting to understand outcomes and how we can know we are truly making a difference for our patients,” she says.

Click to download the full report

TAGS | Health

You may also be interested in

25 October 2023 | NEWS

5-6 min read

Healthcare Analytics: Te Whatu Ora – New Zealand Health Partnerships

The organisation needed to pull that data together to provide a national view: it went live in 2021 with an analytics tool and a data platform and rapidly stood up the data pipelines to all ERP systems.

LEARN MORE

25 October 2023 | NEWS

5-6 min read

Healthcare Analytics: Te Whatu Ora, Capital, Coast, Hutt Valley and Wairarapa

Data literacy is the ability to read, work with, analyse and communicate with data. Data literate staff understand what questions to ask and how to get true benefit from available data.

LEARN MORE

25 October 2023 | NEWS

5-6 min read

Healthcare Analytics: Te Whatu Ora – Health New Zealand, Counties Manukau

Users can see in real time, at a glance the overall hospital occupancy and a simple traffic light system provides an overview of performance.

LEARN MORE

7 October 2023 | NEWS

45 min read

Healthcare Analytics in Aotearoa New Zealand

A Special Report on Healthcare Analytics in Aotearoa NZ – recognising the successful use of data analytics to drive better outcomes for the health of all New Zealanders.

LEARN MORE

24 September 2023 | NEWS

2 min read

Modernisation key to fix crumbling health IT infrastructure

Te Whatu Ora is making clear choices about national platforms. Leigh Donoghue gave the example of the new National Data Platform, which is being built on Snowflake.

LEARN MORE

16 August 2023 | NEWS

2 min read

Work begins on National Data Platform

The project will create a common platform for national data sets, which are currently dispersed across many platforms. Over time, the NDP will connect the health system’s multiple data environments.

LEARN MORE

12 August 2023 | NEWS

2 min read

Te Whatu Ora taps Accenture and Acumen BI for National Data Platform development

Accenture has been selected in partnership with Acumen BI, as implementation partner for the National Data Platform (NDP), which will unify information held by more than 28 entities under the previous health system.

LEARN MORE

2 February 2023 | CUSTOMER STORIES

5 min read

Patient Reported Outcome Measures Programme

This project provides an opportunity to work with industry partners to develop analytical capability to link multiple data sets and use them predictively.

LEARN MORE

28 June 2022 | CUSTOMER STORIES

6 min read

Tackling The Covid-19 Backlog: Data Driving Decisions

Waitemata DHB implemented Qlik to create a waitlist planning tool to help operations managers and clinicians manage the elective surgery backlog.

LEARN MORE

4 June 2021 | CUSTOMER STORIES

4 min read

How New Zealand’s Transport Agency is Using Data for Transparency

Data and visualisation experts from Waka Kotahi – NZTA share how they partnered with Acumen BI and Qlik to build dashboards, and discuss some of their open data plans.

LEARN MORE

5 May 2021 | CUSTOMER STORIES

11 min read

Context is Everything When it Comes to Data Literacy

Our approach to data literacy at CCDHB sees us use Qlik Sense in an attempt to make complex data contexts transparent. The accessibility of data has supported business cases for required changes in staffing levels as part of the CCDM programme.

LEARN MORE

22 December 2020 | RESOURCES

1-2 min read

Putting AI Policy into Practice in Healthcare – with Rob O’Neill

Watch this video to see how AI will influence the delivery of care in the future. Understand the potential of AI as well as its constraints with examples of where AI policy has been put into practice effectively.

LEARN MORE

22 October 2020 | CUSTOMER STORIES

1 min read

Better Ward Visibility For Nurses

Capital & Coast DHB is providing nursing staff with better than ever ward visualisation. Learn how nurses and midwives can deliver superior patient care when data from numerous sources are delivered to one dashboard.

LEARN MORE

19 October 2020 | CUSTOMER STORIES

1 min read

eHealthNews Webinar

eHealthNews webinar: Business Intelligence driving healthcare transformation. This webinar explores examples of business intelligence tools in use in primary, secondary and tertiary care across New Zealand.

LEARN MORE

23 September 2020 | CUSTOMER STORIES

1 min read

Data & Digital Futures: MoH View

The Ministry of Health’s data governance manager Simon Ross provides guidance into getting more value from the safe and effective use of data by developing a Health Data Strategy.

LEARN MORE

23 September 2020 | NEWS

1 min read

Counties Clinicians Qlik For Data

Providing organisations with more affordable entry into the world of data analytics, the potential provided to other healthcare organisations is outlined by CM Health and Waitematā DHBs CIO Stuart Bloomfield and CM Health Clinical Director of Information Systems Tina Sun.

LEARN MORE

23 September 2020 | CUSTOMER STORIES

1 min read

Ministry Visualises Mental Health and Addiction Data

The Ministry of Health developed a data tool that provides insight into mental health and addiction issues experienced by New Zealanders. The application incorporates data from the Ministry, DHBs, PHOs and NGOs using sources such as medication dispensing, hospitalisations and social outcome indicators.

LEARN MORE

23 September 2020 | CUSTOMER STORIES

1 min read

Data and the Pandemic – Waitematā’s Story

From uncovering the potential extent of the Covid-19 outbreak and its impact, through developing a view of hospital capacity and occupancy to developing a regional data store with all testing information in three weeks, Armstrong provides fascinating insight into the process and tools used to manage it.

LEARN MORE

1 September 2020 | RESOURCES

5 min read

Getting Started with Cloud-based Data Analytics

Organisations are leveraging cloud-based data analytics solutions for the flexibility and scalability they provide, but security is still a significant hurdle to cloud migration. Explore Challenges of user authentication and authorisation.

LEARN MORE

1 September 2020 | RESOURCES

4 min read

Is Your Company Culture Prepared for Cloud Data Analytics?

Organisations are migrating data to the cloud to reap the benefits, but it’s essential to consider how your people and systems will be impacted by a new data pipeline and what tools and training will be involved if you move to a more automated analytics platform.

LEARN MORE

1 September 2020 | RESOURCES

3 min read

Why Data Collaboration is a Necessity for Strategic Decision-Making

Without company-wide visibility into data, it’s difficult or even impossible for leaders to make data-driven decisions outside of departmental bubbles. This challenge is especially transparent in verticals.

LEARN MORE

6 August 2020 | NEWS

10 min watch

New and Exciting Partnerships

Leading technologies, Qlik, Snowflake and DataRobot provide scalable and automated data platforms as well as automated advanced analytics/machine learning. Ensuring there is excellent integration to facilitate the use of scalable real-time analytics.

LEARN MORE

18 May 2020 | WEBINARS

160 min watch

Innovation & Analytics Strategy – Webinar (Donald Farmer)

Donald Farmer discusses the Principle of TreeHive Strategy. Explore how to define and measure innovation in a very practical way, enabling teams to quickly and effectively become more innovative.

LEARN MORE

4 March 2020 | CUSTOMER STORIES

8 min read

CCDHB Customer Story

As services experience an increase in the acuity of patients, we need to increase care capacity – ensuring we have the right nurses in the right place. To met these aims we need a deeper understanding of the needs of patients and detailed insights about our nurses and midwives.

LEARN MORE

25 February 2020 | RESOURCES

3 min read

Qlik NPrinting: On-Demand

Qlik NPrinting reports can be run ‘On-Demand’ directly from your Qlik Sense applications, giving you the ability to generate PDF, Excel, Word and Power Point reports directly from within a Qlik Sense application based on your selections and template.

LEARN MORE

16 February 2020 | CUSTOMER STORIES

1-2 min read

Clinical Excellence Metrics

Roll out of the new Qlik Sense Data Discovery (business intelligence) tool commenced in January 2017 and we are incrementally incorporating clinical metrics in the tool.

LEARN MORE

16 February 2020 | CUSTOMER STORIES

6 min read

Data Discovery: Using Qlik Sense for Care Redesign

Using Qlik Sense to provide timely acess to meaningful data that can be used for the redesign of care, implementation of evidence-based practice and continuous improvement. Making data accessible in a timely, more organised manner will mean clinicians do not have to spend their limited, non-clinical time making multiple data extracts and data report requests and sifting through large volumes of data.

LEARN MORE

16 February 2020 | NEWS

4 min watch

Special Qlik pricing for NZ Healthcare sector

The Ministry of Health and National District Health Boards CIO Forum has partnered with Acumen BI and Qlik to deliver a Health Sector Pricing Model that will benefit all DHBs, national and regional health bodies, public health organisations and associated health non-governmental organisations.

LEARN MORE

16 January 2020 | RESOURCES

2-3 min read

Qlik NPrinting: Complex Conditional Formatting

With Qlik NPrinting, you can present information with the same formatting as in your Qlik application. By default, Qlik NPrinting attempts to preserve the original formats of imported Qlik objects.

LEARN MORE

12 December 2019 | RESOURCES

3 min read

Qlik NPrinting: Simple report layouts

Qlik NPrinting lets you create complex and attractive reports using your Qlik data. You can create new visualisations or tables using native Microsoft Office, or NPrinting Pixel Perfect capabilities. Read on for tips and tricks.

LEARN MORE

4 December 2019 | WEBINARS

100 min watch

Emergency Department – Webinar (Waitemata DHB)

In this webinar Waitematā District Health Board’s Dr Stefan van der Walt presents an overview of the DHB Emergency Department’s data Journey. Learn their insights into data driven patient care, better ED flow and improved patient outcomes.

LEARN MORE

13 November 2019 | RESOURCES

2 min read

Tailored reports in your preferred format

Qlik NPrinting allows you to create and distribute reports using your Qlik Application data. Reports can be shared in many formats, such as Excel, Word, PowerPoint, PixelPerfect, HTML, and PDF; read on to understand the benefits of the different format options.

LEARN MORE

16 October 2019 | WEBINARS

50 min watch

Complex Data Modelling to Answer Clinical Questions – Webinar (Waitemata DHB)

Waitemata DHB address interoperability between key clinical systems by creating complex data models.

LEARN MORE

11 October 2019 | WEBINARS

60 min watch

Analytical Operations Centre Blueprint – Webinar (Morecambe Bay NHS Foundation Trust)

Rob O’Neill presents an overview of their data-driven Operations Centre developed and deployed on the Qlik platform.

LEARN MORE

24 September 2019 | WEBINARS

40 min watch

Human Resource Analytics from AMS Payroll – Webinar (Capital and Coast DHB)

Capital and Coast District Health Board present the recently released HR Analytics Dashboard and Qlik Applications which have resulted in data being presented to a wide range of users in ways previously not possible.

LEARN MORE

24 September 2019 | WEBINARS

35 min watch

Delivering value through Procurement Analytics – Webinar (healthAlliance FPSC)

Delivering value to health through Procurement Analytics, showcasing reduced repetitive manual reporting effort for the procurement Supplier Relationship Management (SRM) programme.

LEARN MORE

28 January 2019 | CUSTOMER STORIES

From Gatekeepers to Shopkeepers

Objectives, goals priorities and next steps of implementing QlikSense at the Ministry of Health, making it easier for people to access the information they need, while keeping the information safe.

LEARN MORE

Have Questions? Reach out for a no-obligation chat.

"*" indicates required fields

Name*
This field is for validation purposes and should be left unchanged.