Project 1 - COVID-19 Vaccinations Trend Analysis

COVID-19 Vaccinations Trend Analysis

table of content: -

• Aim
• Introduction
• Problem statement
• Methodology
• Analysis (Data sheets pertaining to it)
• Insights
• Recommendation’s.
• Conclusions

Aim

The aim of this project is to analyses 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 analyses 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.

Recommendations

We can analyse the data of the overall world.

Like this dataset, we can perform operations with various categories, city-wise, or Region wise.

We can analyse 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.