Preppin’ Data Week 4 saw a common scenario where you had to pull in and make sense of multiple tabs of data from a spreadsheet. When it comes to this scenario in Power Query, whether it is in Excel or Power BI, there is something you want to do in order to...
Back with another Preppin’ Data Challenge solution using Power Query in Excel! This one was a little more complex than the last one. I stuck to the declarative features in Power Query so that anyone newer to prep can follow along. This challenge involved an...
The Preppin’ Data 2023 Week Two Challenge provided some ways to practice common data prep techniques like joins and merging columns. The data was related to banking and the end result is a table with International Banking Account Numbers. Tip for Merging...
I was able to complete this first challenge for this year. They started with some back-to-basics challenges, which was good in terms of practice. If you would like to do the challenge yourself, here is the link. This is a really great community challenge for building...
I noticed Will Sutton started making videos based off of the Preppin’ Data data prep challenges. He has videos on his channel on how to complete the challenges using SQL, R, and Python. I highly recommend those videos for people upskilling in any of those...
