Day 3 of 30: Tableau Project

I didn't get the chance to finish my project and post it yesterday, so today I'm posting day 3 and 4 on the same day.

For Day 3 of the 30 day challenge, I worked on Alex Freberg's Youtube Tableau Project. I am very satisfied and pleased with my final dashboard.

Technical Breakdown:

- bit.io for SQL queries

- XLSL files

- public.tableau.com

I used the following SQL queries in bit.io to export XLSX files.

Query 1:

SELECT SUM(new_cases) as TotalNewCases, SUM(new_deaths) as TotalNewDeaths,

((SUM(new_deaths)::numeric)/(SUM(new_cases)::numeric))*100 as deathpercent

FROM "covid_deaths"

WHERE new_deaths > 0

ORDER BY 1;

Query 2:

SELECT location, SUM(new_deaths) as TotalDeathCount

FROM "covid_deaths"

WHERE continent is null

and location not in ('World', 'European Union', 'International', 'Low income', 'Lower middle income', 'High income', 'Upper middle income')

GROUP BY location

Order by 2;

Query 3:

SELECT location, population, max(total_cases) as highestinfectioncount,

max(((total_cases::numeric)/(population::numeric)))*100 as infectionrate

FROM "covid_deaths"

WHERE continent is not null

GROUP BY location, population

HAVING max(((total_cases::numeric)/(population::numeric)))*100 > 0

ORDER BY 4 desc;

Query 4:

SELECT location, population, date, max(total_cases) as highestinfectioncount,

max(((total_cases::numeric)/(population::numeric)))*100 as infectionrate

FROM "covid_deaths"

WHERE location in ('Italy', 'United States', 'China', 'United Kingdom', 'India')

GROUP BY location, population, date

ORDER BY 5 desc;

Bit.io has an export limit of 5000 rows which made the data figures way off on the 4th chart. I pulled information from the countries Italy, USA, China, UK, and India to do the comparisons. Like Alex said in his video, it's purely a decision of interest. These aren't the countries with the most cases nor most percentage.

I made 4 charts to put in the final dashboard.

https://public.tableau.com/app/profile/brittany.brown7308/viz/COVIDProject_16591645046720/Dashboard1#1