M Is for Monkey

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.

Ken Puls is the controller/director of IT at the Fairwinds Community & Resort on Vancouver Island, British Columbia. He also runs Excelguru Consulting Inc, a company dedicated to helping users get the most out of Microsoft Excel, and is a winner of the prestigious Microsoft MVP – Excel award. He lives in Vancouver. Miguel Escobar is an Excel MVP and a consultant and expert on business intelligence, PowerPivot, Excel, Power View, and SharePoint. He is the author of Formulas DAX para PowerPivot.