At Last! Microsoft have FINALLY brought Power Query to the Mac platform. It’s not as fully-featured as its Windows counterpart but it’s a great start and to celebrate I delivered a live training session covering most of the key aspects of using Power Query on a Mac

Links to the video and individual sections below

Introduction

What is Power Query?

Importing Data

Refreshing Data

Using the Query Editor to Clean Data

Creating Calculated Columns

Unpivot

Append Queries

Merge Queries