Puls Ken, Escobar Miguel. M is for (DATA) MONKEY: The Excel's Pro's Definitive Guide to Power Query

Holy Macro! Books, 2015. — 307 p. — ISBN: 978-1-61547-034-1.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.Foreword How Power Query Changed Our Lives
Introduction: A New Revolution
Importing Basic Data
Overriding Power Query Defaults
Basic Append Operations
Importing All Files in a Folder
Aggregating Excel Worksheets
Unpivoting Data
Importing Nondelimited Text Files
Importing from Databases
Merging Tables and Queries
Query Loading Destinations
Defining Data Types
Importing Web Data
Loading Data from Exchange
Grouping and Summarizing
Transposing and Unpivoting Complex Data
Automating Refreshing
Power Query Formulas
Conditional Logic in Power Query
Power Query Objects
Understanding the M Language
Creating Custom Functions
Advanced Conditional Logic
Dynamic Parameter Tables
Dynamic Calendar Tables
Query Organization