Project 1 - COVID-19 Vaccinations Trend Analysis

Covid-19 Vaccination

Aim:

This project aims to analyse data in detail on vaccinated peoples based on country and year and fully vaccinated people by country in 2021-2022.

Introduction:

In this project it shows total vaccinated peoples. And also shows source names, daily vaccinated people’s details and also shows a website detail. Through the analysis of data, we can find the total vaccinated details. The main objective of this project is to analyse data in covid vaccination details.

Problem Statement:

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 analysis has become a challenging issue.

• We can find out how many peoples are daily vaccinated.
• Total vaccinations by each year.
• See the number of peoples vaccinated per hundred.
• See how many peoples are fully vaccinated based on country.
• We can see the vaccinated peoples based on daily updates.
• See what are all the different vaccines are there.

Methodology:

In the country, it represents which are all countries are vaccinated. And also shows the iso code. And it represents the total vaccinations, people fully vaccination, daily vaccinated, and shows how many people are vaccinated in different country.

Data Pre-Processing and Cleaning:

In this step first we clean the data with the help of power query editor. We clean the data in a particular manner like, use first row has header, replace the duplicate values and also arranging the data in specific format. And also, some missing values. In this we can clean the data.

Data Interpretation:

After cleaning the data, we can add the data into power bi with the help of close and load option in power query editor. In data interpretation found some important information. In this data we can replace null values with 0.

Data Visualization:

In visualization, with the help of power bi desktop software to make graph and charts and also calculates sum of all vaccinations based on the different criteria. Criteria based on country or and also iso code. And also see the data model.

Here some relevant graphs and charts are attached:

Sum of total vaccinations by country:

Total number of country and source name:

Total vaccination by year:

Country list:

Total daily vaccinations per million by country:

Total count of vaccines:

Total vaccinations per hundred by country:

Total people fully vaccinated by country:

Dashboard:

Analysis:

• From the above visualization find some points.
• The dataset is available for 2021 and 2022.
• The total of 223 countries presents in vaccination.
• In 2021 total 60.79% vaccination completed.
• In 2022 total 39.2% vaccinated completed.
• Total 81 source names are present in given data.
• China, India, United states are top countries completed the vaccination.
• Top 10 countries where most people are vaccinated.

Insights:

• In conclusion, we can take a look at the final report for further analysis.
• Countries by fully vaccination.
• See the top 10 sources.

Recommendations:

• We can perform operations with various categories.
• We can collect good dataset for analysis.
• To analyse the data for more effective and create proper format of the chart.
• We can analyse the data of the overall world.

Conclusions:

In China and India in these two countries, most people are vaccinated. In this project we can see the how many peoples are vaccinated. And understands daily vaccination, fully vaccination peoples, total vaccination per hundred and total vaccinations per million.