Project 1 - COVID-19 Vaccinations Trend Analysis
Aim:
The main aim of the project is to detailed analysis of the Covid-19 vaccination analysis based on the peoples in country and year.
Introduction:
The objective of the project to convey the analysis of different vaccination programs around the globe by using the dataset to track the vaccination analysis and track highest vaccination peoples around the country and based on the date.
Problem Statement:
The covid-19 pandemic is the most crucial health disaster that has surrounded the world for the past year. predicting the covid-19 vaccination trend analysis has become a challenging issue. many health professionals have been tracking the spread of the virus in different regions of the world using various approaches. In this project we track and analyse the vaccinated and fully vaccinated people in the different countries based on the date how many countries are completed the daily vaccinations and also different categories of the vaccinations we analyse these data using covid-19 vaccination trend analysis dataset.
Methodology:
1.Data Pre-processing & cleaning:
In data pre-processing it is the step to pre-process the data means we have to clean the data with the help of the Power BI in that we use power query editor by clicking transform data in that we remove the null values, duplicate values and fill missing values and we make first row as header an then we check the data type make the data in good manner and arrange the data in specific format.
2.Exploratory Data Analysis & Visualization:
After the cleaning of the complete data, we add the data into power bi by clicking close and apply in the power query editor. Then the interpretation of the data is explored some important information in the data.in this we can replaced the null values into 0. then explore the data using some power bi functions making summarization of the data and did some related operations. In visualization, with the help of the power bi desktop software to make dashboard, inserting the charts and graph and also calculates sum of all vaccinations based on the different criteria. Criteria like column name country, iso code by seeing columns or attributes in the data set.
Analysis:
By looking above, the data visualizations dashboard, charts and graph we find some points.
The dataset is available for 2021 and 2022.
The total 223 countries are presents in the vaccinations.
Total 81 source name present in the given data.
In 2021 total 60.79% vaccination completed.
In 2022 total 39.2% vaccinated completed.
India, China, United States are top countries completed the vaccination.
Top 10 countries where most people are vaccinated.
Insights:
In conclusion we can take a look at the final report for further analysis.
Countries by fully vaccination.
By seeing top 10 sources.
Recommendations:
We can collect the good dataset for the process of data analysis.
We can work large dataset and analyse them with the proper format.
We recommend good dashboard and charts to easily data analysis.
We can perform the operations with different categories.
Conclusions:
From the Analysis of the above Visualizations, by looking that we conclude.
The India and China these countries most of the people are vaccinated.
In this project report by looking dashboard we analyse the how many people are vaccinated and then we can understand the daily vaccination, fully vaccination, summary of the total vaccination per hundred