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 indepth video tutorial, learn all about this powerful timesaving 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, cleanup 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 mindmap PDF, visit: