Skip to content

Latest commit

 

History

History
30 lines (23 loc) · 1.28 KB

Covid-19-ReadMe.md

File metadata and controls

30 lines (23 loc) · 1.28 KB

About Covid-19 Report

I know that at the time of publishing this report the pandemy is no longer an actual subject, but i decided to make this report to learn Power BI.

Preview:

New version

pbi-covid-dash




Old version

image

Actions done

  • imported data sources from Git directly in Power BI, using the URL
  • cleaned data (changed column data types, unpivoted columns, replaced null values, columns renamed)
  • merged queries (to get many columns in one single table, instead of 3)
  • made DAX calculations (for Death Rate, Fatality Ratio, Incident Rate, Today Cases, Total Confirmed, Total Deaths, Total Recovered, Occurence of each vaccine to find the most used vaccines)
  • create charts

Data sources

  1. https://www.worldometers.info/world-population/
  2. https://github.com/CSSEGISandData/COVID-19/tree/master/csse_covid_19_data/csse_covid_19_time_series
  3. https://covid19.who.int/WHO-COVID-19-global-data.csv
  4. https://covid19.who.int/who-data/vaccination-data.csv