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:

Combine, collect & transform data with Power Query by Gil Raviv - [ Ссылка ]

Recommended course:

Excel School program - data cleansing, analysis and visualization course by Chandoo - [ Ссылка ]

#PowerQuery #Excel #PowerBI

свернуть