Exploratory data analysis is an approach to analyzing data sets to summarize their main characteristics, often using statistical graphics and other data visualization methods.
Link to Code
https://github.com/rrizwan43/PortfolioProjects_SQL_data_explorations
Tools and Techniques
1. SQL server Management Studio.
2. My SQL
3. Tables Joins / Relationships
4. Data Cleaning
5. Data Modeling
Tasks
1. Total cases, deaths & population by country.
2. Total cases, deaths & population for your country.
3. Total cases Vs population (percentage of the population got infected)
4. Countries with the highest infection rates.
5. Countries with the highest infection rates compared to the population.
6. Countries with the highest death count per population.
7. Calculate the above KPIs by continent.
8. Total cases and total deaths per day and percentage.
9. Total cases and total deaths and overall percentage.
10. Joining tables of covid deaths and covid vaccinations.
11. Total Amount of people who got vaccinated by country.
12. Use CTEs.13. Use temp tables.
14. Now create views to store data for later visualization.