The Australian government is leveraging Qlik’s technology to deliver data analytics capabilities in support of the Department of Health’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 King of Prussia-based Qlik to provide health officials a clear perspective on COVID-19-related statistics. Qlik’s data visualization 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 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, and as soon as the pandemic hit, it took no more than three weeks for a prototype platform to be delivered to the Department of Health. A live public website was available shortly after to provide up-to-date information built to support a half-million hits a day and up to 5,000 hits a second.
The project was ground-breaking from the start, as Department of Health officials 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 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 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 to curate the information.
- Pandemic Incident Management: 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. 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 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 decision-making.
Collaboration for success
For its pioneering work, Australia’s Department of Health was recently presented the Qlik Excellence in Healthcare Award.
“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.”