This Covid-19 data viz is based on our Covid data exploration project. The dashboard displays percentage of population infected in each country, total amount of applied vaccination per country, and also total death count in 6 continents.
In this project, we employ formulas and pivot tables in Excel to conduct an analysis based on specific questions. Our exploratory data analysis includes using conditional formatting. We also identify if there are any anomalies in the data.
In this project we use Excel formula to clean the data, then create a pivot table for easy analysis and visualization, resulting in a presentable chart.