Master Your Data With Power Query in Excel and Power BI - PDF e-book

Leveraging Power Query to Get & Transform Your Task Flow

The expanded and revised second edition of M is for Data Monkey. 

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


More Details Try Demo

Affiliates

Like this product?

Spread the word about it and earn 20.00% of the purchase price on sales you refer.

Join our affiliate program

14.69MB PDF Download

USD 17.99


Question? Contact Us