Coronavirus cases and deaths over a period of time

EDA with SQL using Microsoft SQL Server Management Studio and Data Visualization with Tableau Public

January 13, 2023 · 1 min read

Photo of Fusion Medical Animation at Unsplash

Covid-Portfolio-project

EDA with SQL using Microsoft SQL Server Management Studio and creating a Tableau Dashboard with multiple visualizations.

Dataset

The dataset used for this project was downloaded from Our World in Data.

It’s been divided in two separated Excel files to create two separate tables and link them using SQL queries on Microsoft SQL Server Management Studio.

Purpose

The purpose is to explore the data on Covid deaths and cases to get a global vue while also focusing in the figures of countries of interest (France - as it’s my country of residence, China, India, USA, UK).

Microsoft SQL Server Management Studio is a nice tool to create a database, add tables, and create SQL queries.

jpg

Sql views

After the exploratory queries on the data, I created a few SQL views. For example:

jpg

The different views can be seen in my Github repository Covid-portfolio-project

Tableau

Then I selected some of them to create a simple Dashboard in Tableau Public.

First I copied the results from a selection of queries/views into Excel. I uploaded each Excel sheet as a different table to Tableau Public. I created visualizations that in my opinion would be nice to get together in a dashboard.

Finally, I published the resulting Dashboard into Tableau Public.

jpg

You can have a look at and play with this Dashboard at my Tableau Public Profile.

← Previous Post