This site under reconstruction.
Do you ever run into a situation where you try to pull in data into your Excel via Get Data in the Data tab but there is more data than rows available in your file? I used to use Access for those situations, but lately it looks like Microsoft, maybe since last summer, has revamped…
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…