COVID-19 By the Numbers: A Case Study
This is an exploratory case study into publicly available COVID-19 data until June 2nd, 2021. During this case study, I used SQL to organize the data, create custom calculations, and create views for visualization in Tableau. The dataset I used is available here.
Primary Tools
SQL
After importing the raw data into Microsoft SQL Server, I ran queries to get to know the data. Then, I used custom calculations to create views for visualization. My SQL code is available in the GitHub repository below.
Tableau
To begin my visualizations, I first linked SQL Server to Tableau to get access to the custom views. Once imported into Tableau, I created a visual representation of the infection and death rates by country, and death and infection totals by country and continent. You can see the full interactive dashboard below hosted on Tableau Public.
