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