M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query

Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and "M" is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this problem. This book shows how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot, and is solely devoted to Power Query dashboarding and reporting.

Audience
adult
Length
medium · 212 pages

Click a tag to see books like this one that share it. Point at it (on a phone, tap it) for less of it instead.

Read it? Sign in to help tag it.

Liked M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query? Here’s where I’d start.

These suit anyone who liked M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query. Sign in and mark a few books for picks shaped around your own taste.

  1. DAX Formulas for PowerPivot: The Excel Pro's Guide to Mastering DAX Shares excel
  2. Excel 2010 Power Programming with VBA Shares excel
  3. Excel Dashboards & Reports Shares excel
  4. Excel 2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf) Shares excel

“If you want more of the same, start with these.”

  1. Practical Reverse Engineering
  2. Bricklin on technology
  3. Electric Circuits
  4. Custom CGI Scripting with Perl

“If it was the excel that hooked you, try one of these.”

  1. Excel Formulas and Functions for Dummies
  2. Excel VBA Programming For Dummies

“These start from a similar idea, even if they go somewhere else with it.”

  1. Python for Everybody
  2. Business Objects
  3. Computer Science Programming Basics in Ruby
  4. Inside Microsoft SQL Server 2005: T-SQL Querying