#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...
This week was uh, complicated. Anytime you have to take out Table.Buffer, then you know that it was an advanced query. The challenge involved banking data from two countries, the UK and Ireland. You were tasked with summarizing the data based on reporting days and oh...
