• Performed exploratory data analysis on COVID-19 datasets using SQL queries to identify trends. • Calculated death percentage rates by location over time to assess the pandemic impact. • Identified countries and continents with the highest COVID-19 death counts. • Analyzed the correlation between total cases and population to determine the percentage infected. • Computed rolling count of vaccinations and percentage vaccinated by location. • Created CTEs and temporary tables to handle complex analytical queries. • Visualized pandemic trends and KPIs using charts and dashboards. • Identified the highest infection rates and death counts globally to prioritize response. • Compared vaccination rates versus population over time to guide policy decisions. • Used SQL joins aggregations and window functions to analyze large datasets.
-
Notifications
You must be signed in to change notification settings - Fork 0
ASHISHRANJAN95/Covid-19-Data-Exploration-SQL-project
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
COVID-19 Data Analysis and Visualization (MySQL, Tableau)
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published