Power Query for Power BI and Excel

The best tool for Power BI & Excel

A tool that can help you transform raw data from virtually any data source into the form that you need. Power Query is the tool that does the trick, it’s INCREDIBLY easy to use and lightning fast.

Books about Power Query for Excel and Power BI

Power Query books authored by Excel & Power BI Pros



Packed with 100’s of diagrams, screenshots and more images.

Example Driven

Example Driven

The book has been written from a practical point of view.

Jargon Free

Jargon Free

A simple guide with easy to follow and jargon free content.

Downloadable Content

Downloadable Content

All of the example workbooks from the book can be downloaded.

Top Quality Power Query Training

If you regularly clean, reshape, transform or combine data, we have the training you need. Master the best Power BI and Excel tool for data manipulation with our courses.

Power Query Academy

A self-directed video course with over 13 hours of our top quality content, so you can master Power Query for Excel and Power BI at your own pace. This course includes:

  • 12 months of access to over 70 bite-sized videos
  • 12 months of support from our trainers on the course materials
  • Downloadable example files
  • A digital copy of our top-selling book, ‘M is for Data Monkey’ (2nd Edition)

Learn about our self-paced Video Course

Power Query and M Patterns

Check out our ready-to-use Power Query Patterns. Detailed instructions for how to prepare a Power Query solution with multiple use cases.
Conditional Logic
Date & Time


April 6, 2016


Dynamic Calendar Table

July 5, 2015


Merge Tables

April 6, 2015


Join our newsletter now and get a FREE copy of our eBook

'Magic Tricks for Data Wizards: TIps & Tricks for Power Query in Excel & Power BI'