This week I was asked several times about connecting to the USASpending.gov API. It can be done with a little help with testing from Postman. Once you figure out which endpoint you want to query, you need to figure out: Whether it is a GET or POST request If you need...
#PreppinData Playlist on Youtube The #PreppinData playlist has been updated through 2023 Week 22! If you haven’t tried it yet, PreppinData is a Tableau Community Project that aims to help people learn and maintain data prep skills. If you are new to #powerquery,...
We received a reprieve from advanced challenges with Week 14. It was a good practice challenge to reinforce some fundamental best practices with prepping data. This challenge required some pivots and unpivots. These are more expensive processes, so remember: Filter...
As a follow up to the Survey 32 dashboard I did, I was fascinated with the survey project as a whole conducted by Dr. Edward Gitre and his team, so I decided to take a crack at another survey from the website. Survey 194 was titled “Attitudes of Enlisted WAC...
This week I decided to spare everyone a really, really long video and focused on the trickiest part of this week’s challenge: dynamically selecting trades and then providing a rolling average. Nested tables with a nested let statement allowed me to dynamically...
