Power BI & DAX: How to Compare Timeseries with Different Start Dates

Let's say you want to compare time series of two product launches that are six months apart. Plotting data chronologically will not be very user friendly. The best way to do it is to plot them based on number of days from the launch date. This way we can easily see which product grew to … Continue reading Power BI & DAX: How to Compare Timeseries with Different Start Dates

COVID19 – Total Impact on US Deaths

According to the official statistics, there are almost 70k deaths in USA as of first week of May 2020.I am trying to find these deaths in the overall weekly US deaths in the CDC dataset and failing miserably. Our Coronavirus (COVID-19) dashboard is available here: https://bit.ly/2voUAbx Weekly U.S. Influenza Surveillance Report: https://www.cdc.gov/flu/weekly/index.htm Weekly US Deaths: … Continue reading COVID19 – Total Impact on US Deaths

The Quality and Transparency of COVID19 Data is Unacceptable

Publicly available data for COVID19 is OK for basic trending; however, there are too many data inconsistencies in the data set. Much of relevant data is not publicly available. If our societies are to incur major costs (both financial and with respect to social liberties) then the powers at be must provide all of the … Continue reading The Quality and Transparency of COVID19 Data is Unacceptable

COVID-19 Mortality Rates… Is there a better way to calculate them?

While we are in the midst of this pandemic, are we calculating the mortality rate correctly? If we number of cases is growing exponentially, does the standard calculation of Mortality Rate = Sum(Deaths)/Sum(Confirmed Cases) accurately represent what is really going on? In this video, I argue that it does not, and I suggest an alternative … Continue reading COVID-19 Mortality Rates… Is there a better way to calculate them?