Power QueryExercises

Module 2

Importing and inspecting data

CSV, table-like Excel sheets and JSON fixtures; headers, delimiters and encodings.

You'll be able to

Lessons

  1. 1.Import CSV files: delimiters, encodings and headersTurn a delimited text file into a typed table you can trust.
  2. 2.Remove report banners before promoting headersClean the top and bottom of a report-style export so the header row is promoted correctly.
  3. 3.Inspect a JSON document before flattening itRead the shape of a JSON document and turn its main array into a table.
  4. 4.Import from Excel: tables, sheets and the navigation tablePick the right object from a workbook and get clean columns from it.

Take the importing and inspecting data quiz (8 questions)

Exercises