That is right, we are going to step up our game and start adding correlation analysis to our reports and dashboards. Why would you want to do that? Well, a good reason could be to analyze whether there is a relationship between two variables. Yes, technically, you would want to run a regression to get … Continue reading How to Use Correlation Plot to Improve Storytelling and Analysis in Power BI
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
In this follow up for the original analysis I used May updates for the US Census indicators. Unfortunately,things are going from bad to worse. Retail is down 15%, while some components of retail are down 40%, 60%, and even 80%. Link to dashboard: https://bit.ly/2RQ2jr0
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
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
Was Sweden's approach to COVID19 right? It's too early to tell, but so far, it's also hard to say that Sweden was wrong. More details in my video https://lnkd.in/ejBrVfx . Link to our COVID19 dashboard: https://bit.ly/2voUAbx.
As you might know, Sweden has chosen a dramatically different approach to dealing with COVID19 pandemic. Instead of shutting down its economy as most other countries have done, Sweden has chosen to keep the restaurants and the borders open. They are, however, doing a bunch of other things to fight the disease. In my latest … Continue reading COVID19: Sweden – Doing it Her Way
Just posted a new video in which I go over the latest trends as of yesterday https://youtu.be/h5Xt6lCVRRM We also added a forecasting page to the dashboard, it's still in alpha but it does provide some useful insight on when the new cases will drop by 75% and when they will go down to zero
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?
We are continuing to make enhancements to our Coronavirus dashboard (https://bit.ly/2voUAbx ). We have added a new tab that allows us to analyze mortality rates by country and by number of infected per 1M of population. This tab has yielded some interesting insight. You can learn more about it as well as some of my … Continue reading Coronavirus (COVID-19) Trends Analysis