Project 1 - COVID-19 Vaccinations Trend Analysis
Project 1 - 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: -
In this Country vaccination dataset we can't analyse the percent of people vaccinated on each country because of no data about total population even we have data of people vaccinated per million and people vaccinated per hundred.
Methodology:-
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, I cleaned the data and replace the null values with 0 and then started working on it.
Data Visualization:
Creating Measure Sum of people vacinated and people fully vaccinated and total vaccination by using Cards visualiz in dashboad
Creating matrix visualization of people vaccinated and people vacinated per million according to each country and doing conditional formatting for visulize higher vacciated people to lower vaccinated of each country
Add a slicer for date column like an slider view
Add a map view to show the whole wolrd view in single page according do totalpeople vaccinated each country and bubble size differentiate the highest and lowest vaccinated countries and according to vaccines
Next line Chart with date hierarchy with drill down filter options and also use Edit interactions in this line chart other cahrt are not filter while drill down this line chart
Below matrix visuaization shows that each Organisation supplies the vaccination to how many countries ?
Analysis (Data sheets pertaining to it)
In observation found some interesting points that are mentioned below.
- The dataset available is from 2020 to 2021
- Total vaccination by the country in map visualization.
- Total Highest Daily vaccination is 9223133948 in 2021.
- Top 10 countries with fully vaccinated
- India has highest fully vaccinated people
- according to population highest fully vaccinated country is China
- World Health Organisation is provides highest number of countries
Insights: -
We can see the current scenario of the vaccinations details by using each chart.
Top 20 Countries vaccinated on daily basis, ratio of fully and partially vaccinated against total vaccinations produced.
Top 10 countries vaccinated count and types of vaccine used by each country.
Total vaccinations against total vaccinations per hundred and top5 vaccines produced from total vaccines.
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.
Conclusion: -
We can conclude that China and India are the two topmost countries vaccinating daily on the regular basis across all the analysis. Pfizer/BioNTech, Sinopharm/Beijing is the vaccine used by the maximum countries and less than 30% of vaccines only vaccinated against the total vaccines produced. Finally to avoid the Covid spread the necessary actions need to be taken to give the awareness of the vaccines.