04-02-2020 12:20 PM
There are 30+ pages in the report. The report contains a dashboard, charts with daily updates and cumulative data, growth rate caclulations and forecast, interactive tools to compare epidemic trends between countries, charths with clinical data and so on.
Main data source: GitHub COVID-19 Data Repository by the Center for Systems Science and Engineering (CSSE) at Johns Hopkins University.
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.
Hi Avatori,I want to share your dashboard with citizens in Vietnam, but, my country has many people who can't read English.
>>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.
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.
@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.
@Ion_Gomez it's just built-in Slicer 😉