COVID-19 disease / SARS-CoV-2 coronavirus outbreak/epidemic/pandemic 02-17-2020 14:48 PM - last edited 03-21-2024 05:05 AM

[avatorl]

It's not just a dashboard, there are multple pages in the report top present data from different points of view: a page to show top 10 countries by number of cases/deaths, a page to compare countries by case fatality rate, mortality and Global Health Security Index, a tool to compare COVID-19 trends between selected countries and others.

Updated (9/1/2020): I created the report in earlier February and I'm still changing it when I have time. Some pages are well designed, some pages still require a final touch, some pages will be removed since they are not relevant to this stage of the pandemic...

Main data source: GitHub COVID-19 Data Repository by the Center for Systems Science and Engineering (CSSE) at Johns Hopkins University.

eyJrIjoiMDlkYzcwMDctY2Q2MC00MjE0LTlkZDAtYjQxY2U5N2JhYTBhIiwidCI6IjYzNjBkMTZhLTk3MWQtNGQzMC1hOWE5LTdiY2I0ODUzMDhlMSIsImMiOjl9

[Ion_Gomez]

Which filter is the one that you use in the first page? 

I want to use that in our company, a filter that you can type.

[avatorl]

@Ion_Gomez it's just built-in Slicer 😉

1. Click the three dots (…) from the upper-right corner of the Slicer.
2. There, you should find the option Enable search.

[avatorl]

I'm starting a series of posts on my blog about How did I build my COVID-19 report

[nguyenngoclyna]

Hi Avatori,

I want to share your dashboard with citizens in Vietnam, but, my country has many people who can't read English.

Pls, you could share it with me, isn't it?

my email's hainguyen2209@gmail.com

Thank you so much!

[nguyenngoclyna]

Hi Avatori,

I want to share your dashboard with citizens in Vietnam, but, my country has many people who can't read English.

[nguyenngoclyna]

Pls, you could share it with me, isn't it?

[nguyenngoclyna]

my email's hainguyen2209@gmail.com

[nguyenngoclyna]

Thank you so much!

[avatorl]

The report is also available here:  http://avatorl.org/covid-19/ 

[harryfasb6000]

Hi Avatori,

Great dashboard. Is it possible to get a copy of your .pbix as curious to see how you brought in the various the news feeds.

Thanks.

[avatorl]

>>Is it possible to get a copy of your .pbix 

I'm sorry, so far I'm not going to share the pbix file. But feel free to ask any questions about the report.

[chamue329]

Hi - you did an incredible job on this dashboard. I especially like the daily % chart that shows the Top 5 countries new case change rate.  Are you pre-calculating this in the table with Power Query or using DAX measure?  I have trended data table with dates vertically.  Any suggestion you can provided would be gratefully accepted.

Steve

[avatorl]

@chamue329 , @abubakrsaad, sorry for such delay with my answer. I hope you're fine, it's a tought time on this planet now.

I used Power Query only to transform data structure, all calculations are based on DAX measures. For % of growth it's just simple today's cumulative value divided by yesterday's cumulative value.

For all maps I used basic 'Map' visual, nothing special.

[abubakrsaad]

what the custom visual for word map?