Data Analysis Projects

If you're interested in exploring the analysis I've conducted, feel free to download the SQL file below. It contains various queries I've crafted and answered to uncover patterns and trends within the data.

Download SQL file

If you want to download the dataset, download this file:

Download CSV

Conclusion and Insights from this Analysis

Confirmed Cases: There was a significant decrease in the maximum confirmed cases from 823,225 in 2020 to 414,188 in 2021...

Deaths: There was a notable increase in the maximum death cases from 3,752 in 2020 to 7,374 in 2021...

Recovered Cases: There was a significant decrease in the maximum recovered cases from 1,123,456 in 2020 to 422,436 in 2021...

Trend in Total Deaths: Total deaths increased significantly from January 2020, peaking in January 2021 with 401,893 deaths.After January 2021, total deaths decreased, reaching 132,657 by June 2021.

Average Deaths -: Average deaths per day increased consistently throughout 2020, peaking in January 2021.Post-January 2021, average deaths remained high but showed a decreasing trend by June 2021.

Peak Months January 2021: Highest total deaths (401,893) marking the peak of the pandemic followed by April and May 2021 total deaths (362,387 and 366,549) with significant daily fluctuations.