Project 1 - COVID-19 Vaccinations Trend Analysis

• Detailed Documentations (attach a word file and also paste in the text box)
• Power BI Report / .PBIX file
• Present the project like a Case Study using Power Point
• These Files are attached below please find it.

Detailed Documentations (attach a word file and also paste in the text box)

Created a power BI dashboard using file which you have given in project 1

I have completed the project and attached the files,

Power BI Report    --> .pbix file

Attached the Power point file(.pptx)  Presentation about project-1

Detailed Documentation of project on covid-19 using word file is attached.

 

Project Report on Covid-19 analysis

Created By:

Name: K Vamsi Krishna

E-mail: [email protected]

 

 

Table of contents:

• Aim
• Introduction
• Problem Statement
• Methodology
• Analysis
• Insights
• Recomendations
• Conclusion

Aim: - In this project the aim is to analyze data in detailed 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: -

• 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: - 

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, so with the help of the duplicates function in Power BI, I cleaned the data and replace the null values with 0 and then started working on it.
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.

• 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.

Analysis: - 

In observation found some interesting points that are mentioned below.

• According to data on people fully vaccinated in the year.
• The dataset available is from 2020 to 2021
• Total Average of daily vaccinations per million by the country in Gauge visual 3.26k.
• Total sum of vaccinations per hundred  3.50M
• Sum of people vaccinated_per_hundred 1.69M
• Highest number of vaccinations by source name is Ministry of Health is 7.41K.
• Country and iso code is shown in map visual.
• Count of vaccines is shown in the card.
• People vaccinated_per_hundred is shown in the Funnel visual .
• Year, month was taken in the slicer, Day and country was taken separate slicer while using slicer the values will changing in the dashboard visual.
• Country and vaccines are taken in Matrix and source website are taken separately .
• Max People vaccinated 1 BN taken in clustered bar chart  in page 2 dashboard.
• Top 10  Fully vaccinated Counties

Insights: -

• In conclusion we can tack a look at the final report for further analysis.

 Country by High Vaccination

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
• Based on the given data in proper data  visual i can create dashboard.

Conclusion: - 

In conclusion, we can take a look at the final Report for further analysis.
As we can see in the Report Fully vaccinated in the year 2021. Max People Vaccinated. Count of Va  ccines . Average vaccinated per million we can see.