Project 1 - COVID-19 Vaccinations Trend Analysis

PowerBi Project on COVID-19 Vaccinations Trend Analysis

Aim :-

This project aims to analyze data in detail on vaccinated people and fully vaccinated by year and country.

Introduction :-

The main objective of this project is to analyze the data on, COVID-19 Vaccinations. Through the Analysis of data, we can find out some important insights.

Problem Statement :-

• We can find out how many people are completely vaccinated.
• Total vaccinations by each year and then by country. In this analysis, we can see the number of people vaccinated per hundred.

Methodology :-

Step 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.

Step 2 :- Data interpretation
In this data interpretation step, I found out some important information about the data set.
• The data set was almost clear and completed.
• I replaced the null values with 0.
• There is total of 86512 rows and 15 columns.

Step 3 : data visualisation
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 :-

In observation found some interesting points that are mentioned below.

***The dataset available is from 2020 to 2021***

1. Sum of people fully vaccinated by the country

(Refer the PAGE 1 IN PBIX file )

• India is the highest fully vaccinated country in the world according to the chart .

2. Top 10 countrys fully vaccinated

(Refer the PAGE 1 IN PBIX file )

• India is the top one country with the count of 116436445K fully vaccinated population in the world .

3. Daily Highest Vaccinations by the country .

(Refer the PAGE 3 IN PBIX file )

• China is the top in daily vaccination with count of 3250342k where mexico is the lowest in the daily vaccination comparing to other countrys

4. Highest Number of vaccination by the source name

(Refer the PAGE 4 IN PBIX file )

• Highest number of vaccinations by the source name is the Ministry of Health is 7.41K.

5. Highest vaccination according to the year 2020,2021 and 2022.

(Refer the PAGE 5 IN PBIX file )

• In the year year the 2020 the total daily vaccination is 8708k and in the year 2021 the vaccination done is 922313k and 2022 the count is 2088398k
• In the year 2021 the highest daily vaccination is held with the count of 922313k

6. Sum of people vaccinated by the country

(Refer the PAGE 6 IN PBIX file )

• In india high number of people are vaccinated with the count of 205819738k.

7. Top 10 vaccines by the country

(Refer the PAGE 7 IN PBIX file )

• These are the top 10 vaccines according to there result and sinopharm/Beijing,Sputnik v is the top 1 vaccine in the comprision of world.

Insights :

• 
  In conclusion, we can take a look at the final Report for further analysis.
  • We can see the top 10 sources.
  • Countries by fully vaccination etc.

Recommendation :

• We can collect good datasets for analysis.
• We can analyze the data of the overall world.
• Like this dataset we can perform operations with various categories, city-wise or region-wise.
• We can work on large datasets and analyze them with the proper format of the chart.

Conclusion :-

In conclusion, we can take a look at the final Report for further analysis.
As we can see in the Report the top countries vaccination-wise, Top Country by the vaccination in daily and best top 10 countries with our vaccines. Vaccination peeks in 2022. The Top 2 vaccine sources are India, and China.