Data Preparation

Unpivot

"Wide table format," "Dates or months spread across column headers,"

Unpivot

"Attributes normalized into rows."

Pivot

"Aggregate repeated row values into distinct column headers,"

Pivot

"Convert tall key-value pairs into a summary grid."

Merge Queries

"Combine columns from two tables,"

Merge Queries

"SQL Join," "Lookup values based on a matching key ID."

Append Queries

"Combine rows from multiple tables,"

Append Queries

"SQL UNION," "Combine monthly or regional files with identical columns."

Group By

"Reduce total row count in Power Query before loading,"

Group By

"Pre-aggregate granular data at a higher summary level."

Enable Query Folding

"Push processing back to the source server," "Optimize SQL source query,"

Enable Query Folding

"Delegate transformation to database."

Disable “Enable Load”

"Staging table," "Intermediate calculation table,"

Disable “Enable Load”

"Do not duplicate data in the data model memory."

Column Profile/Quality

"Identify percentage of Nulls, Errors, or Empty values,"

Column Profile/Quality

"Spot outlier values across the full dataset."

Distinct

"Total count of non-duplicate values"

Unique

"Values that appear exactly once"