This week’s challenge was a challenge aimed at practicing multiple joins/merges with filtering. There was an issue I had (that may have been me honestly). I was having issues with the account numbers not merging correctly. I explained what my issue was and what...
So this challenge was another intermediate challenge. Unpivot was the main trick to get the data lined up and I walk you through that in the video. One thing to note is that a lot of times conceptually it may be easier to break up your tables and solve issues in a...
So for this challenge, the same dataset was used, but more tricks were needed. There was a number of groupings that needed to be done, some joins, a nested table… yeah. It definitely kicked up a notch! Here is the video walkthrough: Preppin’ Data 2023 Week...
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...
