This data analysis project focused on examining Covid-19 vaccine data up to December 31, 2023, to extract valuable insights and trends using Microsoft Power BI. The objective was to gain a comprehensive understanding of the global vaccination effort against the Covid-19 pandemic and identify key patterns and trends in vaccination rates and distribution.
The project involved several key steps:
-
Data Collection : Gathering comprehensive data sets on Covid-19 vaccination from reliable sources such as government health agencies, the World Health Organization (WHO), and other reputable organizations. The data included information on vaccine types, distribution channels, administration rates, booster administration rates, GDP_per_capita and population demographics.
-
Data Cleaning and Preprocessing : The collected data underwent thorough cleaning and preprocessing to ensure accuracy and consistency. This involved handling missing values, standardizing data formats, and removing any outliers or inconsistencies that could affect the analysis.
-
Data Analysis : Utilizing Microsoft Power BI, the cleaned data was visualized and analyzed to identify trends, patterns, and correlations. Various visualizations such as bar graphs, line graphs, and heat maps were created to provide a comprehensive overview of the vaccination landscape.
-
Dashboard Creation : A user-friendly and interactive dashboard was developed using Power BI to present the key findings and insights derived from the analysis. The dashboard included multiple tabs or pages, each focusing on different aspects of the vaccination data such as global vaccination rates, country vaccination rates, distribution by vaccine type, regional disparities, etc.
-
Insights and Trends : Through the analysis, several valuable insights and trends were uncovered, including:
- Global vaccination progress over time, highlighting milestones and fluctuations in vaccination rates.
- Distribution of vaccines among different regions and countries.
- Vaccination progress over time in various countries of the world.
- Identifying areas with high vaccination coverage and those lagging behind.
- Identifying the relation between vaccination rates and the GDP per capita of the country.
- The number of vaccinations administered on a daily basis and the people getting vaccinated.
- Variation of vaccination doses with age of the people.
Overall, this data analysis project provided a comprehensive overview of the Covid-19 vaccination effort up to December 31, 2023, and demonstrated the power of Microsoft Power BI in deriving actionable insights from complex datasets.
