Project 1 - COVID-19 Vaccinations Trend Analysis

COVID-19 Vaccinations Trend Analysis

• Aim

The aim of this project is to analyse the data in detail on vaccinated people and fully vaccinated people by different countries from 2020 December to 2022 December.

• Introduction

The Covid-19 pandemic is the most crucial health disaster that has surrounded the world for the past year. Predicting the COVID-19 vaccination trend has become a challenging issue. Many health professionals, statisticians, researchers, and programmers have been tracking the spread of the virus in different regions of the world using various approaches. The rise in various vaccines developed by talented scientists spurred curiosity about learning more about ongoing vaccine programs and a keen interest in finding meaningful insights from data.

The main objective of this project to analyse 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 Vaccination data set the first column is Country which contains different countries names which are vaccinated.

The iso code column of data set contains iso codes for respective countries.

Remaining columns are 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. All this columns contains the information about 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 process the next step is Data interpretation. I interpret some information

The data set was almost clean and completed.

Replace the Null values with 0

There is a total of 86k 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 (Data sheets pertaining to it)

From the above Visualization some of the observations are

Among all countries the first place for total Vaccinated people are present in China.

The Dataset is available for years 2021 and 2022.

• countries participated in Vaccination.

In the year 2021 total Vaccination completed is 60.79%.

In the year 2022 total Vaccination completed is 39.2%.

China, India, the United States, Brazil, Indonesia, Germany, United States, Turkey, France, and England are the top 10 countries completed the full Vaccinations.

• Insights

The trends and patterns are presented as visuals.

Insights are available for visuals on dashboards, visuals in reports, and entire report pages.

• Recommendations.

We can extend the usage of this dataset by comparing the number of deaths before people taking vaccines vs after taking vaccines to check the effectiveness of each vaccine in each country.

• Conclusions

China and India are the two countries where 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 are the top 10 countries completed the full Vaccinations.