Using SQL we can gather specific data and prepare it for visualisation, in this instance we’re using Tableau.

In the first query, we’re gathering data for total cases, total deaths, and a subsequent percentage calculation of these two figures for all countries.

1. Total death count grouped by location
2. Highest infection count (by country) and subsequent percentage of population infected
3. A daily toll of highest infection count and percent of population infected sorted I descending order.

Using this information we can formulate tables which are then processed in Tableau for data visualisation. This is the final report which encompasses all that information we analysed in a very user-friendly format.