- Paperback: 368 pages
- Publisher: Microsoft Press,U.S.; 1 edition (25 October 2018)
- Language: English
- ISBN-10: 1509307958
- ISBN-13: 978-1509307951
- Product Dimensions: 18.8 x 2.5 x 22.6 cm
- Boxed-product Weight: 689 g
- Average Customer Review: 1 customer review
- Amazon Bestsellers Rank: 17,177 in Books (See Top 100 in Books)
Other Sellers on Amazon
+ FREE Delivery
+ $11.33 Delivery
Collect, Combine, and Transform Data Using Power Query in Excel and Power Paperback – 4 Nov 2018
|New from||Used from|
Customers who bought this item also bought
Customers who viewed this item also viewed
About the Author
Gil Raviv is a Microsoft MVP and a Power BI blogger at https://DataChant.com. As a Senior Program Manager on the Microsoft Excel Product team, Gil led the design and integration of Power Query as the next-generation Get Data and data-wrangling technology in Excel 2016, and he has been a devoted M practitioner ever since.
With 20 years of software development experience, and four U.S. patents in the fi elds of social networks, cyber security, and analytics, Gil has held a variety of innovative roles in cyber security and data analytics, and he has delivered a wide range of software products, from advanced threat detection enterprise systems to protection of kids on Facebook.
In his blog, DataChant.com, Gil has been chanting about Power BI and Power Query since he moved to his new home in the Chicago area in early 2016. As a Group Manager in Avanade’s Analytics Practice, Gil is helping Fortune 500 clients create modern self-service analytics capability and solutions by leveraging Power BI and Azure.
You can contact Gil at firstname.lastname@example.org.
Showing 1-1 of 1 reviews
There was a problem filtering reviews right now. Please try again later.
Most helpful customer reviews on Amazon.com
On New Years evening I tried to open it again but got dirty looks from my sweetie. But honey, I explained, this is the champagne that turns my ugly work days into gold. She squeezed my hand (the one with the mouse in it), looked deep into my eyes and told me it's time to Collect, Combine, and Transform.
This is a complete guide to Power Query. Gil orders the book along key goals. For example, basic data prep, preserving context, and collaboration. This order not only streamlines learning, but it also teaches key concepts. The book begins with the user interface. From there, it leads into editing formulas. It also deftly supports best practices for data models. Only after this base does it introduce M code. And from there, it delves into pitfalls, text analysis, and social media.
However, this book is not only for the novice. It’s filled with all kinds of gold for the adept. In the first half of the book, I learned at least five cool things. And even if you know plenty, it is always great to get a high level view and fill in the gaps. For me, it is one of the essential books for Microsoft self-help data tools.
What this book is not. It's not an intro to Excel or Power BI. This book will not teach you DAX or data modeling. For that, I recommend Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel. In addition, there are a number of techniques that I use which are not covered in the book. For that, I read blogs. At some point, Gil or someone may write a definitive guide to Power Query.
So, I’m looking forward to improving my grasp of the basics. And I’m also eager to learn even more. I’m glad to have this book on my desk even if my colleagues want to borrow it now and then.
I pledge to always use the power of Power Query for good, not evil. And this book will help you unleash that formidable power!
When first encountering the Power Query it seems close to excel (more like excel adjacent) but for someone who is more or less an excel expert, the differences become quickly apparent. Differences that at first can be intimidating. But the way Gil start slow and ramps up to more advanced topic makes it is no longer intimidating. Power Query goes from intimidating to “guess this is ok” to “oh, I see how this can work” to “this is awesome!” to “I wonder if I could do xyz?”. The files that come with the book will always be there for your reference too. I think most would be best served to do active learning with this book. Reading it in bed or wherever is fine, but I’d go back and go step by step and actually do it. It’s like learning to swim. You can read every book on the topic, but till you are in the water you will not actually learn.
Also, if you are venturing into the world of DAX, using Power Query to transform your data makes the DAX so much easier to write. And with these streamlined DAX formulas, they are faster, prone to less errors, and much easier to troubleshoot when errors to appear.
With that being said, Power Query (and the M language) does have its challenges. But these challenges are what makes it fun. Much like a lot of things in life you get out of it what you put in. I have no doubt that just the first few chapters will transform (no pun intended...) your day to day tasks. I also have no doubt that once you get done with those first few chapters, you won’t want to stop.
In addition, Gil Raviv the author, emails Bonus exercises to expand your skill. He responds to questions pretty quick.
The book Q&A site has related answers you can quickly find when you have questions.
His blog has some interesting Power Query and Power BI topics.