Project 1 - COVID-19 Vaccinations Trend Analysis

Project 1 - COVID-19 Vaccinations Trend Analysis

Aim The aim of this project is to analyze the data in detail on vaccinated people and fully vaccinated people by country in 2021-2022 Introduction Since the start of the COVID-19 outbreak, WHO has worked with countries and areas in Different regions on public health measures to slow or stop the spread of the virus. Safe…

Aim

The aim of this project is to analyze the data in detail on vaccinated people and fully vaccinated people by country in 2021-2022

Introduction

Since the start of the COVID-19 outbreak, WHO has worked with countries and areas in Different regions on public health measures to slow or stop the spread of the virus.

Safe and effective vaccines are an important tool, in combination with other measures, to protect people against COVID-19, save lives and reduce widescale social disruption.

The main objective of this project to analyze Covid – 19 Vaccination data and find out some important insights.

Problem Statement.

In this project, we find out in Different Countries how many people are Vaccinated or fully Vaccinated in 2021 and 2022 and also find out how many people in different countries have completed Daily Vaccinations, Total Vaccination per hundred, People Vaccination per hundred, and Daily vaccinations per Million.

Methodology

• In the Country, Vaccination data set the first column is that Country in country column presents different countries.
• In the iso code column containing the iso code for the country. and In the data set contain a date for Vaccination.
• Another column is total Vaccination, People Vaccination, People fully Vaccination, Daily Vaccinated raw, Daily Vaccinations, Total Vaccinations per hundred, people Vaccination per hundred, People fully Vaccinated per Hundred, and Daily Vaccination per million in all columns Show how many people are Vaccinated in different criteria.

• The first step is cleaning the data. In data cleaning I cleaned the data with the transform data option present in Power BI because the dataset was not cleaned and included some missing values, so with the help of the duplicates function in Power BI, I cleaned the data and replace the null values with 0 and then started working on it.

• After Data cleaning performs the Data interpretation step. In Data interpretation found some important information.

• The data set was almost clean and completed.
• Replace the Null values with 0
• There is a total of 8513 rows and 15 columns is present.

Visualization

In visualization, I took the help of Power BI Desktop software to make graphs and charts here some relevant graphs and charts are attached. 

Analysis

From the above Visualization find some interesting points that are mentioned below

• China is the number 1 Total Vaccinated people are present
• The Dataset is available for 2021 and 2022.
• The Total of 223 Countries participated in Vaccination.
• IN 2021 Total Vaccination is 60.79% completed.
• In 2022 Total Vaccination is 39.2% is completed.
• China, India, the United States, Brazil, Indonesia, Germany, United States, Turkey, France, and England There are the top 10 countries is completed the full Vaccinations.
• Top 10 countries fully vaccinated India Tops
• Sum of Total vaccinations versus sum of the people vaccinated there is vast difference. More data will give insightful information. It could include Booster dose, First vaccination, second vaccination. It cannot conclude entire population has been vaccinated at least once.
• Top 10 countries based on Sum of total vaccinations versus number of people vaccinate and vaccinations left gives us insight into how many actually got vaccinated and how many are available. Countries like China and India are highly populated and how much unfinished work is left is seen.
• Sum of Daily vaccinations raw versus sum of daily vaccinations the graph show slight difference since actual records vary slightly.

Insights

• In conclusion, we can take a look at the final Dashboard for further Analysis.
• We can see the top 10 Sources
• We can see bottom 10 sources

Recommendations

• We can analyze the data of the overall world.
• We can get which vaccine was sought after and trends.
• We should get the dataset of People with First vaccine, second vaccine and third vaccine after booster dose. This would give exact figure of people at least vaccinated once.
• We can get dataset of health of people after fully vaccinated.
• Like this dataset, we can perform operations with various categories, city-wise, or Region wise.
• We can analyze the data with the proper format
• We can collect good datasets for more effective analysis by using charts.

Conclusion

In Conclusion, we can take look at the Dashboard for further Analysis.

• In China and India in these two countries, most people are Vaccinated.
• In 2021 60.79% of people are fully Vaccinated and in 2020 only 39.2 % of people are fully Vaccinated.
• China, India, the United States, Brazil, Indonesia, Germany, the United States, Turkey, France, and England There are the top 10 countries is completed the full Vaccinations.