• Data source: Link
• Covid-19 pandemic has affected the world in countless ways and has drastically changed the way we live our lives. As the pandemic continues to evolve, data on Covid-19 cases and deaths is critical to understand the scope of the pandemic and making informed decisions. In order to make sense of the vast amounts of Covid-19 data, I tried to make data more accessible to understandable by turning to data analysis tools such as Microsoft Excel. In this project, I used Excel to analyze global Covid-19 data and created a dynamic dashboard that summarizes this information in a user-friendly format. The dashboard is designed to provide up-to-date information on Covid-19 cases, deaths, and vaccinations. Through this project, I aimed to provide a valuable resource for anyone looking to stay informed about the ongoing Covid-19 pandemic.
• I used excel to analyze global data of Covid-19 and made a dashboard that summarizes covid related information

A sample of the dashboard.

. How it works:

• Two dynamic tables were created by power query to obtain tables (total cases and total deaths)

• Total cases table contains accumulated number of covid-19 cases till the current day, the last day and the change between the two, which highlights number of new cases at the current day. The table presents these numbers for all the different countries, and states or provinces when applicable.

  1. Table population and continents is derived from the total cases table.
  2. MS Excel’s geography data type tool was used to obtain population count for each country.
  3. An xlookup function was created to import the continent to which each country belongs.
  4. From this table, we can obtain covid-19 cases rate per population in each country or continent and the total cases in each continent. Note, that Russia has been included in Europe in this data.
  5. Charts were derived from the two tables “total cases” and “population and continent”, that show accumulated cases and rate of cases per selected countries, which are changeable through filter selection as well as accumulated cases per continent.

• Total deaths table shows accumulated number of deaths caused by covid-19 until today and the difference between today and yesterday, which present deaths for today. The table presents numbers for different countries and states.

  1. Table “population and continents” is imported from the “total death” table.
  2. The accumulated death column is obtained from the “total deaths” table.
  3. MS Excel’s geography data type tool was used to import population for each country.
  4. Using xlookup function specifies each country's continent from table where it shows each country and its continent. Note, that Russia has been included in Europe in this data.
  5. From “Mortality rate” table, we can obtain covid-19 mortality rate in each country or continent and the total cases in each continent.
  6. From pivot tables, charts are obtained to present accumulated deaths and mortality rate of cases per selected countries and accumulated cases per continent.
  7. Below is the excel file used, and an example dashboard picture (pdf).

  covid-19.xlsx

  Dashboard:

  covid-dashboard.pdf