Modern Data Handling with Power Query in Excel - Seminar
Modern Data Handling 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