Covid-19 Analysis

Project Summary

The purpose of this project was to find out how was the spread of COVID-19 cases around the world for the period Jan 8, 2020 until Apr 30, 2021. This included the trends of the death cases and total vaccinations. The dataset used for the analysis is COVID-19 Deaths data which taken from Our World in Data. It contains information regarding numbers of COVID cases, deaths, and total of people who got the vaccine.

Project Background

The novel coronavirus, known as COVID-19, was first identified in Wuhan, China towards the end of 2019. Later on, on March 13, 2020, the World Health Organization (WHO) declared it a global pandemic. Following this announcement, the number of confirmed cases and deaths rose significantly in developed countries like the US, UK, and China, which will be closely examined in this analysis.

The tools:

  • Microsoft SQL Server Management Studio (SMSS)
  • Tableau

The steps:

  1. First, I downloaded the CSV files from the website.
  2. Using the SQL Server, those 2 raw dataset were merged and cleaned to make sure the data is feasible to be analyzed.
  3. Explored the data and chose the information that will be utilized for vizualization.
  4. Created VIEW and exported the saved VIEW into cleaned CSV file.
  5. Connected to cleaned CSV using Tableau
  6. Created dashboard on Tableau to visualize the result.

Project Files

For more comprehensive analysis and visualization, please open these files:

Insights

According to the analysis, I identified that:

  1. During this period, total cases had reached around 150M until April 2021.
  2. In terms of the distribution of COVID19 cases, US had the most new cases among other countries with around 32 million cases, followed by India and Brazil.
  3. However, it is found that Europe had the most death cases related COVID19. It is followed by North America and South America.
  4. Regarding the vaccination, there were 946 million people had been vaccinated during this period. From February 2021, there were significant increase of new vaccination in Asia. In April 2021, about 257 million vaccinations held in this continent.