04-14-2020 08:27 AM
Daily Cases: Map, daily cases over time vs avg Last 7 days, the avg last 7 days provide good insight on the current progression rate and allow us to potentially confirm if the peak has been reached yet. (e.g. Italy)
Cases by Country: Basic overview deaths/cases/recoveries by country and %increase over time
Animated Cases: Animated cases over time using the play axis feature
Closed Outcomes: Recovery rate vs death rate
Stats by Population: Rate per one million inhabitants. Using the Unit/1M scale allows us to better compare each country disregarding their population size. Bringing all the countries to the same scale gives a completely different outcome!
Figures since 50th case: The Covid19 did not start to spread on the same day in all countries.
- So where how do we know where the virus spread faster?
- How do we compare one country with one another.
Bringing all countries at the same starting point (day 1 since first 50th case or day 1 since since 10th death) allow these comparisons.
Forecast: Can we predict when the peak will be reached?
To try answering this question I use a basic linear regression where my dependent (Y) variable is the daily growth rate
(of daily cases or daily deaths) and independent (X) variable the date.
Once the linear trend reaches 0 we can assume that the peak will be reached on that day.
Any chance you can share the pbix file (or measures) so i can understand how you accomplished looking at data not from a time perspective, but relative to the number of days from inception of the Xth case. Thanks