I have a very simple video today with not a lot of DAX needed; I just want to demonstrate how you can gain insights from data.
On 10th Sept 2021, NSW health made a material change to the Active Cases reported for COVID-19 in Australia (as you can see in the image below). I thought this was strange that it could flip a switch an make such a material change (without an explanation, what’s more), so I set about looking more deeply into the data to see what was happening.
I want to stress that I have no knowledge about the length of time a COVID-19 case is active. The active case numbers are provided by NSW Health (and the other state jurisdictions) each day along with the new cases. So while I can’t say what is right and wrong, what I can do is overlay the Total Cases data against the Active Cases data and look at what has changed.
My simple analysis today shows that there have been significant differences with the patterns in the data last year (Wave 2 – predominantly Melbourne), Wave 3 prior to the change, and Wave 3 after the change. I think this is a good example of how you can use data to gain insights.