Using SQL to gain insights about COVID-19 disease in the period from 1-1-2020 to 30-4-2021. The data is imported from 2 excel files: CovidDeaths and CovidVaccinations.
The data analysis process included the following:
- Looking at the number of total COVID cases and total COVID deaths in egypt
- Looking at countries with highest infection rate compared to population
- Looking at countries with highest death count for each country
- Looking at each continent's highest death count
- Looking at the new cases, new deaths, and death percentage for everyday across the world
- overall total cases and total deaths across the world
- Total Population vs Vaccinations