Project 1 - COVID-19 Vaccinations Trend Analysis

COVID-19 VACCINATION TREND ANALYSIS

I. AIM: The aim of this project is to get a detailed analysis on covid-19 vaccination trends by analyzing vaccinated people and fully vaccinated by year and country

II. INTRODUCTION: The data in this table gives information of country, dates of vaccinations, people fully vaccinated, people vaccinated, total vaccinations etc. Our main objective is to analyze the data on covid 19 vaccinations through analysis of data and take out some important insights through it

III. Problem statement: we will find out some answers of following question like how many people are completely vaccinated, what is total vaccinations by each tear and the by country, Top 10 and Bottom 10 countries by people vaccinated and people fully vaccinated etc.

IV. Methodology:

Step 1: Data cleaning and Data Interpretation

 Firstly, I loaded data by name covid_vaccinations then loaded data by using power bi transform data option the data was not cleared and consist of null values so i cleaned the data which was not useful

 The dataset was almost clear and completed. I replaced the null values with 0.

 There are total of 86512 rows and 15 columns

Step 2 : Visualization

 In visualization, I took the help of Power Bi desktop software to make graphs and charts here some relevant graphs and charts here some relevant graphs and charts are attached

V. Analysis:

Ø In analysis I found some insights through the following graphs and visualization

Ø Card of count of country, sum of people vaccinated, sum of people fully vaccinated, sum of total vaccinations

Ø Map of country wise for total vaccination and total vaccination per hundred by country and vaccines

Ø Top 10 countries by daily vaccinations, people fully vaccinated

Ø Bottom 10 countries by people fully vaccinated

Ø Sum of people vaccinated by date

Ø Heat map of total vaccination per hundred by country

Ø Pie chart of daily vaccination by country, card for top 1 country by sum of total vaccination and a donut chart for total vaccination by country with top country by total vaccination card

Ø Comparisons graph by Area chart for sum of people fully vaccinated and sum of people vaccinated by country

Ø A slicer for year, month date

VI. Insights:

Ø We have found out the top 10 and bottom 10 countries by people fully vaccinated

Ø Top country by daily vaccination and total vaccination

Ø We have found of sum of people vaccinated year and month wise

Ø Number 1 country by total vaccination and daily vaccination

VII. Recommendations:

Ø We can collect some more accurate dataset for analysis

Ø We can work on larger dataset and analyze them with the proper format of charts

VIII. Conclusions:

Ø We can see in the reports the top countries vaccination wise

Ø Top country by the vaccination in daily.

Ø Vaccination rise in 2022

I have attached Word file, Power bi file and power point presentation