Post by Rob Collie

I’ve known Ken Puls and Miguel Escobar for many years now. They’ve been “in” on this Power BI / Power Pivot revolution basically from the beginning.  In fact, Ken pressuring me was the reason I wrote DAX Formulas for Power Pivot, and Miguel subsequently translated it into Spanish!

When Power Query hit the scene, it really, really “spoke” to both of them.  At one point they were both separately emailing me about writing a book but unsure if they had the time, so I introduced them, and the two of them hit it off in a big way.

They both left their day jobs, are co-authoring the upcoming ‘M is for Data Monkey’ book, and are also now delivering online workshops for new and advanced users of Power Query.

Online Live Course, Aug 12-13

Their next live workshop is in August – eight hours of instruction (four hours each day) plus an additional 3 hour Q&A session on August 20th.

I’ve seen a video of the content – they make sure that you get to an advanced level through a really well thought learning curve that all Power Query users can benefit from.

I encourage everyone to look into this.  Power Query is here to stay and is an amazing complement to our Power Pivot skills, especially when paired with Power Update.  Whether you learn from Ken and Miguel or not, I encourage you to start adding Power Query to your repertoire.

More Info And Registration Here

The next tool that every Power Pivot user needs

Data Hero Path:  Power Query & Power Pivot are THE Engines of Power BI

We’ve published quite a few posts recently about Power Query and how it complements Power Pivot.

In case you want a teaser of their class’s content – take a look at their Patterns section here.

BTW, in tomorrow’s post I’m going to try to bring some clarity to all of Microsoft’s recent moves in the Power BI space, including the new Designer tool.  Spoiler alert:  Power Pivot and Power Query, DAX and M, are front and center in the whole strategy.


Interested in Learning How to Do this Kind of Thing?

power query

Our New Online Power Query Course just launched this year. You’ll learn Power Query from the best in the business, two Excel MVPs Ken Puls and Miguel Escobar. We’ve included 7 Hours of Self-Paced Video over 31 Courses, with lots of example files, and a Digital Badge powered by Acclaim.

CLICK HERE to claim your spot.