Sydney – Qlik® today announced that the Australian Government Department of Health is leveraging Qlik’s technology to deliver data analytics capabilities in support of the Department’s reporting of COVID-19 related information to key stakeholders.
Since the outbreak of the pandemic in Australia in early 2020, the Department of Health has been using Qlik to provide health officials a clear perspective on COVID-19 related statistics. Qlik’s data visualisation and analytics solutions underpin COVID-19 public announcements, pandemic incident management and COVID-19 updates on the Department of Health website.
The Department needed a rapid data solution that was external facing, easily adaptable and could support the National Incident Room to provide curated data on a daily basis so as to keep the Australian public informed on the unfolding COVID-19 situation. This meant clear and swift reporting, with no room for error.
Qlik offered an end-to-end solution, allowing Health to join to many disparate datasets quickly and produce a wide range of reporting formats. As soon as the pandemic hit, it took not more than three weeks for a prototype platform to be delivered for the Department of Health. A live public website was available shortly after to provide up-to-date information built to support half million hits a day and up to 5,000 hits a second.
The project was ground-breaking from the start, as the Health team were challenged to develop new and innovative data products for many different audiences with the key guiding principles of accuracy, reliability, availability and consistency, all delivered rapidly.
Qlik solutions were used across the following areas:
- COVID-19 public announcements: At the beginning of the COVID-19 pandemic, Dr. Nick Coatsworth, Deputy Chief Medical Officer, was delivering twice weekly updates via Social Media channels and required the most up-to-date information available to inform the public of the escalating COVID-19 situation. Using the power of Qlik’s NPrinting reporting solution, the Department was able to supply accurate data and a flexible solution for every instance.
- Informatic Placemat: Qlik’s on-demand data generation supported rapid response requests for internal and external information and decision making. Originally, the Placemat was built as a manually constructed visual dashboard highlighting key figures related to the spread of COVID-19. However, this was extremely slow and exposed a risk for error. The Qlik solution enabled automated reporting – reducing time spent by staff in the National Incident Room to curate the information by five to six hours daily.
- Pandemic Incident Management (PIM): A user-centric dashboard was created by combining different data models and Qlik apps to create analytics for internal use. The Department’s internal pandemic management team was able to monitor and respond quickly to information on the Department’s own workforce volumes, IT capacity, and staff movement to identify and manage employees working remotely or onsite.
- COVID-19 Impact Assessment: Through analytics, the Department was able to provide a view of national availability for medical devices such as ventilators and PPE, as well as measure hospital capacity. This was achieved by integrating data from a range of sources including the Australian Register of Therapeutic Goods (ARTG) and hospital data from Critical Health Resource Information System (CHRIS). Information was updated daily to facilitate strategic decision making.
- COVID-19 Vulnerability Assessment: A separate Qlik application helped integrate data sets from 18 different vulnerable cohorts such as those with chronic disease, disability, or those in remote areas. The dashboard enabled the Department’s Data and Analytics Branch to easily find correlations and trends in the data sets by drilling down into age, gender and geography to find areas and people that were most at risk and to aid Department decision making.
Collaboration for success
For its pioneering work, the Australian Government Department of Health was recently presented the “Qlik Excellence in Healthcare Award” at Qlik’s Australia and New Zealand Health & Public Sector Digital Transformation Awards 2021.
“Australia’s approach to the COVID-19 pandemic is well-regarded globally and this can largely be attributed to a well-coordinated and collaborative effort across government, the healthcare sector as well as the private sector that was underpinned by data-driven decision making,” said Charlie Farah, Director of Industry Solutions for Healthcare and Public Sector at Qlik. “This enabled the government to swiftly act and provide clear communication to citizens and State authorities on the rapidly changing situation to help limit the spread of COVID-19 within the community.”
Qlik’s vision is a data-literate world, where everyone can use data and analytics to improve decision-making and solve their most challenging problems. A private SaaS company, Qlik provides an end-to-end, real-time data integration and analytics cloud platform to close the gaps between data, insights and action. By transforming data into Active Intelligence, businesses can drive better decisions, improve revenue and profitability, and optimize customer relationships. Qlik does business in more than 100 countries and serves over 50,000 customers around the world.
© 2021 QlikTech International AB. All rights reserved. All company and/or product names may be trade names, trademarks and/or registered trademarks of the respective owners with which they are associated.
The information provided herein is subject to change without notice. In addition, the development, release and timing of any product or functionality described herein remain at the sole discretion of Qlik and should not be relied upon in making a purchasing decision, nor as a representation, warranty or commitment to deliver specific products or functionality in the future.