{"id":9806,"date":"2020-04-15T19:26:49","date_gmt":"2020-04-15T11:26:49","guid":{"rendered":"https:\/\/www.finereport.com\/en\/?p=9806"},"modified":"2021-01-14T15:21:36","modified_gmt":"2021-01-14T07:21:36","slug":"covid-19-dashboard-guide-from-data-extraction-to-data-visualization","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2020\/04\/15\/covid-19-dashboard-guide-from-data-extraction-to-data-visualization\/","title":{"rendered":"COVID-19 Dashboard Guide: From Data Extraction to Data Visualization"},"content":{"rendered":"

So far, over 600k people in the United States have been infected with COVID-19, and the growth rate has exceeded imagination, seriously affecting people’s daily lives. When China had effectively controlled the virus, no one expected that COVID-19\u00a0would spread throughout the world in the next month.<\/p>\n

Everyone is now paying attention to the epidemic data of various places. To view the data we are concerned about more efficiently, of course, you have noticed the epidemic screens on various websites. This article will tell you how to make a dashboard\u00a0of the world epidemic of various data.<\/p>\n

How to <\/b><\/strong>F<\/b><\/strong>ind the <\/b><\/strong>D<\/b><\/strong>ata you <\/b><\/strong>W<\/b><\/strong>ant?<\/b><\/strong><\/h2>\n

We know that there are many data sources about the COVID-19\u00a0on the Internet, and some are databases that can be used immediately. For example, there are many data sources updated daily on Kaggle.\u00a0For\u00a0example, you can find here<\/u><\/a>.<\/p>\n

The official data that is also worth paying attention to is the data published by the WHO<\/u><\/a>\u00a0every day. It is the most authoritative and comprehensive data. If you cannot find the data you want, you can find it here.<\/p>\n

You can download the database that can be used directly. About\u00a0the\u00a0data\u00a0source\u00a0you cannot directly use, we can use python or data crawling tools to solve the problem well.<\/p>\n

Also, you can directly find the data and templates here<\/a>\u00a0shared by FineReport.<\/p>\n

Download template & data<\/a><\/p>\n

Data <\/b><\/strong>C<\/b><\/strong>leaning is very <\/b><\/strong>I<\/b><\/strong>mportant!<\/b><\/strong><\/h2>\n

Many people may not notice that data cleaning is such an important step. People often do not notice that the data needs to be processed to show the desired results when it comes to the step of data visualization. Then\u00a0they\u00a0go\u00a0back to the step of processing\u00a0data, which\u00a0greatly reduces\u00a0efficiency. 80% of the time for data analysis is used for data cleaning. If the logic between the data can be sorted out during the data cleaning stage, the efficiency of subsequent steps\u00a0can be greatly improved.<\/p>\n

In this dashboard\u00a0tutorial, we need to confirm the data of each continent, but the existing data on the Internet are often\u00a0data of each country, so at the stage of data processing, we need to make several corresponding tables and corresponds to the country to the continent. Link them\u00a0by SQL, so that we\u00a0only need to crawl the corresponding data of the country every day, no need to count the data of continents every day. For details, please refer to the following figure<\/p>\n

\"\"<\/a><\/p>\n

Other data cleaning guidelines can refer to Data Cleaning Guide: Saving 80% of Your Time to Do Data Analysis.<\/a><\/p>\n

Teach you how to make a <\/b><\/strong>dashboard<\/b><\/strong>\u00a0<\/b><\/strong>step<\/b><\/strong>\u00a0<\/b><\/strong>by<\/b><\/strong>\u00a0<\/b><\/strong>step<\/b><\/strong><\/h2>\n

1. Design layout<\/b><\/strong><\/h3>\n

First, make clear the chart and layout we want to display.<\/p>\n

For how to use appropriate charts to display data, you can refer to:<\/p>\n

Regarding the layout, we use a more symmetrical layout here.<\/p>\n

Through the card, we can display multiple maps and\u00a0charts in turn in the middle. This can well solve the congestion problem if\u00a0you want to show many charts and can be viewed in comparison.<\/p>\n

\"\"<\/a><\/p>\n

2.\u00a0<\/b><\/strong>Data connection<\/b><\/strong><\/h3>\n

After designing the layout, we can start making our dashboard. First of all, we need to connect the data with FineReport. Here we have to mention that FineReport can support dozens of databases, which can meet the current public needs.<\/p>\n

\"\"<\/a><\/p>\n

Then\u00a0connect to the server via FineReport Designer and add a data connection and name is as CoronaVirus<\/strong>.<\/p>\n

Here we have published the data source, you can get to use it if you are interested.<\/p>\n

The data source is: jdbc: mysql: \/\/47.254.70.155: 3306 \/ corona_virus<\/strong><\/p>\n

Username and password are: finereport<\/strong><\/p>\n

\"\"<\/a><\/p>\n

3. Design the\u00a0dashboard\u00a0as\u00a0you\u00a0like<\/h3>\n

FineReport can easily set the size and position of the chart according to your layout. It only takes three steps to complete it easily.<\/p>\n

    \n
  1. Insert the chart you like<\/li>\n
  2. Set the size and position<\/li>\n
  3. Associating data with charts<\/li>\n<\/ol>\n

    \"\"<\/a><\/p>\n

    When you have set up the data and charts, what you may not imagine is that FineReport can set the colors and animation effects according to the combination you want. The map visualization that you care about most, we support maps of almost the whole world and are built into the designer.<\/p>\n

    \"\"<\/a><\/p>\n

    Download template<\/a><\/p>\n

    After the final adjustment, we can get this dashboard. On the left, we can learn the countries with the most infections through the bar graph and bubble chart. The line charts for trend at the bottom can see the increase in the number of diagnoses and deaths in the world. The scroll list on the right can see the data details of each country.<\/p>\n

    Through the card, you can adjust and choose to view the middle map. Pay special attention to this rose chart. The indexed data can make the data better displayed.<\/p>\n

    \"\"<\/a><\/p>\n

    Specific tutorials can refer to How to Make a COVID-19 Rose Chart?<\/a><\/p>\n

    Summary<\/b><\/strong><\/h2>\n

    Although the epidemic will not end in the short term, there is much more we can do. Wear a mask when you go out, and try to stay at home with fewer people. Enterprises need to do a good job of epidemic prevention and control. How to use comprehensive, effective and timely data and visualization technology to accurately sense the epidemic situation, provide a macro data basis for decision-makers and managers, save decision time, and make data visualization become managers\u2018helper to races against time is the key to winning the “war”.<\/p>\n

    Follow FineReport Reporting Software<\/a> to know more about the data visualization guides!<\/i><\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

    A step-by-step guide to making a worldwide COVID-19 dashboard!<\/p>\n","protected":false},"author":1,"featured_media":9812,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[854],"tags":[156],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/9806"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=9806"}],"version-history":[{"count":7,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/9806\/revisions"}],"predecessor-version":[{"id":11421,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/9806\/revisions\/11421"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media\/9812"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=9806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=9806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=9806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}