CP040: Intro. to Power Query – What is it and how to get started – with Miguel Escobar
In the 40th session of Chandoo.org podcast, Let’s talk about Power Query. I have the pleasure and fortune to catch up with Miguel Escobar (who along with Ken Puls runs PowerQuery.Training website) and talk about this very exciting piece of technology and how it can make our life simpler.
What is in this session?
In this podcast,
- Miguel’s introduction, background and current projects
- What is Power Query
- How to install it
- Sample use cases of Power Query
- What is Power BI
- Resources for learning Power Query – Books & Courses
Listen to this session
Learn more about Power Query
I recommend 2 books for learning more about Power Query.
- Power Query for Power BI & Excel by Chris Webb
- M is for Data Monkey – A guide to M language in Power Query by Ken Puls & Miguel Escobar (pre-order only, release in November 2015)
Ken & Miguel regularly run an online class teaching hands-on techniques, implementation guidelines and secrets about Power Query. I have signed up for their next class and eagerly looking forward to it. I recommend going for their class if you want to seriously improve your Power Query skills.
Special offer worth $59 for Chandoo.org listeners
As a podcast listener, here is a special offer for you from PowerQuery.Training.
Use the discount code CHANDOO when signing up for their upcoming live session and get 10% off on the course fees.
Note: Ken & Miguel are good friends and partners of Chandoo.org. When you join this course from above link, I receive a small commission. I am recommending this course because I genuinely think their program is suitable & awesome for anyone needing Power Query instruction.
Transcript of this session:
Are you using Power Query? What has been your experience with it?
I have been playing with Power Query for last 18 months. I really like the technology and what it can do for us, analysts. I regularly use it to clean data, do quick transformations and set up models.
What about you? Have you been using Power Query? What is your experience like? Please share your success story in the comments.
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
Thank you and see you around.
Leave a Reply
|« Shading an area chart with different colors for up & down movements [case study]||Clean data quickly with Flash Fill »|