This site under reconstruction.
When I pull coronavirus data from the CDC site, some data update more frequently than others. The data pertaining to cases and deaths appear to update daily on the afternoon of the next day whereas hospitalization may be updated weekly and testing in some infrequent fashion. The infrequency of update can cause problems with certain…
While I’m still converting my data pull from the Covid Tracking Project to the CDC data, let’s take a look at where the US stands in regards to the pandemic. I have done enough to be able to start seeing trends – although yesterday I did run into a little problem. Now, I admit it…
Time to take a little break from updating my Power BI files from the Covid Tracking Project to the CDC data. Last night I found some errors in my measures so I’m working on fixing that today. But a break now. While the US data is being updated, I can still look at what is…
A couple of days ago, the US reached a terrible milestone of 500,000 dead. Here’s Wednesday’s snapshot of data from 3 different sources: Wikipedia, Covid Tracking Project and the John Hopkins University. I made the image full width so you can see the numbers. The news uses the John Hopkins University data when telling their…
A couple of posts ago I wrote about why I was tracking the coronavirus using Power BI. One of my goal was to practice asking interesting questions that would bring out something unusual or astonishing or just plain interesting. In other words, try to think of something that no one else was doing because I…
A couple of posts ago, when I was discussing the three ways of creating calculations (measures, new columns in Power Query, and new columns in the charting/visualization view), there was at one point in the post an image of 2 moving average measures and I mentioned that I would do a post about why I…