Project 1 - COVID-19 Vaccinations Trend Analysis

COVID 19 Vaccination

Aim :

This project aims to analyze people get fully vaccinated based on Country in 2021 – 2022.

Introduction :

In this project it shows people who are fully vaccinated and als shows daily vaccinated people’s details also shows website details. The main objective of this project is to analyze data in covid vaccinated people.

Problem Statement :

The Covid-19 pandamic is most crucial health disaster that was spread in the whole world in past years. Covid-19 vaccination trend analyses become the very challenging issue.

Ø We can find out how many people are daily vaccinated.

Ø Total vaccinations by each year.

Ø See how many people get vaccinated based on country.

Ø We see the vaccinated people based on daily basis.

Ø We see the number of people are fully vaccinated pr million.

Methodology :

In this it represented the country which are vaccinated and shows the total vaccination , fully vaccinated people , people get vaccinated on daily basis and also shows how many people get vaccinated on the basis of country.

Data Pre-processing and Cleaning

First, we clean the data with help of the power query editor. In power query editor we clean the data in a particular manner like changing the rows heading in specific format. We can use only those rows which we needed other rows we can hide or remove them , remove the duplicate values,

Then , we can add our data into power Bi desktop using close and apply option.

Data Visualization

In Visualization, with the help of power bi desktop software we make different graphs and charts and calculate the total vaccinations based on different countries.

Analysis :

The dataset is available for 2021-2022 Year.

Ø Total of 223 countries are present in this vaccination analysis.

Ø Top 10 countries where most of the people get vaccinated.

Ø Sum to daily vaccination are approx. 16 Million.

Ø Sum of total vaccinations are approx.. 5 billion.

Ø Sum of the people who are Fully vaccinated are approx. 2 billion.

Ø India, Indonesia, United States, Germany, Russia, Turkey, United Kingdoms, Brazil, England, France ae the top 10 Countries who completed the vaccinations.

Insights :

Ø In Conclusion, we can take a look on the final report for further analysis.

Ø Countries who are full vaccinated.

Ø Top 10 Countries

Recommendations :

Ø We can perform operations with various categories.

Ø We can collect the dataset for the analysis.

Ø To analyze the data more effectively and create graphs and charts with proper format.

Ø We can also analyze the data of all over the world.

Conclusions :

In India and China most of the people get vaccinated. In this project, we can see how many people are vaccinated and understands daily vaccinations, fully vaccinated people, total vaccinated people per million and also total vaccinations per million.