This Week’s Topic: Power Query
NOTE: There’s a moment in this talk where the team speculates about the future of Power Query and how it really should be *the* ETL tool everywhere for Microsoft. Since the time of this conversation, Microsoft has snuck Power Query into Power Apps (https://powerapps.microsoft.com/sl-si/tutorials/data-platform-cds-newentity-pq/). So this coffee talk is also a crystal ball talk. If you think the future is already written then being a genius means being able to see the future before everyone else. An Indian man told me that in a little restaurant right by the Taj Mahal just a few months ago, and here I am sharing it with you. Enjoy! –Austin
Warning this is a THREE Microsoft MVP conversation – proceed with caution 🙂 Welcome to an experimental new feature here at PowerPivotPro, where members of the community discuss various topics related to Power BI, Power Pivot, and Analytics/BI in general. These conversations take place during the week on a Slack channel, and are then lightly edited for publishing on Friday. In our 2nd installment of our Coffee Talk series we’ll be chatting with three Power Query Pros. Let’s introduce the folks we brought in for this week’s Coffee Talk:
Power Query? Get & Transform?
M is for Making Lemonade from Lemons
The Elevator Pitch for PQ
Interested in Learning How to Do this Kind of Thing?
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.
Is PQ a Replacement for Traditional ETL? A Complement?
Suggestions for Future Development
M is to PQ, like VBA is to Excel
Austin spent the last five years using Modern Excel in the field to solve analytical challenges for the financial services industry, first at BBVA and later at Harbert Management Corporation. As a former analyst, Austin is focused on enabling other data professionals to experience the joys of Power Pivot & Power BI. Austin is a CFA Charterholder, former CPA, Excel Power User, and SQL Server Professional, whose involvement in data/analytics projects lowers the communication costs between business users and IT professionals and helps organizations get to solutions faster.