Project 1 - COVID-19 Vaccinations Trend Analysis

• Aim :

This project is pertained to get the effective view of Covid19 affected countries and Vaccination details etc., The Output of this project going to give us answers for many questions like How many Vaccines do we have?, How many vaccination camps conducted?, How many peoples were vaccinated etc.,

• Introduction :

I was provided with the dataset named “Country vaccinations” which contains 15 Columns and 86512 Rows which contains details like Country name, Vaccine name, Vaccinated detail etc., And it also contains large amount of Null values in the table. Lets see the possible ways to do Effective Data formatting, meaningful Visualizations and feasible way to extract the meaningful Insights from the project.

• Problem statement :

The addressed Problem in the given data is Null values. It won’t be meaningful if it is replaced with some mean or approximate values, Because it is the extracted data of what has happened in the past years. So, changing the given data may give us the unreliable Output. So I have replaced the Null values with the Zero to hold the reliability of the data.

• Methodology :

Data Cleaning using Power query editor of Power BI -

After analyzing the, we have found that the null value has to be changed. For this replace option is used to replace null with 0 using Power query editor of Power BI desktop.

And Since I was provided with the single data table, There is no necessary to work with Data modelling and formatting.

• Analysis (Data sheets pertaining to it) :

First I have Build the visualizations with the Vaccines name and the Vaccinations counts in the world in the Table view and I have Built the Map view where we can get to know about the Total vaccinations done in the particular country. And As the Action filter are acting as default we can get the Vaccination events done by the daily basis by Country wise.

secoundly visulaizations shows that Sum of people fully vaccinated by Country in the Stacked Bar chat , Sum of total_vaccinations by country ( Top 10 ) in the Donut chart , Sum of people_vaccinated by country ( Top 10 ) in the Pie chart. Below is the Output of the same.

Thirdly I have biuld the Visualization of Sum of total_vaccinations by source_name in the Funnel view and Vaccinations & Vaccinated per hundred people in the Ribbon chart using the every quarters of the given years.

• Insights :

Here we analyzed the top 10 fully vaccinated countries in which India tops the list which indicates that people in the country were showing lots of interests to get vaccinated.

And also analyzed the top 5 vaccinated countries here also India tops the list then analyzed the top 5 daily vaccinating countries and here China tops the list also analyse the sum of daily vaccinating details, fully vaccinating and vaccinating people details.

year wise analysis shows that 2021 was the peak year for every vaccination details.

• Recommendations :

We should collect day to day reports, and we should update our records daily to get more accurate details.

So that we can move forward with more vaccination to the right country which needs the most.

• Conclusions :

From the given data, we know that country-wise the people are vaccinated.

Every country took actions in providing vaccine to people.