An exploratory data analysis and visualization done on the world wide recorded Covid-19 Dataset.
Practiced a wide range of SQL queries including Aggregate Functions, Joins, Window Functions, CTEs, and Views.
Queries: https://github.com/DablewCodes/Covid-Dataset-Analysis/blob/main/Quries.sql
Visualization: https://public.tableau.com/views/CovidAnalysis_16806876047600/Dashboard1
This project was created by following this tutorial: https://www.youtube.com/watch?v=QILNlRvJlfQ&list=PLUaB-1hjhk8H48Pj32z4GZgGWyylqv85f&index=6
Technologies used:
• BigQuery/SQL
• Excel
• Tablaeu
Analysis Process:
• Download the dataset
• Split into vaccination and Death data
• Import to BigQuery
• Analyze using SQL
• Save views in excel files
• Import views to Tableau
• Create Visualization