Power Query (Get & Transform knowledge in Excel) is a real sport changer đź’Ą. It can simplify and automate varied knowledge actions. In this in-depth video tutorial, study all about this highly effective time-saving know-how. You will study:
* What is Power Query and how to launch it from Excel or Power BI?
* How to join and cargo knowledge from any kind of sources – excel recordsdata, CSVs, textual content recordsdata, internet pages, PDF, folders and so on.
* How to carry out widespread knowledge cleaning actions with Power Query
* Adding columns utilizing guidelines
* Automating knowledge assortment, clear-up and publishing processes with Power Query
* Web scraping with Power Query
* SQL fashion Joins, merges, appends and unions with Power Query
* Consolidating knowledge in a folder
* Data load, save & publish course of
* Tips & methods on utilizing Power Query effectively
For pattern datasets, accomplished workbook and thoughts-map PDF, go to:
=======================================================
https://chandoo.org/wp/power-query-tutorial/
Timestamps:
0:00 – Introduction to Power Query
3:34 – Power Query as a thoughts-map
24:10 – Example 1 – Employee knowledge load, clear-up and evaluation
47:09 – Example 2 – Web scraping with Power Query
58:48 – Example 3 – Consolidating a folder of recordsdata with Power Query
1:09:08 – Example 4 – Merging, becoming a member of and appending datasets with Power Query
1:22:43 – Closing remarks – how to study extra, books & web site suggestions
Recommended e book:
Combine, accumulate & remodel knowledge with Power Query by Gil Raviv – https://amzn.to/2Nqiae8
Recommended course:
Excel School program – knowledge cleaning, evaluation and visualization course by Chandoo – https://chandoo.org/wp/excel-school-program/
#PowerQuery #Excel #PowerBI
(*4*)
