Power Query Magic

Wyn Hopkins
  • 5.0 (5)
  • TECHNOLOGY

Interviews with Power Query Magicians from around the world Also available on YouTube: https://www.youtube.com/channel/UCKeJBKP0-vXHFp7dwb9AW2Q

  1. 12/10/2022

    The One with Miguel Escobar

    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 Training Now a Product Manager at Microsoft working on Power Query - Miguel is someone who wants to help everyone turn their data into useful information Check out www.powerquery.com Also a musician with his song Someday Somehow available to listen to Spotify – Someday, Somehow ‎Someday, Somehow (feat. Chris Cron) - Single by PAB on Apple Music

    1h 10m

  2. 12/05/2022

    The One with Matt Allington

    ****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: https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/ VOTE FOR THIS: Remove Camel Case https://ideas.powerbi.com/ideas/idea/?ideaid=ed3364a1-fa9b-ec11-826d-281878de31cb Check out https://www.youtube.com/@PowerQuery

    1h 26m

  3. 12/05/2022

    The One with Erik Svensen

    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 another How to handle different decimal separators LinkedIn: https://www.linkedin.com/in/eriksvensen/ Twitter: https://twitter.com/donsvensen

    1h 7m

  4. 10/02/2022

    The One with Rick de Groot

    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... https://learn.microsoft.com/en-us/power-platform-release-plan/2022wave2/data-integration/save-curate-personal-query-collection-power-query LinkedIn: https://www.linkedin.com/in/rickmaurinus/ Twitter: https://twitter.com/Rickmaurinus

    1h 20m

  5. 06/12/2022

    The One with Celia Alves

    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 tables  https://youtu.be/JCNSVWY2NYw https://solveandexcel.ca/2020/09/11/enable-background-refresh-property-in-power-query-in-excel/   And her most popular here https://youtu.be/OQE9qMbofCw https://solveandexcel.ca/2020/10/23/how-to-change-the-display-language-in-excel/   You can also find Celia here: https://www.linkedin.com/in/celiajordaoalves/ https://twitter.com/celia_excel The Dataflow Connector code I mention briefly is = PowerPlatform.Dataflows(null)

    1h 10m

  6. 05/29/2022

    The One with Chandeep Chhabra

    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 https://www.youtube.com/c/GoodlyChandeep Favourite Blog: Recruitment Dashboard in Power BI - https://www.goodly.co.in/recruitment-tracker-dashboard-template/   Most Popular: Combine Data from Multiple Excel Files - https://www.youtube.com/watch?v=_jegiQkyC3s   Find Chandeep here: Blog - https://www.goodly.co.in/blog/ YouTube - https://www.youtube.com/goodlychandeep LinkedIn - https://www.linkedin.com/in/chandeepchhabra/ Twitter - https://twitter.com/chandeep2786

    1h 10m

  7. 05/15/2022

    The One with Ed Hansberry

    "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: https://www.ehansalytics.com/blog/2021/6/12/working-with-multiple-row-headers-from-excel-in-power-query Most Popular: https://www.ehansalytics.com/blog/2020/7/16/return-row-based-on-max-value-from-one-column-when-grouping You can find Ed here https://www.linkedin.com/in/edhansberry/ and on twitter: https://twitter.com/ehansalytics

    1 hr

  8. 04/30/2022

    The One with Miguel Llopis

    Miguel is Group Product Manager, Citizen Data Integration @ Microsoft He has been on the Power Query development journey since it's early inception as codename Data Explorer, and was involved in the original development of the Power Query user interface that we all know and love. He's now running the team and is more coach than player these days. It was fantastic to chat to Miguel about all things Power Query and try out the new game - Just a "M"inute   You can find Miguel here https://www.linkedin.com/in/migllopis/   and check out all things Power Query via https://powerquery.microsoft.com/en-us/   and the relatively new twitter handle https://twitter.com/MSPowerQuery

    1h 9m
See All (18)

Trailer

5
out of 5
5 Ratings

About

Interviews with Power Query Magicians from around the world Also available on YouTube: https://www.youtube.com/channel/UCKeJBKP0-vXHFp7dwb9AW2Q

Information

  • Creator
    Wyn Hopkins
  • Years Active
    2021 - 2022
  • Episodes
    18
  • Rating
    Clean
  • Copyright
    © Copyright 2021 All rights reserved.
  • Show Website
    Power Query Magic