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:
=======================================================
https://chandoo.org/wp/power-query-tutorial/
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 - https://amzn.to/2Nqiae8
Recommended course:
Excel School program - data cleansing, analysis and visualization course by Chandoo - https://chandoo.org/wp/excel-school-program/
#PowerQuery #Excel #PowerBI
Видео Power Query Tutorial - What is it, how to use it & 4 complete examples + Free download канала Chandoo
* 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:
=======================================================
https://chandoo.org/wp/power-query-tutorial/
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 - https://amzn.to/2Nqiae8
Recommended course:
Excel School program - data cleansing, analysis and visualization course by Chandoo - https://chandoo.org/wp/excel-school-program/
#PowerQuery #Excel #PowerBI
Видео Power Query Tutorial - What is it, how to use it & 4 complete examples + Free download канала Chandoo
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Getting Started with Power Pivot & Power Query in Excel - 1-Hour ClassEasiest Lookup formulas for any situation - an interview with Oz Du Soliel (Excel on Fire)2020 Introduction to Power BI - What is it, how to use it and create your first report with Power BIPower BI Training | Power BI Certification | Power BI Course | Intellipaat10 Excel formatting tricks *ONLY* experts knowGet Multiple Files Containing Multiple Sheets with Power QueryEM152 Power Query di Excel #1 Introduzione e come creare una lista univoca ordinataBill Jelen - MrExcel's Best Excel Tips (including a secret tip from FBI 😮)5 Excel Functions YOU NEED in 2021Drop Down Lists in Excel - Masterclass (incl. Dynamic, Dependent & Searchable Drop Down Lists)1-godzinne szkolenie z Excel Power Query - Webinar z 25.06.202010 awesome things you can do in Excel - WITHOUT any formulas or pivotsAccess Beginner Tutorial50 Ultimate Excel Tips and Tricks for 2020Power Query for Accountants & Finance PeopleExcel Power Query Course: Power Query Tutorial for BeginnersIntroduction to Power Pivot for ExcelHow to easily automate boring Excel tasks with Power Query!MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions