• Amit Sarda

COVID-19: JHU Live Data Visualization using Tableau

Updated: Apr 3

Introduction


Johns Hopkins University's (JHU's) Center for Systems Science and Engineering (CSSE) is maintaining a live dashboard of the virus' spread. Tableau has gone a step ahead and made this data available for reuse and visualization.


This is an initial attempt to sanity-check the data.


While the data has been reported at the country-level, some of the data is available at the provincial-/state-level for a few countries (US, China to name a couple).





Dashboard


You can filter this dashboard by the status of the reported cases: Active, Confirmed, Deaths, Recovered. The World map is then shaded by the number of reported cases - a heat map.


When you hover over or click a country map, you can see a line chart that shows the growth of the numbers since the beginning of time.


The dashboard is refreshed once a day, automatically.


The data in the Google Sheets document is being maintained by the folks at Tableau.



Source: Tableau makes Johns Hopkins coronavirus data available for the rest of us


Data Source: Google Sheets


Ankit Mittal, a very dear friend, pitched in to create this dashboard to present the same data a little differently. This dashboard shows a number of things:


  • World map of positive cases as well as deaths due to Covid-19

  • An ordered list of countries by the total positive cases as well as deaths to date

  • An ordered list of countries by number of positive cases and deaths in the most recent day

  • The total number of positive cases and deaths to date

  • Positive cases and deaths in the most recent day

  • Daily absolute number growth of positive cases and deaths

  • Day-on-day % growth of positive cases and deaths


Click the full-screen button at the bottom-right to get a better picture of this dashboard.


If there are questions you'd like to pose for this dataset, let me know in the comments.

 
  • Twitter
  • Instagram

©2020 by Amit Sarda