Power BI

Earlier in the week, I did a post on how to use the Covid Tracking Project API and that very night, the structure of the data changed. An extra two columns had been added to the data to better capture the Covid-19 deaths. That slight alteration meant that the refreshing of the data in Power…

I have worked with API a little bit when I needed to pull file/folder information in Dropbox or needed to push data into QuickBase, but those efforts involved using VBA to do the work. They have involved a bit of work trying to figure out how to make the connections work and usually I have…

I love using Pivot tables in Excel because they can make gathering, slicing and dicing data so much easier; however, I probably don’t like them as a data source. This post will kind of explain why using a data source laid out in a “pivot table” fashion may not be the best way to pull…

Lately, when I pull coronavirus data from Wikipedia, I noticed that data are coming in later in the day, so I do most of my updates after 9 pm to try to get the latest data. Maybe people are now backed up with work or just tired of keeping track. The latest data though are…

Every time WordPress does its update on its Block Editor, I have to experiment with various plug ins activated or deactivated to be able to do a new post because something always come up broken. Sometimes I’ll be able to get the Gutenberg block editor and other times I can’t. Today is one of those…

Well, let’s rephrase that – I’ve been updating my graphs daily but I need to do an updated post on what I’m seeing and that is basically some states are seeing increases in infection rates since re-opening the economy. The source for these graphs and for all graphs in this post and pulled on 6/13/2020…