Flattening the Curve
COVID-19
ANALYSIS
Presented By : Mostafa Elkhouly
TABLE OF
CONTENTS
Presentation Outline
1. Overview
2. Objectives/Dataset
3. Exploratory Data Analysis
[Link] and Insights
[Link]
[Link]
OVERVIEW
Introduction to Case Study
The CORONA VIRUS pandemic has had a significant
impact on public health and has created an urgent
need for data-driven insights to understand the spread
of the virus. As a data analyst, you have been
tasked with analyzing a CORONA VIRUS dataset to
derive meaningful insights and present your findings.
OBJECTIVES
Identify Recommendations
Analyze
Analyze the trends and Identify factors influencing Provide data-driven
patterns of CORONA VIRUS the spread and severity of recommendations for
cases globally. the virus. mitigating the impact of the
pandemic.
Total Number of Confirmed Cases
80,121,099
Worldwide as of 2020
Total Number of Confirmed Cases
88,944,045
Worldwide as of 2021
DATASET
Columns Type Descriptio
n
Province nvarchar(50)
Geographic subdivision within a
country/region.
Country/ nvarchar(50)
Region
Geographic entity where data is recorded.
decimal(18,
Latitude 10)
North-south position on Earth's surface.
Longitude decimal(18,
10) East-west position on Earth's surface.
Date
date Recorded date of CORONA VIRUS data.
Confirmed
int Number of diagnosed CORONA VIRUS cases.
Deaths
smallint Number of CORONA VIRUS related deaths.
Recovered
int Number of recovered CORONA VIRUS cases.
DATA EXPLORATION
Using SQL (Structured Query Language)
For "Corona Virus Analysis" case study, conducting a
data exploratory analysis is crucial for understanding
the characteristics of the CORONA VIRUS dataset and
extracting meaningful insights.
CHECKING FOR MISSING VALUES
Total Null Values
0
No NULL VALUES WERE RECORDED
HANDLING MISSING VALUES IF EXISTS
Total Number of Entries
78,386
DATE DURATION
18 MONTHS
Starting Date Ending Date
2020-01-22 2021-06-13
WHAT IS DATE DURATION AND
NUMBER OF MONTHS PRESENT ?
Jan - Dec 2020
D 12 MONTHS
E 2021
Jan - June 6 MONTHS
WHAT IS AVERAGE CASES MONTHLY ?
(CONFIRMED, DEATHS, RECOVERED)
MOST FREQUENT VALUE PER MONTH ???
(CONFIRMED, DEATHS, RECOVERED)
MINIMUM AND MAXIMUM YEARLY ?
(CONFIRMED, DEATHS, RECOVERED)
MINUMUM MAXIMUM
TOTAL CASES MONTHLY ?
(CONFIRMED, DEATHS, RECOVERED)
MODE OF SPREAD IN TERMS OF
CONFIRMED CASES ???
(TOTAL , AVERAGE , VARIANCE & STDEV)
MODE OF SPREAD IN TERMS
OF DEATH CASES ???
(TOTAL , AVERAGE , VARIANCE & STDEV)
MODE OF SPREAD IN TERMS OF
RECOVERED CASES ???
(TOTAL , AVERAGE , VARIANCE & STDEV)
REGIONAL CASES
Country with Highest Confirmed Cases : Country with Lowest Death Cases :
United States :
33,461,982 Marshall Islands , Samoa , Kiribati , Dominica : 0
TOP 5 COUNTRIES HAVING
HIGHEST RECOVERED CASES ?
India is on the top with : 28,089,649
Insights and Findings
Highest # of Confirmed Cases Highest # of Death Cases
America have the highest number of confirmed cases America have the highest number of death cases over 2
Max # of Recovered Cases
over 2 years with a total of 33,461,982 having 13,361,738 Max # of Death Cases
years with a total of 599,769 having 247,564 cases in
in 2021 compared to 20,100,244 in 2020 2021 compared to 352,205 in 2020.
Maximum number of deaths takes place in the year
Maximum number of cases recovered in
2021 in India in Month of June with 7374 cases
2021 were 422,436 compared to 1,123,456 in
compared with the year 2020 in US in the Month of
the year 2020. December for 3752 cases
RECOMMENDATIONS
Localized Interventions
Enhance Health Awareness
Resource Allocation
Surveillance and Monitoring
CONCLUSION
The analysis of the CORONA VIRUS dataset has
provided valuable insights into the global impact of the
pandemic.
The findings highlighted US as country with highest
number of confirmed cases and highest number of
death cases over 2 years.
The findings highlighted maximum number of cases
recovered took place in 2020 while the maximum
number of deaths occur in 2021.
THANKYOU
Please don't hesitate to contact us
Phone Number
+201098442477
Email Address
mostafa.mohd96@[Link]