EDIT 2021-01-12: the latest post and a video on how to calculate a perfect PVM is available here: DAX for the Perfect Price Volume Mix (PVM) Calculation (Power BI Tutorial) EDIT: the most recent post about this topic (and a video) can be found here: https://businessintelligist.com/2020/11/20/the-definitive-guide-to-price-volume-mix-calculation-pvm-in-power-bi-theory/ The first time I covered PVM for Revenue analysis, … Continue reading Price Volume Mix (PVM) for Revenue Variance Analysis
COVID19 vs. US Economy – My Analysis of US Economic Indicators for Retail (March 2020)
We all know that COVID19 has devastated the US economy. The question is how much? I have built a dashboard using the US Department of Commerce dataset for US Economic Indicators. The March numbers are in and they are depressing. I go over the numbers in my latest video. The dashboard is available here: https://bit.ly/2RQ2jr0
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
COVID19: Sweden – Was Not Wrong
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.
COVID19: Sweden – Doing it Her Way
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
Coronavirus (COVID-19) Trends Analysis for April 7, 2020
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
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?
Coronavirus (COVID-19) Trends Analysis
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
New features are added to the Knowledgebank.pro COVID-19 (Coronavirus) dashboard
Lots of new features added to the dashboard.. also a video has been posted for those who need help with how to use it. Link to dashboard: https://bit.ly/2voUAbx Link to video: https://www.youtube.com/watch?v=T21h46ZDh14
Coronavirus (COVID-19) Power BI Report
Knowledgebank.pro has released a Power BI report with Coronavirus (COVID-19) statistics by Country/State. The data set is updated daily. You can find it following this link:
business intelligist 