This week’s challenge was a great one in terms of practicing with using the “from folder” functionality in Power Query. There are a lot of things that you can do with this to automate data collection and prep, especially when you are collecting data...
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...
