Episodes
Miguel Escobar is the co-author of the original book on Power Query - "M" is for data monkey and its recent completely re-written version "Master Your Data"Master Your Data with Excel and Power BI - Skillwave TrainingNow a Product Manager at Microsoft working on Power Query - Miguel is someone who wants to help everyone turn their data into useful informationCheck out www.powerquery.com Also a musician with his song Someday Somehow available to listen toSpotify – Someday, Somehow‎Someday,...
Published 12/10/22
Published 12/10/22
****Blatant Advert****Did you know I've written a book "Power BI for the Excel Analyst" - https://pbi.guide/********************Author of Supercharge DAX, trainer, speaker and all-round good guy, Matt is a Sydney based pillar of the Power Pivot / Power BI community.Any greater achievement than coining the phrase "The Collie Method?"Check out Matt's favourite Power Query article: https://exceleratorbi.com.au/build-reusable-calendar-table-power-query/Most popular:...
Published 12/05/22
Wine Shop Owner, art lover, Power Query enthusiast.Erik Svensen has been blogging about Power Query before it was called Power Query! YouTube version:  https://youtu.be/y5XV6-FXOKk Check out Erik's links Filter a table based on anotherHow to handle different decimal separators LinkedIn: https://www.linkedin.com/in/eriksvensen/Twitter: https://twitter.com/donsvensen  
Published 12/05/22
Accountant turned consultant, Rick is a newly minted MVP with a lot of thoughtful and insightful comments around Power Query and working in the data world. He sets a new record for the Just A "M"inute game! YouTube version: https://youtu.be/3IPFdtFi_UI   Check out Rick's links Favourite Post https://gorilla.bi/power-query/list-functions/ Most popular https://gorilla.bi/dax/5-ways-to-calculate-last-12-months-in-dax/ And good news... Query collections are coming......
Published 10/02/22
As always I thoroughly enjoyed chatting with my guest.  Thank you Celia. Celia has a very different backstory to many guests, such a twisting tale of chance and hard work coupled with a dedication to automate everything and find a better way. Check out Celia's favourite and extremely useful blog post on allowing a single refresh when combining loaded tables with Pivot...
Published 06/12/22
I'm a big fan of Chandeep's YouTube videos, his Power Query content is thoughtful and well explained.  I often discover he's covered topics 12 months before I do which is annoying! :) I really enjoyed our wide-ranging chat. Ideas we mention at the end Customisable Ribbon in Power Query Expandable Power Query Formula Bar The YouTube version of this chat is here https://youtu.be/8IOA18yzDGA You can find Chandeep via his excellent YouTube channel...
Published 05/29/22
"Just get it done" - the unofficial Power Query motto Ed is a Principal Consultant at P3 Adaptive From life as a CPA to providing more than 1,000 solutions to the Power BI Community, Ed has been on the Power Query / Power Pivot / Power BI journey from the start.   Ed's post on the P3 blog about lists can be found here: https://p3adaptive.com/2022/03/working-with-lists-in-power-query-lets-count-words/ Favourite Blog:...
Published 05/15/22
Talking Power Query with Miguel Llopis Group Product Manager, Citizen Data Integration @ Microsoft
Published 04/30/22
YouTube version: https://youtu.be/6GL4U4pkWeI Imke looks at M code like Neo sees the "M"atrix.   She is one of those folks that just amazes me as to what is possible inside Power Query and the M language.   Imke has made a huge contribution already to the various tech community forums and continues to do so by now developing some amazing tools to make all our Power BI development lives easier.   https://www.thebiccountant.com/about/   Imke's favourite tool: Power BI Cleaner...
Published 09/04/21
The Power Query Magic YouTube version is available here... https://youtu.be/AWuWwxGs3lo Alex Powers is a passionate Power Query advocate who has trained thousands of people in Power BI and now works for Microsoft helping to spread the word that Power Query is Magic! We have a wide ranging conversation, agreeing that Tables are the key to it all. I raise my wariness of "AI" driven help, Alex battles with whether to restart a blog, and of course we discuss Query Folding.   30 Day...
Published 08/21/21
The Power Query Magic YouTube version is available here... https://youtu.be/OKKAwlUIUW4 Reza Rad is a flamenco guitar playing Power BI community "stalwart". Look up the definition of the word "stalwart" and you'll find something like this "a dedicated, reliable, and hard-working supporter of an organization or team" .  This is Reza, he contributes to the Power BI community in so many ways I question when he has time to sleep! Reza was one of the first to blog about the early versions of...
Published 08/10/21
The Power Query Magic YouTube version is available here... https://youtu.be/OKKAwlUIUW4 Reza Rad is a flamenco guitar playing Power BI community "stalwart". Look up the definition of the word "stalwart" and you'll find something like this "a dedicated, reliable, and hard-working supporter of an organization or team" .  This is Reza, he contributes to the Power BI community in so many ways I question when he has time to sleep! Reza was one of the first to blog about the early versions of...
Published 08/06/21
The Power Query Magic YouTube version is available here... https://youtu.be/07zOX5IYImI   Gil is author of the excellent book Collect, Combine, and Transform Data Using Power Query in Excel and Power BI https://datachant.com/next/   We discuss Gil's experience as one of the Program Managers on the Excel team where he was closely involved with Power Query in it's earliest days.   We discover one of Gil's first ever blog posts was the inspiration for my first ever YouTube...
Published 07/23/21
"I can't think of anyone that uses Excel that wouldn't benefit from using Power Query" - Mynda Treacy How do you go from art studies in a beachside suburb school, to accountant at two London investment banks to a YouTube following of 326,000!? Mynda and I cover lots of ground in this conversation.  We have had similar journeys working overseas, working for banks, becoming accountants, getting hooked on Excel. Mynda has a huge following on YouTube and her online training business...
Published 07/10/21
In this episode Lars introduces a brand new podcast feature - "my worst presentation ever!" We share our mutual nervousness of public speaking and discuss meetup groups and the MVP award. We get into the back story around his creation of the  Notepad++ Power Query Editor and reminisce about the last time we used VBA Enjoy: Check out the YouTube recording of this episode here https://youtu.be/KJlE3RFE7dQ   Links   Website:  https://ssbi-blog.de/category/blog/ Most Popular...
Published 06/26/21
If you haven't seen Oz demonstrating Power Query via his Excel on Fire YouTube channel then you are missing out.  Our discussion takes us from good bars and good cookies to bad data, brave moves and a brush with fame I wasn't expecting Enjoy   Watch this episode on YouTube: https://youtu.be/zfuLTl8z4l8   Excel on Fire  https://www.youtube.com/channel/UCZgOVykPoRbSZQfY9YysiRQ Paqui One Chip Challenge: https://youtu.be/F9JsFnSx7dY XLOOKUP Summit: https://youtu.be/0KEhR66btUs Oz's...
Published 06/12/21
Ken Puls is a Microsoft MVP of many years, co-author of THE original book on Power Query ( "M" is for Data Monkey) and well known personality of the Excel and Power Query World.
Published 05/17/21
The short trailer with my plan for the Power Query Magic Podcast
Published 05/17/21