FormulaCamp
Completed
← Full curriculum
Track 9 · Analyst

Power Query

ETL without formulas: load, clean and combine data, and write M code.

2 free lessons

0 of 8 completed · about 2.8 h

Start

8 lessons left until your certificate

Introduction

  1. 1Power Query: What It Is and Why Use ItFreetheory and quiz15 min

The Query Editor

  1. 2Power Query: Cleaning an ExportFreelesson25 min
  2. 3Power Query: Append, Merge, and Group Bylesson25 min
  3. 4Power Query: Unpivot and Totalslesson20 min

Sources, Errors, and M

  1. 5Power Query: Importing CSV, Folders, and the Weblesson25 min
  2. 6Power Query: Pivot Columnlesson20 min
  3. 7Power Query: Handling Errorslesson20 min
  4. 8The M Language: How to Read a Querytheory and quiz15 min