Project 1 - COVID-19 Vaccinations Trend Analysis
Project 1 - COVID-19 Vaccinations Trend Analysis
The Detailed Documentation of the Project should contain.
Aim:
Introduction:
Problem statement
Methodology
Analysis (Data sheets pertaining to it)
Insights
Recomendations.
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:
Data cleaning on the Dataset of Covid is not done, some of values are null .
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, 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.
Top 10 and Bottom 10 Total Vaccinations by Countries
Map-Country Wise Vaccinations:
Country which need Vaccinations:
Country based on Vaccine wise Daily vaccinations
Dashboard Report View of Total Vaccinations
Dashboard Report View of Total Vaccinations per hundred
Analysis (Data sheets pertaining to it):-
In observation found some interesting points that are mentioned below.
· Dashboard Created
· According to data on people fully vaccinated in the year.
· The dataset available is from 2020,2021,2022.
· Total vaccination by the country in map visualization.
· Total Vaccination By the date wise drill down
· Total Vaccination By the Country wise drill through to target page
· Total Highest Top 10 Country Daily vaccination
· Total Highest Top 10 Country People Fully Vaccinated
· Total Highest Daily vaccination is 3250342496 in China.
· Sum Of Total Vaccinations is 2002854013761.
· Sum Of People Fully Vaccinated is 548594310708.
· Sum Of Remaining People Fully Vaccinated is 1454259703053.
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.
• Based on country wise Population and covid infected persons we can make better Analysis on the dataset
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.