Data cleaning · Medium
What is Power Query and when should you use it?
Short answer
Power Query is Excel's built-in tool for importing and transforming data with recorded, repeatable steps — split columns, change types, merge and append tables, unpivot. Use it whenever you clean the same kind of file repeatedly; next time you just click Refresh.
Detailed answer
Typical steps: import a folder of monthly CSVs → set types → filter blanks → append into one table → load to the Data Model.
The applied steps are visible and editable, which makes the cleaning auditable — an advantage over manual edits.