| | |

Visualization of Covid-19 Data Using Tableau Public

Byadmin

Data Preparation

BigQuery was used to prepare the data for visualization in Tableau Public.

--Total death rate from Covid across the world
SELECT SUM(new_cases) as total_cases,SUM(new_deaths) AS total_deaths
FROM Covid.Deaths
WHERE continent IS NOT NULL
ORDER BY 1,2;
--Death counts by continents

SELECT location, SUM(new_deaths) AS total_deaths
FROM Covid.Deaths
WHERE continent IS NULL
AND location NOT IN ('World', 'European Union', 'International', 'High income','Upper middle income',  
'Lower middle income', 'Low income')
GROUP BY location
ORDER BY total_deaths DESC;
--Count of Covid infection by countries

SELECT Location, Population, MAX(total_cases) AS Highest_Infection_Count, (MAX((total_cases/Population))*100) AS Percentage_Population_Infected
FROM Covid.Deaths
WHERE location NOT IN ('World', 'European Union', 'International', 'High income','Upper middle income',  
'Lower middle income', 'Low income')
GROUP BY Location, Population
ORDER BY Percentage_Population_Infected DESC;
--Total infection count

WITH infect AS(
SELECT Location, ifnull(Population, 0) Population, date, ifnull(Highest_Infection_Count, 0) Highest_Infection_Count, ifnull(Percentage_Population_Infected, 0) Percentage_Population_Infected
FROM Covid.Infected
WHERE location NOT IN ('World', 'European Union', 'International', 'High income','Upper middle income',  
'Lower middle income', 'Low income')
)
SELECT *
FROM infect

Tableau Public Visualization

The visualization from Tableau Public has been embedded below. You can click the last button on the visualization’s bottom-right to view the full screen. Or click here to view it directly on Tableau Public’s website

Similar Posts

Starting Airbnb And Airbnb Cleaning Business In Copenhagen, Denmark
| |

Starting Airbnb And Airbnb Cleaning Business In Copenhagen, Denmark

Byadmin

Context Airbnb, as in “Air Bed and Breakfast,” is a service that lets property owners rent out their spaces to travellers looking for a place to stay. Travellers can rent a space for multiple people to share, a shared space with private rooms, or the entire property for themselves. Today, many people whose houses or…

Exploration of Covid-19 Data Using SQL
|

Exploration of Covid-19 Data Using SQL

Byadmin

Context The COVID-19 pandemic, also known as the coronavirus pandemic, is an ongoing global pandemic of coronavirus disease 2019 (COVID-19) caused by severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2). The novel virus was first identified from an outbreak in Wuhan, China, in December 2019. Attempts to contain it failed, allowing the virus to spread to…