This site under reconstruction.
This post is part 3 of my Power BI updates. Post 1 was an update on the state tracking on Power BI and contained a rehash of how I created some measures such as running total (or cumulative) from the daily cases, moving averages for “x” days (in my case, I’m using 7 days moving…
This post is going to be different than usual. It’s going to be composed of mainly images. The images will be a repetition of the nine states that I’ve been following (Texas, Georgia, Florida, Tennessee, South Carolina, Louisiana, California, New York and Michigan). I originally chose those states because they were in the news the…
I’ve been avoiding doing any kind of graphing or numerical play with the data that is being put out on this crisis mainly because the news is so distressing. All I have been doing is just gathering the data without doing anything with it. But with the states now starting to open up the economy,…
Note: This post took forever to develop. Creating examples took a lot of out me so I’m thinking of doing the second half next weekend. Over the holidays I was thinking over the conversations I had with others about using Excel and it got me thinking about ways I use Excel that others don’t. It…
A few weeks ago, I did a post “Playing with Data Query” on pulling in data from websites such as Wikipedia or government sites. I believe most sites give data in the form of tables. Wikipedia or the government site showing you the names of House of Representatives or Senators are good examples where you…
I thought since I’m on Thanksgiving holiday that I would go back to my climate files where I had gathered data from the web and see if I can update the data using the embedded data query. The one I was really interested in was the file pulling in temperature data history for each state…
You must be logged in to post a comment.