Power Query

Power Query is Excel's data connection and transformation engine, used to import data from various sources and reshape it before it ever reaches your worksheet.

Loading Data

Data tab -> Get Data -> From File / From Web / From Database

The Power Query Editor

Once data is loaded, the Power Query Editor opens in a separate window, showing every transformation step in a recorded list on the right - this makes each change traceable and reversible.

Common Transformations

• Remove Columns - drop fields you don't need.
• Change Type - convert text to numbers, dates, and so on.
• Split Column - break one column into several based on a delimiter.
• Group By - aggregate rows, similar to a pivot table but at the source data level.
• Merge Queries - join two tables together, similar to a SQL join.

Loading the Result

Home tab -> Close & Load -> loads the transformed data into a worksheet or the Data Model