Hey, do you want to learn some cool tricks on how to manipulate data like a pro? Then you should check out the #PreppinData playlist on Youtube! We have a playlist that covers all the challenges from Week 1 to Week 25, and trust me, you don’t want to miss them....
#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...
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...
