Power Query Tutorial - What is it, how to use it & 4 complete examples + Free download

Power Query (Get & Transform data in Excel) is a true game changer 💥. It can simplify and automate various data activities. In this in-depth video tutorial, learn all about this powerful time-saving technology. You will learn:

* What is Power Query and how to launch it from Excel or Power BI?
* How to connect and load data from any type of sources - excel files, CSVs, text files, web pages, PDF, folders etc.
* How to perform common data cleansing activities with Power Query
* Adding columns using rules
* Automating data collection, clean-up and publishing processes with Power Query
* Web scraping with Power Query
* SQL style Joins, merges, appends and unions with Power Query
* Consolidating data in a folder
* Data load, save & publish process
* Tips & tricks on using Power Query efficiently

For sample datasets, completed workbook and mind-map PDF, visit:
=======================================================

Timestamps:

0:00 - Introduction to Power Query
3:34 - Power Query as a mind-map
24:10 - Example 1 - Employee data load, clean-up and analysis
47:09 - Example 2 - Web scraping with Power Query
58:48 - Example 3 - Consolidating a folder of files with Power Query
1:09:08 - Example 4 - Merging, joining and appending datasets with Power Query
1:22:43 - Closing remarks - how to learn more, books & website recommendations

Recommended book:

Recommended course:

#PowerQuery #Excel #PowerBI

[jasfradique]

Why so few likes on this? Chandoo, you're awesome! I knew about you from reddit excel sub and since then I´m learning a lot. Thank you very much for all your blog posts, your videos, your guidance and support. Between you and the ExcelIsFun guy, I hope to learn a lot and get both my routine tasks and my work much, much easier...
Thank you, thank you, thank you very much. I wish you all the best and get my warmest regards, from Madeira, Portugal :-D

[mrpeterhacks]

4 years down the load and these tutorials are invaluable content

[bhaimohsin]

Man! Even in mid-2022, There are so few People who know about Power Query. I am so blessed that I came around your video. You've not only got a Subscriber but a Fan Also. Love Your Work Chandoo Sir!

[onegodthecreator]

Chandoo, you won our hearts with the dedication. No click bait, no time waste. Thoroughly enjoined coding.
Thank you

[fdiluch]

I think I follow you for more than 10 years now. I simply believe you are providing the best course on excel that we find online. It s funny and nice to see you in video while in the past you a misterious person . :-)
Thank for all these years of dedication and teaching

[smohidee]

I would like to thank you so much for sharing this video. This is going to help me a lot in my upcoming projects. This means a lot to me. You are a life saver and may God bless you abundantly for sharing your valuable knowledge.

[Theultrazombiekiller]

Great video on PQ. One thing I recommend for anyone learning it, make or download some sample data sets to use and combine in it and start just playing around with it. Spend 30 mins to an hour everyday just seeing what the features do and what you can do with it. You will learn how to optimize and master PQ in no time, probably less than a couple weeks :) And once you learn it, you will love it and it will become second nature to you, don't get overwhelmed!

[rooannaroo]

I have been looking for information and courses on Power Query and Power BI mostly here on YouTube. You are hands down the best tutor I have found and your pacing and presentation are excellent. I can’t thank you enough for the massive amount of work you put into your channel. I have learned a lot just by watching and that’s without the downloads and the following along which I will do presently.

[chelseyprimdahl]

Thank you for this! I am an RN, not a data analyst, but this video has shown me some possibilities that will help me in knowing what to ask our IT team to create what I need to transform my departments data tracking.

[markthompson]

Thanks Chandoo! This video is exactly what I needed for a tough problem I’ve been working on lately. I’ve been tying myself in knots for the last couple of weeks trying to figure out how to efficiently merge and append 10 different large spreadsheets that will update on an occasional basis. And, I was doing it all with just native Excel formulas. Let’s just say it wasn’t very pretty. Thanks for showing me how to do it the right way!

[excelgazialimuhiddinhacibekir]

One complete lesson, longer than a standard normal football game. Well done amidst these pandemic days, troublesome waters, challenging times, Dear Purna Duggirala. You ARE awesome since I first discovered you in 2008.

[JTFSIX]

THANK YOU SO have aged 10 years with all of this data that has inundated our am so looking forward to taking on this discipline and changing our data model performance and efficiency.

Thank you

[PoonamSingh-pomp]

Your course content is amazing .
Thanks for providing workbook to practice.
There is no benefit of these videos when reading workbook is not uploaded. These material really help to implement the learnings side by side.
I learned a lot. Thank you!!

[peterdallyn]

Best PowerQuery youtube video I've found so far on YouTube. Very clear and thorough, reinforced by some really good examples.

[sbell]

Thank you Chandoo for all you've shared over the years... and still at it. You taught me that Excel is AWESOME many years ago. Now that I've entered into the "Power" realms, your knowledge is still blowing me away. Thank You, Thank You, Thank You.

[purabprusty]

You are a life saver, Chandoo !!! Every time i want to learn something about excel BI query pivot, you are always here !!! Man to Man, you are a life saver !!!

[rajnishrajput]

I have been following you since 2014. Thanks for putting this altogether. As always, your videos are always easy to understand and apply and informative. It'll help me crack interview and get the desired job.

[MichealIdedia]

As a beginner, this video opened my eyes to the immense possibilities of power query. It could be said that the power query is the best tool in data preparation.

Thanks, Sir.

[naielah]

You put a lot of work into this training. I really appreciate your attention to detail in each section of the lesson. Great job!

[gauravyadav]

The way you speak and the way you explain anything. All I have to say is Your are the best.