This project explores COVID-19 data in a dashboard created in Tableau.
The dashboard provides insights into the COVID-19 pandemic, by the number of infected cases and confirmed deaths over time. It also includes charts by country and continent to help understand the spread of the virus.
Dataset Exploration
The main data source is available at this website. It provides daily and cumulative figures on COVID-19, including confirmed cases and deaths by country. The data used to create the dashboard was retrieved by running SQL queries on this dataset. You can check out my previous project with the SQL queries, of which this dashboard is a continuation, at this link.
A dashboard has been created in Tableau to visualize key insights, including:
- global totals for infected cases, confirmed deaths, and death percentage,
- total deaths by continent,
- percentage of the population infected per country,
- percentage of the population infected over time by country.
Insights
A few insights are mentioned below, though additional findings can be uncovered by changing the filters, as it is an interactive dashboard.
- European countries experienced the highest percentage of infections relative to their population and recorded the highest total deaths among all continents.
- Oceania (Australia and nearby regions) and Africa had the lowest infection rates relative to their population, along with the lowest total deaths as continents.
- The percentage of the population infected increased nonlinearly over time. Germany saw the highest increase, with the infection rate rising from 0% to 2.41% in the first year, and then jumping to 7.18% in the second year, demonstrating a sharp acceleration in the spread of infections.
For detailed visualizations and further insights, please check out the dashboard on Tableau.
Note: The data covers the period from 2020 to October 2021, so the insights reflect data only within this timeframe.