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...
There has been a lot of news lately about corporate layoffs. It is a tough thing to hear about and obviously much worse if you are affected. A while back Tim Blaisdell during one of our internal meetings asked about how we could connect folks with jobs better. Out of...
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...
