Why this chapter matters
Automated data shaping reduces recurring errors and saves analyst time every reporting cycle.
What you will learn
- Connect to CSV, workbook, and folder sources for recurring imports.
- Apply common transforms such as split, merge, type assign, and unpivot.
- Refresh and document query steps so others can maintain them.
Lessons in this chapter
- Query connectionsLoad data from repeat sources with stable connectors.
- Transform step designChain deterministic cleanup steps in the query editor.
- Append and mergeCombine monthly files and reference tables with key-based joins.
- Refresh operationsPublish reliable refresh workflows for routine reporting. Read the full guide →
Study task
Create a Power Query flow that combines monthly sales files from a folder and outputs a typed analysis table.
Chapter checkpoint
Why is keeping query steps explicit useful for teams?
Each step documents the transformation logic, which makes the pipeline reviewable, repeatable, and easier to troubleshoot.