D.F.

Covid19 Data Visualization

Blue image of a virus cell.

Infection and death information

Tableau Public Viz

Summary:

This is the visualization of my exploration into Covid infections and deaths data. It consists of a table, a bar graph, an interactive heat map, and a line graph with predictions. I followed the Alex the Analyst YouTube video to complete this project. In the future I plan on exploring the data further to view how different comorbidities affected a patient's outcome.

Data Source:

Our World in Data website (August 22, 2023).

Skills & Programs Used:

  • Tableau
  • Data Visualization

Process

Gather Data

Get data from data tables in BigQuery using SQL and export as MS Excel spreadsheets.

Create Tableau Sheets

Using the saved Excel tables, create graphs in Tableau sheets.

Create Tableau Dashboard

Place the graphs created on each sheet onto a dashboard.

Publish Dashboard

Publish the finished dashboard to Tableau Public.

Results

This is the resulting dashboard created on Tableau Public that displays Covid19 death and infection information. On the left side it shows the total cases, total deaths, and deathpercentage as a table and a bar graph of the total death count for each continent. On the right side, an interactive map showing the highest percent of a country's population infected. At the bottom a line graph shows the percent of the population of four countries infected by month from November 2019 to July 2023. The line graph also includes predictions (shaded area) for the next year.

As seen on the varous charts, the areas with the highest infection and death rate from Covid19 were Europe, Asia, and North America. At the end of August 2023, the total number of Covid19 cases was 769,789,653 and the death rate was 0.90%.

Covid19 dashboard showing the total cases, total deaths, death percentage in the top left. A bar graph of the total death count for each continent in the mid left section. An interactive map showing the highest percent of a country's population infected in the top right. A line graph of the percent of the population infected by month from November 2019 to July 2023.

Future Posibilities

  • Check for any updates to data.
  • Visualize how much of the population on each continent was infected.