In this project I explored the Covid-19 Dataset from https://ourworldindata.org/covid-deaths. I utilized Excel, SQL and Tableau to clean, analyze and visualize the data to demonstrate the infection and death rates separated by country.

 

For the first part of the project I used Excel to reformat the data and to separate the data into two spreadsheets. One that will includes data for death rates and another for vaccinations.  I uploaded my CSV files onto PostgreSQL to clean and analyze the dataset to determine the death rate from Covid-19. 

​

I queried the data to find:

• Total Cases vs. Total Deaths using

• Total Cases vs. Population

• Countries with the Highest Infection Rate compared to Population

• Countries with the Highest Death Count per Population

• What Continent has the Highest Death Count per Population

• What is the Global Death Rate

• Percent Population Vaccinated

• United States Death Percentage

• Total Population vs Vaccinated

• Continental Death Rate

 

 

For the second part of the project, I created views and saved query results to upload into Tableau for data visualizations and a dashboard. To see these visualizations please click the link to Tableau.​