Newly expanded to 369 pages, this second edition of M is for Data Monkey is a complete guide to using Power Query in Excel and Power BI.

Table of Contents

Foreword

Chapter 0 - The Data Revolution

Chapter 1 - Power Query Fundamentals

Chapter 2 - Query Management

Chapter 3 - Data Types and Errors

Chapter 4 - Moving Queries Between Excel & Power BI

Chapter 5 - Importing from Flat Files

Chapter 6 - Importing Data from Excel

Chapter 7 - Simple Transformation Techniques

Chapter 8 - Appending Data

Chapter 9 - Combining Files

Chapter 10 - Merging Data

Chapter 11 - Web Based Data Sources

Chapter 12 - Relational Data Sources

Chapter 13 - Reshaping Tabular Data

Chapter 14 - Conditional Logic in Power Query

Chapter 15 - Power Query Values

Chapter 16 - Understanding the M Language

Chapter 17 - Parameters and Custom Functions

Chapter 18 - Date and Time Techniques

Chapter 19 - Query Optimization

Chapter 20 - Automating Refresh

Index