Power Query

Use Power Query to read - confimed world data from :

https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv

Unpivot the data, Group the data by country and date, and transform the data into a 3 column table:

Country, Date, Confirmed

Use Power Query to read - world deaths data from :

https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_deaths_global.csv

Unpivot the data, Group the data by country and date, and transform the data into a 3 column table:

Country, Date, Deaths

Merge both queries into into one 4 column table:

Country, Date, Confirmed, Deaths

Main sheet:

1. Create 2 pivot tables. First for Confirmed (date and confirmed), Srcond for Deaths (date and Deayhs).

2. Add a slice by Country

3. Add 2 "Line" Graphs for the above pivot tables.