skip to Main Content

Secret Pot Roast Recipe: Power Query vs. VBA Macros

Guest Post by Willem van Dijk

Intro by Avi: I have never met Willem van Dijk in person, but in my mind he has a persona of a scrappy boxer/standup comedian. A priceless combination. He would have you rolling on the floor no matter what. He brings home the reality of a business user trying to get some business intelligence. Your day job is something else – Finance, Marketing, Accounts, Sales, Product planning etc. But you do what it takes to get the data and analysis that you need. Here’s to the fighting spirit! Take it away Willem…

I love to hate secrets just about as much as I hate to love secrets…

Why? Because knowing a secret is great for the ego, yet too much ego is not great for the soul.
Which is why I love reading posts on PowerPivotPro as it is all about sharing secrets which, in essence, are no longer such.
Ironically, at times what one believes to be a secret often results to be common-knowledge, or worse, common-sense.

In my inaugural post I promised that I would share a Pot-roast recipe (of the secret kind) so here we go…

TopSecretppp

Read the Rest