Domain : Healthcare and Public Health
Function : Explore, Analyze and Visualize
Problem Statement:
The COVID-19 pandemic has been one of the most significant global crises in recent history. Governments, healthcare providers, and researchers worldwide have been gathering data on the pandemic's impact, which has led to a wealth of COVID-19 data. In this project, we will explore COVID-19 data using MS SQL to understand the pandemic's impact on various aspects of society.
Objective:
Analyze COVID-19 data to gain insights into the following areas:
- The spread of COVID-19 across different countries and regions
- The impact of COVID-19 on public health, such as the number of cases, deaths, and recoveries
- The effectiveness of various measures taken to contain the spread of COVID-19, such as lockdowns, travel restrictions, and vaccination programs
Methodology :
The Methodology involves the following process;
- Importing data: COVID-19 data from the World Health Organization database into MS SQL.
- Data cleaning and transformation: We cleaned and transformed the data removing errors, inconsistencies, or missing values.
- Data analysis: Written SQL queries to explore the data and gain insights into the impact of COVID-19 on various aspects of society.