Preppin’ Data 2023 Week 10 – With Power Query!

Preppin’ Data 2023 Week 10 – With Power Query!

This week’s challenge built on last week’s answer. The steps involved using data scaffolding to insert rows for missing dates. The data set had gaps in dates and the trick to completing this challenge was trying to figure out how to do that without...
Preppin’ Data 2023 Week 9 – With Power Query!

Preppin’ Data 2023 Week 9 – With Power Query!

This week’s challenge had an append with 3 tables, some joins (merges) and some trickiness with a running total by groups! A common thing with PowerQuery is using “Group By” a dimension and then using “All” to generate a nested table in a...
Batch Format Excel Queries With VBA

Batch Format Excel Queries With VBA

I realize that there are a lot of tools out there to help you with DAX, Power Query, and all sorts of Excel and Power BI things. I am sure any one of those tools does this more efficiently than what I am about to write about. For folks that are using high end tools...
Preppin’ Data 2023 Week 8 – With Power Query!

Preppin’ Data 2023 Week 8 – With Power Query!

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...
Preppin’ Data 2023 Week 7 – With Power Query!

Preppin’ Data 2023 Week 7 – With Power Query!

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