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....
As a follow up to a previous post on how to call an API and format all of your Power Query code in Excel, here is a walk through on how to do the same thing with DAX queries in Power Pivot. Add a reference to the Microsoft WinHTTP Services Prerequisites: Add a...
#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...
