Interview with Ken Puls - Author of Master Your Data with Power Query for Excel and Power BI
You are watching an Interview with Ken Puls. Whereas we do dabble in general Excel and Power Query questions, most of the interview, we talk about the sequel to the "M is for Data Monkey," which is still considered the staple book on Power Query and M language. The new book is called "Master Your Data with Power Query in Excel and Power BI." It's co-written by Miguel Escobar. Sadly Miguel was not available for this interview, but he is a very important figure in the Power Query world nevertheless. If you are watching this video before December 1st, 2021, you can still win the PDF version of the book. Want to know how? Listen to the interview.
Chapters:
0:00 Excel Olympics Intro
0:08 Introduction to the Interview
1:52 How long after the first did you decide to write the second book?
7:26 Where did the "monkey" come from?
10:30 What's the major difference between the books?
13:50 How did you and Miguel choose who writes what?
16:06 Would You Say This is a Book for a Power BI User?
18:48 Which Feature of Power Query is your favorite?
22:03 Why should someone pick up this book / Who is this book for?
26:03 Win a PDF Copy of the Book
33:48 Which recent addition to Excel excites you the most?
38:05 Monkey Tools What are they?
47:03 Is there anything that you miss in Power Query?
Master Your Data with Power Query in Excel and Power BI Book:
Paperback: https://amzn.to/3woYah1
Kindle version: https://amzn.to/3H1j5eM
The first Book (M is For Data Monkey): https://amzn.to/3kdugr9
Where to find out more about Ken Puls:
https://www.excelguru.ca/
https://www.excelguru.ca/content.php?...
https://www.excelguru.ca/blog/
/ kenpuls
Here is an Interview with George Mount (the author of Advancing Into Analytics): • Interview with George Mount - The Author o...
Gear Used:
US Links
Camera: Canon EOS R6 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y
Recorded With: Camtasia - https://www.techsmith.com/video-edito...
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK
Disclaimer: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!
#Excel #ExcelOlympics #gasperkamensek