I have covered Price Volume Mix (PVM) analysis for Revenue Variance in the earlier article. I recommend that you take a look at it first because PVM for Revenue variance analysis is much easier to understand as there are fewer moving parts to think about in the calculations. Assuming that you are now well versed … Continue reading Price Volume Mix (PVM) for Gross Margin Variance Analysis
Month: April 2020
Price Volume Mix (PVM) for Revenue Variance Analysis
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?