Blog

Tips, Tutorials, and Stories
Preppin’ Data 2023 Week 13 – With Power Query

Preppin’ Data 2023 Week 13 – With Power Query

This week I decided to spare everyone a really, really long video and focused on the trickiest part of this week's challenge: dynamically selecting trades and then providing a rolling average. Nested tables with a nested let statement allowed me to dynamically select,...

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...

Bitnami