Project 1 - COVID-19 Vaccinations Trend Analysis

WORD FILE IS NOT GET ATTACHED I THINK THERE IS SOME BUG IN THIS WEBSITE I HAVE COPY PASTED THE CONTENT IN THE WORD FILE IN THIS TEXT BOX

COVID-19 Vaccinations

Trend Analysis

Table of contents

o Aim
o Introduction
o Problem statement
o Methodology
o Analysis (Data sheets pertaining to it)
o Insights
o Recommendations.
o Conclusions

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: 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 (Data sheets pertaining to it):-

1.) In this graph count of people vaccinated for every country each year and month in drill down heirachy has been shown

2.) Total vaccination by the country in map visualization

3.) This graph contains the max country vaccinated in the year and month wise manner are mentioned and propagated accordingly

4.) In this highest number of vaccinations delivered by which organisation is founded and it is mentioned below

source_name Sum of total_vaccinations

National Health Commission 7,09,45,26,63,700.00

5.) In this graph we have been shown the country which is daily vaccinated in a funnel chart

6.) In this top 10 counties with daily vaccines per million is shown using the bar graph

7.) In this we have plotted the top 10 countries with people fully vaccinated and people full vaccinated per hundred in the line chart

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.

Recommendations:-
• 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.