M is for (data) monkey : the Excel Pro's definitive guide to power query / by Ken Puls & Miguel Escobar.

Format:

Book

Author/Creator:

Puls, Ken, author.

Escobar, Miguel, author.

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Electronic spreadsheets--Computer programs.

Electronic spreadsheets.

Business--Computer programs.

Business.

Physical Description:

1 online resource (244 p.)

Place of Publication:

Merritt Island, FL : Holy Macro! Books, [2016]

Language Note:

English

Summary:

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:

Cover; Title Page; Copyright; Table of Contents; Foreword How Power Query Changed Our Lives; Chapter 0 Introduction: A New Revolution; Chapter 1 Importing 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 Importing 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

Notes:

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed January 13, 2016).

ISBN:

9781615473458

1615473459

9781615472239

1615472231