M is for (Data) Monkey: The Excel Pro's Definitive Guide to Power Query
- 4h 1m
- Ken Puls, Miguel Escobar
- Tickling Keys
- 2016
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.
About the Author
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 Fórmulas DAX para PowerPivot.
In this Book
-
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
