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

9781615470341

M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query
by 作者: Ken Puls - Miguel Escobar
ISBN-10 书号: 1615470344
ISBN-13 书号: 9781615470341
Publisher Finelybook 出版日期: 2015-12-01
Pages: 212
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.
Contents
Foreword How Power Query Changed Our Lives
Chapter 0 Introduction: A New Revolution
Chapter 1 lmporting Basic Data
Chapter 2 Overriding Power Query Defaults
Chapter 3 Basic Append Operations
Chapter 4 Importing All Files in a Folder
Chapter 5 Aggregating Excel Worksheets
Chapter 6 Unpivoting Data
Chapter 7 lmporting Nondelimited Text Files
Chapter 8 Importing from Databases
Chapter 9 Merging Tables and Queries
Chapter 10 Query Loading Destinations
Chapter 11 Defining Data Types
Chapter 12 Importing Web Data
Chapter 13 Loading Data from Exchange
Chapter 14 Grouping and Summarizing
Chapter 15 Transposing and Unpivoting -Complex Data
Chapter 16 Automating Refreshing
Chapter 17 Power Query Formulas
Chapter 18 Conditional Logic in Power Query
Chapter 19 Power Query Objects
Chapter 20 Understanding the M Language
Chapter 21 Creating Custom Functions
Chapter 22 Advanced Conditional Logic
Chapter 23 Dynamic Parameter Tables
Chapter 24 Dynamic Calendar Tables
Chapter 25 Query Organization