The purpose of this project is to analyze Covid-19 situation worldwide. Data for this project is taken from OurWordlInData.🎇
After downloading the data, I imported it into pgAdmin for analysis. Upon running simple queries on my main table, I noticed that there were a lot of repeating strings in the columns. Repeating strings increases the size occupied by the data, and slowers the processes of the database.🎡
Next up, I normalizaed the database by creating tables for location, iso_code and continent and linked it to the main my main table. This way, I was able to get rid of repeating strings in my database. 📅
The queries.sql file contains all the SQL queries for this project.
This SQL client used is PostgreSQL.🐘
The final visualization created with Tableau is below. Link to the dashboard.
