Excel 1: ETL with Power Query - Workshop
Excel 1: Modern ETL with Power Query in Excel
Description
When Power BI was being designed, the developers created a tool for importing and manipulating data. They called this tool Power Query, and they integrated it into Microsoft Excel. Today, Power Query represents one of the most powerful and potentially valuable tools in your everyday spreadsheets. Topics include: Connecting to data sources with Power Query Cleaning improperly structured data Combining and comparing data tables Automating imports Adding data to the Data Model