Master Your Data with Power Query in Excel and Power BI


August 2021

Master Your Data with Power Query in Excel and Power BI

Use Power Query to Bring Out Your Inner Data Ninja

Power Query is a game-changer for anyone importing and transforming data in Excel.

Bill Jelen, MrExcel
Add to Cart: $17.99 »

category: Power Query
covers: Microsoft 365, Excel 2019, Power BI

Product Details
  • 369 Pages
  • Publisher: Holy Macro! Books
  • ISBN: 978-1-61547-058-7
  • PDF ISBN: 978-1-61547-241-3

Despite the moniker "data monkey," we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time. When it comes to importing, cleaning and transforming data to get it ready for analysis, you can learn Power Query faster than you can learn Excel formulas, and it handles complex sources much more easily than VBA. There is no doubt in our minds that Power Query will change the way Excel pros work with data forever. If you are using Excel on a Windows PC, Power Query is available to you. This book will teach you pro tips for getting the most from Power Query.

  • 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

Where to Buy

MrExcel Bookstore

eBook from MrExcel.

MrExcel Bookstore

Print book from MrExcel

Amazon

Print book from Amazon


Other Editions


M is for (DATA) MONKEY

December 2015

Despite the moniker "data monkey", we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.


Related Products


Power Pivot and Power BI

January 2016

Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data.


Supercharge Power BI - 3rd Edition

February 2021

Released in 2021, this book will teach you the DAX language from the ground up, using Power BI as your canvas.


Microsoft 365 Excel: The Only App That Matters

June 2022

Excel Worksheet, Power Query, Power Pivot, Power BI. Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight!