Since the data structure is different from the dataset in the video, in order to show

1) Running sum and comparison, I calculate monthly daily column and running cumulative column beside them. For the sake of clarity I filtered only with Thailand as a country.

For comparison, I used cumulative of each country and percentage of each country

2) Running Delta, for the sake of clarity I filtered Thailand and sorted by date,

3) Drill Down and Date, 1st picture is top level drill down and 2nd picture is 2nd level drill down

4) Pivot Table , I compare Country vs Year and use heatmap in each column to easy see the highest number

5) Score Card,

6) Timeseries,

7) Bar chart,

1. Running Sum and Comparison

2. Running Delta

3. Drill Down and Date

4. Pivot Table

5. Score Card

6. Time Series

7. Bar Chart

1. Running Sum and Comparison

2. Running Delta

3. Drill Down and Date

4. Pivot Table

5. Score Card

6. Time Series

7. Bar Chart

1. Running sum and comparison

2. Running Delta

3. Drill Down and Date

4. Pivot Table

5. Score Card

6. Time Series

7. Bar Chart

Great work!

Running Sum and comparison

Running Delta

Drill Down and Date

Pivot Table

Score Card

Time Series

Bar Chart

https://lookerstudio.google.com/reporting/a223180e-089c-4666-8718-25066af8d173