Blog
Tips, Tutorials, and StoriesPreppin’ Data 2023 Week Three – With Power Query!
Back with another Preppin' Data Challenge solution using Power Query in Excel! This one was a little more complex than the last one. I stuck to the declarative features in Power Query so that anyone newer to prep can follow along. This challenge involved an unpivot, a...
Preppin’ Data 2023 Week Two – With Power Query!
The Preppin' Data 2023 Week Two Challenge provided some ways to practice common data prep techniques like joins and merging columns. The data was related to banking and the end result is a table with International Banking Account Numbers. Tip for Merging Columns: When...
