Microsoft Excel 3: ETL with Power Query in Excel
Microsoft Excel 3: ETL with Power Query
Description
The most critical starting point for a successful spreadsheet is clean, accurate, and current data. The most effective and modern way to accomplish this task is with a newer feature of Excel called Power Query. With Power Query, we perform operations that Extract, Transform, and Load (ETL) data from the original source into our workbook.
Topics include:
- Understanding Power Query in the context of an Excel workbook
- Extracting data from various sources
- Performing transformations on dirty data
- Combining and comparing data
- Setting up automated refreshes of external data