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 from multiple sections at work. Having them drop a file in a folder is one option you can work with.

Additionally, this challenge dealt with grouped ranking on dimensions that you had to create yourself, which was another thing that made this challenge great in terms of practicing real-life scenarios you may see in the workplace.

Here is the video: