Buy new:
-37% $21.99
FREE delivery Sunday, May 12 on orders shipped by Amazon over $35
Ships from: Amazon.com
Sold by: Amazon.com
$21.99 with 37 percent savings
List Price: $34.95

The List Price is the suggested retail price of a new product as provided by a manufacturer, supplier, or seller. Except for books, Amazon will display a List Price if the product was purchased by customers on Amazon or offered by other retailers at or above the List Price in at least the past 90 days. List prices may not necessarily reflect the product's prevailing market price.
Learn more
Get Fast, Free Shipping with Amazon Prime FREE Returns
FREE delivery Sunday, May 12 on orders shipped by Amazon over $35
Or fastest delivery Wednesday, May 8. Order within 23 hrs 35 mins
In Stock
$$21.99 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$21.99
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Amazon.com
Ships from
Amazon.com
Sold by
Amazon.com
Sold by
Amazon.com
Returns
Eligible for Return, Refund or Replacement within 30 days of receipt
Eligible for Return, Refund or Replacement within 30 days of receipt
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Returns
Eligible for Return, Refund or Replacement within 30 days of receipt
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Payment
Secure transaction
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
$16.98
Readable book with typical wear and small creases. Part of cover is torn. No writing or marks- has not been used. paperback Used - Acceptable Ships fast! 2019Second edition Readable book with typical wear and small creases. Part of cover is torn. No writing or marks- has not been used. paperback Used - Acceptable Ships fast! 2019Second edition See less
FREE delivery May 14 - 15. Details
Or fastest delivery May 7 - 13. Details
Only 2 left in stock - order soon.
$$21.99 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$21.99
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Access codes and supplements are not guaranteed with used items.
Ships from and sold by 8 trax media.
Amazon book clubs early access
Loading your book clubs
There was a problem loading your book clubs. Please try again.
Not in a club? Learn more
Amazon book clubs early access

Join or create book clubs

Choose books together

Track your books
Bring your club to Amazon Book Clubs, start a new book club and invite your friends to join, or find a club that’s right for you for free.
Explore Amazon Book Clubs
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the authors

Miguel Escobar
Follow
Ken Puls
Follow
Something went wrong. Please try your request again later.

Master Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow Second edition

