Recent Covid-19 Vaccine Trends Dashboard Using Tableau and SQL Queries

Motivation

Covid-19 is a terrible and deadly virus that has wreaked havoc over the world over the last 3 years. Thanks to the brilliant and diligent work done by researchers throughout the world to create a vaccine and the companies and governments that facilitated the administration of the vaccine, the number of infections, hospitalizations, and deaths reduced dramatically leading us as a world to be able to enjoy day to day life again. With the initial vaccine coming out a few years ago I wanted to look and see how not only the United States did when it came to vaccinations but how countries around the world did and how they compare. Additionally, I wanted to look at how each state in the United States compared when it comes to vaccinations. To use the interactive dashboard of both the worldwide trends and United States trends click here

Code

SQL queries for worldwide dashboard

–-Removing unneeded row

DELETE

FROM VaccineData..WorldVaccine

WHERE Country IN ('World', 'iran')

**--Getting total amount of vaccination in the world **

Select SUM(Doses_Administered) AS Total_Vaccines

FROM VaccineData..WorldVaccine

--country with the least amout of vaccines given per capita

Select Country, Doses_per_1000

FROM VaccineData..WorldVaccine

WHERE Doses_per_1000 != 0

ORDER BY Doses_per_1000 DESC

--country with the most amount of vaccines given per capita

Select TOP 1 Country, Doses_per_1000

FROM VaccineData..WorldVaccine

WHERE Doses_per_1000 != 0

ORDER BY Doses_per_1000 DESC

-- AVG amout of vaccines given per capita

Select AVG(Doses_per_1000) AS Avg_Vac_Per_Capita

FROM VaccineData..WorldVaccine

WHERE Doses_per_1000 != 0

--Percent of world vaccinated by country

Select Country, AVG(Fully_Vaccinated_Population) AS Percent_World_Vaccinated_By_Country

FROM VaccineData..WorldVaccine

WHERE Fully_Vaccinated_Population != 0

Group by Country

--Trend of fully vaccinated per month by continent per 100

--Asia

SELECT continent, date, people_fully_vaccinated_per_hundred

FROM VaccineData..DailyVaccine

Where continent = 'Asia'

--NA

SELECT continent, date, people_fully_vaccinated_per_hundred

FROM VaccineData..DailyVaccine

Where continent = 'North America'

--SA

SELECT continent, date, people_fully_vaccinated_per_hundred

FROM VaccineData..DailyVaccine

Where continent = 'South America'

--Europe

SELECT continent, date, people_fully_vaccinated_per_hundred

FROM VaccineData..DailyVaccine

Where continent = 'Europe'

--Africa

SELECT continent, date, people_fully_vaccinated_per_hundred

FROM VaccineData..DailyVaccine

Where continent = 'Africa'

--Oceania

SELECT continent, date, people_fully_vaccinated_per_hundred

FROM VaccineData..DailyVaccine

Where continent = 'Oceania'