Last year we were lucky to collaborate with Data + Diversity on the Tuskegee Airmen Challenge. We had wonderful submissions that helped tell the story of the Airmen and all that they accomplished. This year, we are again partnering with Data + Diversity and we are...
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...
