Project 1 - COVID-19 Vaccinations Trend Analysis

Project 1 : Covid -19 Vaccinations Trend Analysis

Aim:

To analyze the data in detail on vaccinated people and fully vaccinated people based on Country and Year .

Introduction:

Due to Covid (Corona), the number of people death rate increasing day by day. This virus is easily attacking those who don’t have essential immunity power. So, to increase the immunity power vaccination is introduced and injected to the people across the worldwide. We are going to analyse the vaccinated people, fully vaccinated people based on the countrywise and yearwise. So it will easy to find out which country people is not taking the vaccination properly and taking it in good manner, through this analysis we can make awareness to that particular country people to take the vaccination.

Problem Statement:

Find out the which country and in which year the people is not taking the Vaccination properly.

Methodology:

1. Data Cleaning

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.

2. Visualization

In visualization, I took the help of Power BI Desktop software to make graphs and charts.

Analysis ( Data sheet pertaining to it ):

• Totally we have 223 countries in data. Out of 223 countries only 40 countries were responded and took initiative to take vaccination in 2020 .(i.e People vaccinated from 40 countries only).
• Likewise in 2021, people in all 223 countries were come under vaccinated list and in 2022, again only 214 countries people were vaccinated.

• So through the analysis we can find that in the year 2021 the vaccinated country is increased but again in 2022 it slighltly decreased. See the image below.

• Now we can analyse in which country and in which year the people is in less percentage(least) in Vaccinated people list.
• In Cost Rica Country only 18% people were vaccinated in 2020, so we have to take more initiative for that country.

• In Pitcairn country only 1% people were vaccinated, likewise in Tokelau country only 8% were vaccinated in the year 2021

• In Niue country only 1% people were vaccinated, likewise in Nauru country only 15% people were vaccinated in the year 2022

• Now we can analyse in which country and in which year the people is in less percentage(least) in Fully Vaccinated people list.
• In Latvia country only 4% people were fully vaccinated, likewise in Denmark & Czechia country only 7% people were fully vaccinated in the year 2020.

• In Pitcairn country only 1% people were fully vaccinated, likewise in Tokelau country only 8% people were fully vaccinated in the year 2021.

• In Niue country only 1% people were fully vaccinated, likewise in Nauru country only 14% people were fully vaccinated in the year 2022.

Insights:

• According to our analysis, the people in some countries are not even vaccinated and fully vaccinated.
• The percentage is increased in 2021 when compared to 2020 but again in 2022 the percentage is decreased slightly.
• Even if countries in vaccinated list, the people is not vaccinated upto 100 %.

Recomendations:

• Government in each country should take initiative to make awareness.
• It should instruct people that ‘Vaccination is must’ , so there is possible that every people will vaccinated.
• Countries which is not involved in vaccination should be condemn by WHO and UNO.
• Several measures should take to give free vaccination.

Conclusion:

According to analysis we need to find the countries which are taking vaccination seriously and instruct them to do it. It will help the people to save their life from death. “ HEALTH IS WEALTH ” so for the good health, good precaution is needed, for that we have to take Vaccination.