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
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
Like this product?
Spread the word about it and earn 20.00% of the purchase price on sales you refer.
14.69MB PDF Download