Blog

Tips, Tutorials, and Stories
Preppin Data 2023 Week 12 – With Power Query!

Preppin Data 2023 Week 12 – With Power Query!

This week was uh, complicated. Anytime you have to take out Table.Buffer, then you know that it was an advanced query. The challenge involved banking data from two countries, the UK and Ireland. You were tasked with summarizing the data based on reporting days and oh...

2023 Preppin Data Week 11 – With Power Query!

2023 Preppin Data Week 11 – With Power Query!

So this challenge involved a lot of tricks that were great to practice with Power Query. It involved calculating distances, finding the closest branch for each csutomer, then making a priority list for each branch. First, I set a constant for the conversion from...

Bitnami