TestimonyAdeyemi/DS-Project-6-COVID-19-in-Africa-Analysis
Domain:
healthcareCreator:
Tes
Host:
Monitor COVID-19 trends from January 2023 to July 2023 in Africa.
### COVID-19-in-Africa-Analysis
**Monitor COVID-19 trends from January 2023 to July 2023 in Africa.**
It’s August 2023, and headlines and rumors are starting to fly around about a new wave of COVID-19. Being a data enthusiast, I wanted to see for myself. I decided to analyze the COVID-19 trends in Africa (where I live) and deduce if I have reasons to be concerned about a pandemic in the near future.
**Project Objective:** Monitor COVID-19 trends from January 2023 to July 2023 in Africa.
**Data Source:** ourworldindata.org
**Tools:** SQL, Excel, Tableau
## Data Exploration in SQL
Questions to answer with SQL:
**Total cases from January to July in Africa:** This query helped me analyze the COVID-19 trends in Africa during the specified time frame, allowing me to track the monthly total cases and draw meaningful insights from the data
```
--1. Total cases in Africa across January 2023 to August 2023
SELECT
CASE
WHEN MONTH(date) = 1 THEN 'January'
WHEN MONTH(date) = 2 THEN 'February'
WHEN MONTH(date) = 3 THEN 'March'
WHEN MONTH(date) = 4 THEN 'April'
WHEN MONTH(date) = 5 THEN 'May'
WHEN MONTH(date) = 6 THEN 'June'
WHEN MONTH(date) = 7 THEN 'July'
END AS Month,
SUM(new_cases) AS new_cases
FROM PortfolioProject..Sheet1$
WHERE continent='Africa' AND date BETWEEN '2023-01-01' AND '2023-07-31'
GROUP BY month(date)
ORDER BY month(date) ;
```
**2. Total cases in each African country:** This query provided me with the total cases for each African country during the specified time frame, enabling me to analyze how the pandemic has affected different countries in Africa. It’s a valuable piece of information for understanding the regional impact of COVID-19.
```
--2. Total cases in each African country across Juanry 2023 to August 2023
SELECT Location, SUM(new_cases) AS new_cases_Jan2023_to_Aug2023
FROM PortfolioProject..Sheet1$
WHERE Continent='Africa' AND date BETWEEN '2023-01-01' AND '2023-08-28'
GROUP BY location
```
**3. Total deaths from …