Learn To Code Ninja

Free technical booklets — download and learn.

Part 7 of 7 in the Data Engineering with SQL Server path

Mastering Power Query booklet cover

Mastering Power Query

DOCX 2.9 MB Advanced Sep 2026

Power Query is Microsoft’s data extraction, transformation, and loading (ETL) engine built into Excel and other Microsoft analytics tools. It allows users to connect to data from a wide variety of sources, clean and shape that data through a repeatable process, and load the results into Excel tables, PivotTables, or analytical models.

What you'll learn

  • Introduction to Power Query
  • Power Query Architecture
  • Power Query vs Other Technologies
  • The Power Query Interface
Download booklet (DOCX, 2.9 MB)

Table of contents

  1. Introduction to Power Query
  2. Power Query Architecture
  3. Power Query vs Other Technologies
  4. The Power Query Interface
  5. Connecting to Data Sources
  6. Loading Data
  7. Understanding Query Steps
  8. Data Cleaning and Preparation
  9. Shaping and Restructuring Data
  10. Combining Data with Merge and Append
  11. Automation with Folder Ingestion and Parameters
  12. Security, Privacy Levels, and Credentials
  13. Performance Optimization and Query Folding
  14. The M Query Language: Foundations, Expressions, and How Power Query Really Works

You may also like

The Enterprise Architects Compendium booklet cover The Enterprise Architects Compendium Master Class On AI Prompting booklet cover Master Class On AI Prompting Mastering Git booklet cover Mastering Git