Hellow guys, Welcome to my website, and you are watching Power Query Tutorial - What is it, how to use it & 4 complete examples + Free download. and this vIdeo is uploaded by Chandoo at 2020-08-26T01:50:27-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Power Query Tutorial - What is it, how to use it & 4 complete examples + Free download |
| Video Uploader | Video From Chandoo |
| Upload Date | This Video Uploaded At 26-08-2020 08:50:27 |
| Video Discription | 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 |
| Category | Science & Technology |
| Tags | chandoo | chandoo.org | Excel | spreadsheets | power query | Power Query tutorial | Excel Power Query Tutorial | power bi power query | Data cleansing examples | Combine folder of files with Excel | Web scraping tutorial | In depth power query tutorial | Power Query for beginners |