by Miguel Escobar (Author), Ken Puls (Author)
4.6 4.6 out of 5 stars 168 ratings
See all formats and editions
{"desktop_buybox_group_1":[{"displayPrice":"$21.99","priceAmount":21.99,"currencySymbol":"$","integerValue":"21","decimalSeparator":".","fractionalValue":"99","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"8CfgbkIqDrPEJIY1Bq8ztKVfxAUCFbnqkm7HJmr3oB%2BGz7Gk%2FS3DoAPsKnlISqkIbK0Nf4tVBy8C118NOKj1nQlQpVPQuE9R7b%2BmaHovLS9B8dbIRp2sjr39LsVFtlMHquasOIXuvDLxkzJ4a9yyTg%3D%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$16.98","priceAmount":16.98,"currencySymbol":"$","integerValue":"16","decimalSeparator":".","fractionalValue":"98","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"8CfgbkIqDrPEJIY1Bq8ztKVfxAUCFbnqEJVSZIiPuPW7HmFmd08ymUvVcNy4nvYQxVji6iGUuRC4DyVeq%2Ff%2BNWcYAjkoUh3vDGbxWP0TgcviJasDN%2BjbUEFwhL0vDwKgLFvDceEgmdW6CzXZzaheFN0wcivpMGXLqyJBN84pPNddmlINuNULSQ%3D%3D","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

Power Query is the amazing new data cleansing tool in both Excel and Power BI Desktop. Do you find yourself performing the same data cleansing steps day after day? Power Query will make it faster to clean your data the first time. While Power Query is powerful, the interface is subtle—there are tools hiding in plain sight that are easy to miss. Go beyond the obvious and take Power Query to new levels with this book.
Previous page
  1. ISBN-10
    1615470581
  2. ISBN-13
    978-1615470587
  3. Edition
    Second edition
  4. Publisher
    Holy Macro! Books
  5. Publication date
    July 1, 2019
  6. Language
    English
  7. Dimensions
    8.25 x 0.8 x 10.75 inches
  8. Print length
    369 pages
  9. See all details
Next page
Amazon First Reads | Editors' picks at exclusive prices

Frequently bought together

Master Your Data with Power Query in Excel and Power BI: Leveraging Power Query to Get & Transform Your Task Flow
$21.99
Get it as soon as Sunday, May 12
In Stock
Ships from and sold by Amazon.com.
+
Supercharge Power BI: Power BI is Better When You Learn To Write DAX
$27.99
Get it as soon as Sunday, May 12
In Stock
Ships from and sold by Amazon.com.
+
The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edi
$35.55
Get it as soon as Sunday, May 12
In Stock
Ships from and sold by Amazon.com.
Total price:
To see our price, add these items to your cart.
Details
Added to Cart
Choose items to buy together.

Editorial Reviews

About the Author

CA

Product details

  • Publisher ‏ : ‎ Holy Macro! Books; Second edition (July 1, 2019)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 369 pages
  • ISBN-10 ‏ : ‎ 1615470581
  • ISBN-13 ‏ : ‎ 978-1615470587
  • Item Weight ‏ : ‎ 1.45 pounds
  • Dimensions ‏ : ‎ 8.25 x 0.8 x 10.75 inches
  • Customer Reviews:
    4.6 4.6 out of 5 stars 168 ratings

About the authors

Follow authors to get new release updates, plus improved recommendations.
Previous page
  1. Miguel Escobar

    Miguel Escobar

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Miguel Escobar one of the founding partners of Skillwave.Training, and the principal of Powered Solutions, a Microsoft Gold Partner in Panama. Miguel is an Excel specialist turned Business Intelligence expert using the latest tools from Microsoft – Power BI.

    You can find him on twitter @EscobarMiguel or on LinkedIn https://www.linkedin.com/in/escobarmiguel90/

    See more on the author's page
  2. Ken Puls

    Ken Puls

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    KEN PULS, FCPA, FCMA, is the president of Excelguru Consulting Inc, a company dedicated to helping users get the most from their data. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them.

    Ken is a blogger, author and trainer with over 20 years of corporate accounting and IT experience. He is one of the world’s leading experts in Microsoft Excel, Power Query and Power BI, and provides live and online training to clients around the world.

    In recognition of his contributions, Ken has held the prestigious Microsoft MVP distinction since 2006 in both the Excel and Data Platform categories.

    Learn more about Ken at https://ca.linkedin.com/in/kenpuls, and follow him on Twitter (@kpuls) and Facbook (@xlguru)

    See more on the author's page
Next page

Customer reviews

4.6 out of 5 stars
4.6 out of 5
168 global ratings

Top reviews from the United States

Little Labrador
5.0 out of 5 stars Worth buying even if you have M is for Data Monkey
Reviewed in the United States on December 10, 2023
Verified Purchase
Data Monkey was great so I didn't buy this book for a few years. I've had projects recently that had me pulling Data Monkey off the shelf. In flipping through Data Monkey again, I realized I should work through it again as a refresher. Rather than do that, I decided to get this updated version. It was a good investment. In addition to covering material on newer developments, some of the cleaning techniques have been refined and expanded. Overall, I'd recommend it even if you have M is for Data Monkey.

Like another reviewer, some of the grammar drives me bananas. I didn't take a star off, but they should do better than this.
Helpful
 Report
NS Lee
5.0 out of 5 stars Essential for those new to Power Query.
Reviewed in the United States on October 13, 2023
Verified Purchase
For those who are starting out with Power Query, this is a must-read. Very clear explanations. Personally I would have liked to see a lot more details regarding the M language, even a whole section on programming with M with an in-depth exploration of the execution model and functional programming with M since it is not immediately obvious how to use the full power of its syntax and functions in its library. Especially accessing a REST API with M is very esoteric. You'll find explanations online, but a book like this would do much better job at explaining this particular use case IMHO considering that the authors have a very clear and didactic way of writing.
2 people found this helpful
Helpful
 Report
Gregory Truby
5.0 out of 5 stars Highly Recommend
Reviewed in the United States on December 11, 2021
Verified Purchase
No, Ken and Miguel don't have me on commission. But even if they did, I could not be more sincere in my recommendation for their latest version of their Power Query reference book.

I had purchased the original title shortly after it was published and that version was very good. But a change in jobs meant that I no longer needed to be a power query ninja and what I had learned atrophied over the years. Cut to a couple of months ago and my job responsibilities changed dramatically and I found myself needing Power Query skills again. And to my extreme pleasure I found that a new edition of their book was just being published. I bought a couple of other PQ and Power BI books and while they're also good, none takes the place of Ken & Miguel's work here. Their practical "in-the-trenches" experience shows through time and again as they point out little places where you are likely to "stub your toe" as you are trying to get things accomplished in the real world.

They walk you through lots of good examples using the data sets you download from the internet. Do they cover every single item in the Power Query universe? No, I'd love to see an exercise on doing incremental loads and a couple of other little things. But overall, they cover a LOT, and they cover it very well. At least as of late 2021, all of the screenshots, etc. are very current.

If you are trying to bootstrap yourself on Power Query or trying to improve your skills in PQ, I would recommend this book without reservation.
7 people found this helpful
Helpful
 Report
Nader S
5.0 out of 5 stars Demystifies ambiguity with good explanation and detailed hands-on examples!!!
Reviewed in the United States on September 27, 2023
Verified Purchase
I am a small business owner and gained business insights of my own quickbooks dataset using Power BI. I generated very powerful reports with Power BI but needed more understanding of data shaping using Power Query.
I decided to go for PL-300 certification and for the exam preparation this book has been extraordinary help.
3 people found this helpful
Helpful
 Report
T. A. McCluskey, MA, CH, CI
5.0 out of 5 stars Good intro book
Reviewed in the United States on September 3, 2023
Verified Purchase
Good intro book to Power Bi.
One person found this helpful
Helpful
 Report
Mark Walter
5.0 out of 5 stars This book is making Power Query my new data super power
Reviewed in the United States on December 19, 2021
Verified Purchase
This book does a great job walking the reader through the user interface in PQ as well as more hands on use of the M language. The chapters are fairly condensed and very clear and factual. As a business side non-programmer, this book is written at just the right ‘technical speak’ for me to comprehend and pick up some pretty amazing gains in my understanding of PQ. I enjoyed learning the details behind the product, as well as picking up a ton of new practical applications that will benefit my work with data. Thank you Ken and Miguel!
One person found this helpful
Helpful
 Report
Robert Lee
5.0 out of 5 stars For intermediate PQ users
Reviewed in the United States on January 5, 2022
Verified Purchase
I waited this book for two years, pre-ordering in 2019 I believe, and it did not disappoint. In addition to the enhanced beginning level it now covers, this book also gets into understanding M coding better, which helps readers at intermediate level tremendously. By "enhanced beginning level", I meant it looks at generating queries in a holistic way, i.e. building complex queries from the ground up. This book is best fit for PQ users who have a few years of working experience of using PQ.
2 people found this helpful
Helpful
 Report
Mark Hulderman
5.0 out of 5 stars An Excellent Book - A Must-Have for anyone wishing to learn Microsoft's Power Query
Reviewed in the United States on February 23, 2023
Verified Purchase
This book covers in-depth the subject of Power Query within Excel and Power BI.
It's affordably priced and filled with well documented examples.
It's without question the best book I've found on the subject.
2 people found this helpful
Helpful
 Report

Top reviews from other countries

Translate all reviews to English
Grainne D.
5.0 out of 5 stars Invaluable resource for Power Query
Reviewed in Canada on December 4, 2021
Verified Purchase
This book clearly sets out the basics - such as a definition for 'binary' data type - it just means its a file. It gives step by step instructions for each example and has downloadable example files to practice. While it covers basic items thoroughly, it also gets into much more advanced stuff, such as query folding, MCode and parameters. Even those quite familiar with PQ will find this book a great source. I recommend it for those new to PQ and for more advanced users.
Report
Cliente Amazon
5.0 out of 5 stars Sentando las bases de Power Query
Reviewed in Spain on July 1, 2023
Verified Purchase
Libro valioso para todos que como yo, siendo ‘data worker’, quieren hacer la transición desde formulación avanzada en Excel al siguiente paso de modelización en DAX, y para eso, el paso intermedio obligatorio es empezar a dominar Power Query. Este libro asienta los primeros pasos para entender Power Query.
Report
Guy Roland
5.0 out of 5 stars Livre facile à comprendre pour maîtriser PQ et créer des modèles de données performants.
Reviewed in France on January 1, 2023
Verified Purchase
En fait, la préparation des données est extrêmement importante pour avoir un modèle de données performant.
En général, l’accent est uniquement mis sur DAX mais Power Query est à maîtriser obligatoirement et ce livre en expose les concepts de façon simple et claire.

Power Query s’utilise dans Excel, Power BI mais aussi dans SSIS et les dataflows. Une raison suffisante d’apprendre à cet outil.

Ce livre est facile à comprendre et très pratique. Il est destiné à tout le monde: de l’analyste business au professionnel de sql. De nombreux exemples et astuces sont fournies. Bien sûr, il faudrait prendre le temps de mettre en pratique ce qui y est exposé.

Utiliser des fichiers texte, excel, requêtes sql dynamiques, tables d’un site web, etc. Tous ces cas sont traités.

Indispensable pour tout analyste de données.
Report
m1rzav
5.0 out of 5 stars Power Query legacy book!
Reviewed in Germany on February 4, 2022
Verified Purchase
What to say… first edition was amazing, second even better. For everyone that are into Excel, Data, this is must have!!!!
Customer image
m1rzav
5.0 out of 5 stars Power Query legacy book!
Reviewed in Germany on February 4, 2022
What to say… first edition was amazing, second even better. For everyone that are into Excel, Data, this is must have!!!!
Images in this review
Customer image
Customer image
Report
Denise Holly Dunne
5.0 out of 5 stars Accessible, engaging, clear- perfect resource for learning PQ
Reviewed in the United Kingdom on December 18, 2021
Verified Purchase
Love the way its structured, easy to follow, and the links to online files to follow along with are super useful. Im only about half way through and have already picked up enough to have implemented several time saving data cleaning processes in my day job.
One person found this helpful
 Report