Project 1 - COVID-19 Vaccinations Trend Analysis

COVID-19 Vaccinations Trend Analysis

AIM

The goal of this project is to research and analyze the global vaccination efforts for COVID-19, including trends and progress made towards preventing the spread of the disease. This includes examining the distribution and administration of vaccines, as well as any challenges or successes that have been encountered in the vaccination process. The project will provide insight into the current state of the pandemic and the effectiveness of vaccination efforts in controlling it.

Introduction

The COVID-19 pandemic has had a significant impact on the world. The virus, which is caused by the SARS-CoV-2 coronavirus, was first identified in Wuhan, China in late 2019 and quickly spread to other parts of the world. The virus can cause a range of symptoms, from mild to severe, and can be life-threatening in some cases.

In the early stages of the pandemic, there was no known cure or vaccine for COVID-19, and governments around the world implemented measures such as lockdowns and travel restrictions in an effort to slow the spread of the virus. This had a significant impact on people's daily lives, including their finances and mental health.

However, as the pandemic continued, researchers around the world worked tirelessly to develop vaccines to protect against COVID-19. In late 2020, several experimental vaccines were developed and tested in clinical trials, and some of these vaccines were later approved for use in various countries. The vaccines have been successful in reducing the severity of COVID-19 and protecting people from severe illness and death. Many countries have developed their own vaccines or procured them from other countries, and many have also provided vaccines to other countries that have limited resources.

Problem statement

These are all important factors to consider when examining the global vaccination efforts for COVID-19. By understanding how many people have been fully vaccinated according to the recommended protocol, it is possible to gauge the effectiveness of the vaccination campaign and the extent to which the population is protected against the virus. It is also useful to know how many people have received at least one dose of the vaccine, as this can provide a sense of the progress that has been made in terms of vaccination coverage.

Additionally, understanding the different vaccines that are being used and their availability to different countries can provide insight into the distribution of vaccines and any potential barriers to access that may exist. This information can be helpful in identifying areas where additional efforts may be needed to ensure that as many people as possible are vaccinated and protected against COVID-19.

Methodology

Data exploration and data cleaning are important steps in the data analysis process, as they allow you to get a better understanding of the data and ensure that it is in a suitable format for analysis. Using a tool like Power BI can be helpful in this process, as it provides a range of features for cleaning, transforming, and visualizing data.

Once you have cleaned and transformed the data, you can use data visualization techniques to explore the data further and gain meaningful insights. Visualizing the data can help you to identify patterns, trends, and relationships that may not be immediately apparent from looking at the raw data. By using different types of visualizations, such as bar graphs and line graphs, you can represent the data in a way that is easy to understand and interpret.

Analysis (Data sheets pertaining to it)

First to clean the data in Power Query, we remove the Daily Vaccination Raw data table since it is similar to Daily Vaccination data, but contains more info, while the Raw data table consists of null values. Then the Column headers were given proper name by removing the underscore, and imported to powerBI.

Creating cards to display key metrics, such as the total number of countries in the report, the total number of people vaccinated, and the total number of people fully vaccinated, can provide a quick overview of the data and highlight any trends or patterns that may be present.

Next a line chart to denote the Total vaccinated people by the year, month and day.

After this we create a stacked bar graph to show the top countries where the majority of fully vaccinated people are in. In the graph we see that India is having the top number of people who are fully vaccinated

Next to that we create a stacked column graph to show the top countries where daily vaccination is taking place. In the chart we notice that China followed by India are leading in providing vaccinations in a daily basis.

We have also made a map view to show geographically the no of people vaccinated in each country.

In addition to this, gauge charts showing the percentage of fully vaccinated and single dose vaccinated person’s details are shown.

Using line charts and bar graphs can be effective ways to visualize trends over time and compare different categories of data. A map view can also be helpful in showing the geographic distribution of data and identifying any regional patterns or trends. By creating these types of visualizations, you can gain a better understanding of the data and identify any areas where further analysis or investigation may be needed.

Insights

As per the report, the data shows good number of people and their respective Governing bodies are providing the vaccines steadily and is increasing the vaccinated population. We can find that the % of fully vaccinated individuals has reached 75% of the total vaccinated population and only a few are vaccinated with a single dose. There is also sufficient supply of vaccines. In the graphs we find that India has the most vaccinated population in the world and China leads in the country delivering most number of people vaccinated on a daily basis.

Recommendations

These are important points to consider when examining the global vaccination efforts for COVID-19. It is important for developed and economically strong countries to support underdeveloped and developing countries in their vaccination efforts, as this can help to ensure that as many people as possible are protected against the virus. This can be particularly important for countries that may have limited resources or infrastructure for vaccination campaigns.

It is also important to aim for high vaccination coverage, as this can help to protect individuals and communities from the spread of COVID-19 and reduce the impact of the pandemic. Achieving vaccination coverage of at least 90% of the population may be necessary to achieve herd immunity, which can help to protect those who are unable to receive the vaccine or are at higher risk of severe illness from COVID-19. By working towards these goals, it may be possible to bring the pandemic under control and protect people around the world from the devastating effects of COVID-19.

Conclusions

It is true that the rollout of vaccines has played a significant role in helping to control the COVID-19 pandemic and allow the world to start returning to a more normal state. Many countries have been able to significantly reduce their COVID-19 case counts and deaths, and vaccines have been shown to be effective at reducing the severity of the disease and protecting against severe illness and death.

However, it is important to note that the pandemic is not yet fully under control, and the virus is still circulating in many parts of the world. While some countries have made great progress in vaccination efforts, others are still lagging behind and may be at risk of continued outbreaks or resurgence of the virus. It is important for all countries, including large countries like China, India, and the United States, to continue to support vaccination efforts around the world and to provide assistance to countries that may be struggling to get their populations vaccinated. This can help to ensure that as many people as possible are protected against COVID-19 and that the pandemic can be brought under control globally.