Power Query Magic header image 1

Power Query Magic

17
May 2021

The One with the Introduction

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

17
May 2021
29
May 2021

The One with Chris Webb

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

Most Popular Article

Video version on YouTube: https://youtu.be/cLxEYN5CSH8

 

 

12
Jun 2021

The One with Oz du Soleil

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

 

26
Jun 2021

The One with Lars Schreiber

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 Posts :

Lists in PQ

Power Query Editor using Notepad++

Favourite Post: The Enivronment Concept

Recommended Book:
Profession Excel Development book

Brush with Fame...
Braulio Estima

10
Jul 2021

The One with Mynda Treacy

"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

 

 

 

24
Jul 2021

The One with Gil Raviv

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

 

Most Popular Article

https://datachant.com/2016/12/09/remove-empty-columns-rows-from-table-in-excel-power-query/

Favourite Articles:

https://datachant.com/2019/10/17/bad-practices-power-bi-pie-charts/

https://datachant.com/2017/01/06/10-mistakes-you-always-do-in-powerbi-powerquery/

10
Aug 2021

The One with Reza Rad

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

Most Popular Article

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Favourite Articles:

https://radacad.com/grouping-in-power-query-getting-the-last-item-in-each-group

21
Aug 2021

The One with Alex Powers

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 Challenge: Query Folding - #30DQuery -

https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N

 

Power BI Workshops - https://aka.ms/pbiworkshops

4
Sep 2021

The One with Imke Feldmann

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 Gen2 now covers Analysis Services Models as well (thebiccountant.com)

Most popular article:  Easy Profit and Loss and account scheme reports DAX PowerBI Pivot (thebiccountant.com)

 

Advanced algorithms:

Goal seek algorithm: Non-linear Break-Even Analysis in PowerBI – The BIccountant

Matrix Inversion (MINVERSE Excel-function): Returns the inverse matrix for a matrix stored in an array. As a bonus, its determinant is returned in the metadata. (github.com)

 

Ben Gribaudo Series

Power Query M Primer (part 1): Introduction, Simple Expressions & let | Ben Gribaudo

 

Podbean App

Play this podcast on Podbean App