Real-time Analysis and Visualization of the COVID-19 Epidemic

COVID-19 Outbreak Dashboard and Analysis Platform

On January 20, 2020, Alibaba Cloud built a real-time outbreak situation dashboard and analysis platform using publicly available data provided by governmental authorities. The following figure shows the structure of the platform. Alibaba Cloud organizes scattered data and draws different visual graphs based on various data analysis methods. On the platform, users can not only view relevant data as needed, but also integrate data in real time based on the platform and customize early warning services about the outbreak situation.

Free Outbreak Analysis Platform

Alibaba Cloud Log Service

The real-time outbreak analysis platform is built based on Alibaba Cloud Log Service technologies. Log Service is an integrated log data service provided by Alibaba Cloud. It helps customers quickly collect, consume, deliver, query, and analyze log data without performing development. In addition, it helps improve the O&M and operating efficiency, enabling users to process a massive volume of logs in the DT era. The following figure shows the scenarios of Alibaba Cloud Log Service.

Log Analysis Mid-end Architecture

The following figure shows the log analysis mid-end architecture in Log Service. The architecture consists of four parts: data collection, data manipulation, AI-based visual queries and analysis, and modules interconnected with relevant platforms. The log analysis mid-end architecture provides advantages such as rapid data analysis within seconds and powerful real-time analysis capabilities. This meets the actual needs for real-time analysis of the outbreak. Therefore, Alibaba Cloud built a real-time outbreak situation analysis dashboard based on this architecture.

Dashboard Access Method (Read-only Demo)

The real-time outbreak situation analysis dashboard is open to the public. Users can access the dashboard by accessing the URL:

Access Methods for the Comprehensive Outbreak Analysis Platform (Free)

To gain access to the platform, you need to log on to the Alibaba Cloud Console and click Log Service on the page that appears or directly visit

Dashboard Details

Core Metrics of the Dashboard

The real-time outbreak analysis dashboard is built based on the data provided by authorities. In the core metrics section of the dashboard, users can view the six main metrics of the current national cases: the cumulative number of confirmed cases, the cumulative number of suspected cases, the cumulative number of recovered persons, the cumulative number of deaths, the recovery rate, and the mortality rate. In the dashboard, the increase over the previous day’s numbers is displayed on the right side of the core metrics in a smaller font using different colors.

Real-time Data Maps

Below the core metrics module, the dashboard uses three different data maps to display the current distribution of cases around the globe, cases in China, and confirmed deaths in China. According to maps and province-wise statistics, the outbreak is currently concentrated in Hubei Province and its six surrounding provinces: Henan, Anhui, Zhejiang, Guangdong, Hunan, and Jiangxi. Relatively few cases are confirmed in other regions of China. On the right side of the map, a pie chart is displayed to show the percentages of confirmed cases in the six provinces with the most cases outside Hubei Province, and the percentage of confirmed cases in the remaining provinces in the country.

Outbreak Trend Charts

The dashboard also provides outbreak trend charts. The trend chart module consists of three images: the current risk trend, the death and recovery trends, and the mortality rate trend.

  1. Death and recovery trend chart: This chart allows users to view the number of deaths and the number of recovered persons in the whole country. At present, the number of recovered persons in the country remains higher than the number of deaths, indicating that the measures taken by the government continue to be effective.
  2. Mortality rate trend chart: This chart allows users to view the change curves of the following death metrics in China: the deaths nationwide, deaths inside Hubei, and deaths outside Hubei. According to the charts, the mortality rate outside Hubei has stayed at about 2‰, and its trend has been slowly declining. This indicates that at present the COVID-19 patients outside Hubei are relatively safe.

Outbreak Distribution Data Tables

The dashboard provides data tables of the outbreak distribution inside China and around the world for users to query. Important data is marked in red and green in the data tables for ease of reading. Users can sort and query the data in each column of the tables.

View Detailed Provincial and Municipal Dashboards

Users can click a province name to view the details about the outbreak in the province. In addition, users can randomly create similar data dashboards as needed. On the upper-left corner of the detailed dashboard, users can use the filter to select a specific province and city to analyze the outbreak data. After filtering, the data in the core metrics module, trend charts, and outbreak distribution data tables on the detailed dashboards will be changed to show the data of the selected province and city, which facilitates in-depth analysis by users.

Travel History Query for Confirmed Cases

The COVID-19 Outbreak Analysis application allows you to track the travel history of confirmed cases. For example, you can query flights that have recently been taken by confirmed cases. This helps you to promptly identify the potential risks caused by confirmed cases by using travel history.

News Announcements

The COVID-19 Outbreak Analysis application also provides a summary of news announcements to help users learn more.

Dashboard Subscription Service and Early Warning

Users can subscribe to the dashboard to stay informed about the outbreak. When subscribing, users can specify attributes such as the push frequency and the push channel.

Introduction to Log Service

View Raw Data of the Dashboard

Log on to the Log Service console. On the COVID-19 Outbreak Analysis page at , you can open the outbreak situation dashboard by clicking Query and Analysis in the left-side navigation pane. Alternatively, you can directly visit the URL of the read-only demo dashboard at . To view the SQL scripts that run the dashboard, click View Detailed Analysis on the desired module. In the raw logs, you can query complex raw data, such as the version information of the dashboard, statistical data for different places, and outbreak trend arrays for different places. By analyzing and calculating the raw data, the dashboard provides various statistical charts and trend charts.

Dashboard Log Mechanism

The following figure shows the log service script. The log service script is divided into two parts, which are separated by a vertical bar (|). The first part of the log consists of information such as the platform version number, query type, and queried region name. It is used as the raw log of the dashboard. The second part following the vertical bar (|) is SQL statements. The dashboard uses SQL statements to query, sort, and compute associated data. Log data includes various information such as the historical data and growth trends of the queried region. Users can retrieve the data for analysis.

Outbreak Situation Filter

Users can create custom filters as needed by using the edit feature provided on the outbreak situation filter. The province and city names in the filter menu are dynamically generated by the server. The cities in the second-level menu vary with the province selected from the first-level menu.

Retrieve Outbreak Data

Users can click Download Log in the outbreak situation data table to retrieve all the data from the table. By importing the data to a user’s engineering project, the user can perform write operations on the data.

Other Scenarios

The outbreak situation dashboard is built based on the SLS data processing ecosystem of Alibaba Cloud. Therefore, it can be connected to the data computing services in Alibaba Cloud. Log Service provides a variety of access methods. Users can scan the QR code for the outbreak situation dashboard to learn more about Alibaba Cloud Log Service.

Original Source:



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store