Project 1 - COVID-19 Vaccinations Trend Analysis

Detailed Documentation:

Aim:

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

INTRODUCTION:

The main objective of this project is to analyse 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 data set was not cleaned and included some missing values, so with the help of the duplicates function in power BI, cleaned the data and replace the null values with 0 and then started working on it.

Data Interpretation:

In this data interpretation step, I found out some important about the data set.

* The dataset was almost clear and completed.

* I replaced the null values with 0.

* There is total of 86512 and 15 columns.

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:

In observation found some interesting points that are mentioned below.
• According to data on people fully vaccinated in the year.
• The dataset available is from 2020 to 2021.
• Total vaccination by the country in map visualization.
• Total Highest vaccination is 724475030489 in 2021.

• Total maximum daily vaccination is 13070714 in China.

• Total Highest people fully vaccinated is 115744439302 in India.
• Highest number of vaccinations by the source name is the Ministry of Health is 7.48K.
• Top 5 countries with fully vaccinated:
• Top 5 total vaccination in the countries:
• Total vaccinations by county and vaccines.

• Top 5 Countries where most people are vaccinated.

Insights:

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

Recommendations:

• We can collect good datasets for analysis.
• We can analyse 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 analyse 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 5 countries with our vaccines. Vaccination peeks in 2021. The Top 2 vaccine sources are India, and China.