Power Query Magic

https://feed.podbean.com/powerquerymagic/feed.xml

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

Episodes

Tuesday Aug 10, 2021

The One with Reza Rad

Tuesday Aug 10, 2021

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 Power BI, we touch on SSIS and discuss what a "Microsoft Regional Director" role involves - it's not what you'd think.

Links:

Website: Home - RADACAD

The One with Gil Raviv

Saturday Jul 24, 2021

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 video

Gil's post: https://p3adaptive.com/2015/05/harness-power-query-to-gain-competitive-analysis-insights-from-linkedin/

My Video: https://youtu.be/uej_Uc3__bE

Links:

Gil's App Source Apps: https://appsource.microsoft.com/en-us/marketplace/apps?page=1&search=datachant

The One with Mynda Treacy

Saturday Jul 10, 2021

"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 MyOnlineTrainingHub

I ask the longest and probably oddest "Mpossible" question regarding the treatment of 01/01/1900 date.

We both learn a Power Query feature thanks to Miguel Escobar.

Links:

Power Query Automates Boring Tasks: https://youtu.be/L4BuUzccLpo

Interactive Excel Dashboards with Power Query and Power Pivot: https://youtu.be/TK0CJBaqvnY

Saturday Jun 26, 2021

The One with Lars Schreiber

Saturday Jun 26, 2021

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/

The One with Oz du Soleil

Saturday Jun 12, 2021

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 Favourite: https://youtu.be/1dbXhynCqN8

Oz's Most Popular Video: https://youtu.be/v4taBhc9ENQ

Oz's take on his most popular (regretted) blog post https://medium.com/@OzExcel/my-clickbait-worked-but-not-for-me-881ad386fcc

Saturday May 29, 2021

The One with Chris Webb

Saturday May 29, 2021

Chris Webb is on the Microsoft Customer Advisory Team and a legend of the Power Query community.

In this episode Chris discusses the moment he fell in love with Power Query and he has some advice for how to read M Code as we explore the journey of roles and experiences that led him to be where he is today.

Chris Webb's BI Blog

Favourite Article

The One with Ken Puls

Monday May 17, 2021

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.

Links discussed in this episode

Excel Guru Newsletter https://www.excelguru.ca/content.php?335-Newsletter

SkillWave: https://skillwave.training/

MonkeyTools: https://www.excelguru.ca/content.php?341-Monkey-Tools

Vancouver User Group https://www.meetup.com/Vancouver-Power-BI-User-Group/

User Voice

Table Name Prompt: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10580340-change-excel-table-name-in-the-create-table-window

Dataflows https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/36898132-add-power-bi-dataflows-as-a-data-source-in-get

Blog / Video / Article

Favourite: Slowly Change Dimension Solution : https://youtu.be/Iq1D1VgAyeU

Monkey Tools Demo: https://youtu.be/FxwCtWN0uTs

Monday May 17, 2021

The One with the Introduction

Monday May 17, 2021

I'm Wyn Hopkins, Microsoft MVP, Power Query enthusiast, Excel and Power BI expert.

On this channel I will be meeting with the people who are leaders in sharing their knowledge about Power Query.

These are the people whose blogs, books, video and presentations I've been absorbing for many years. I'm excited to find out what makes them tick, how did they arrive at their current situation, and what advice and tips can they impart on us.

I want this to be fun, and I want to raise the profile of Power Query by sharing stories from the array of M Code magicians out there.

This is Power Query Magic

Check out our YouTube Channel: https://www.youtube.com/channel/UCKeJBKP0-vXHFp7dwb9AW2Q