The long awaited book from Ken Puls and Miguel Escobar has just been released in digital edition. I read this book over the weekend and wanted to share my experience with anyone considering buying this book or wanting to learn more about Power Query.
This book is 220+ pages of Power Query information that covers the length and breadth of what you need to know to use this great Excel tool from Microsoft. Ken and Miguel have structured the chapters in a way that builds from the simple introductory topics up to some of the more advanced (but still easily learnable) techniques that can only be accessed when you get into the M programming language (also called the Power Query Formula Language).
Here are a few of the highlights for me from the book.
- Easy to read and has a well structured chapter layout building from the basics to the advanced.
- Broad coverage of some of the less obvious features (such as default settings) that can improve the user’s experience in using Power Query.
- Lots of tips and techniques that will help you become a super user; like pointer queries, import from named range, dynamic headers to name a few.
- And still more tips and information about “gotchas” like accidentally corrupting the data model or the dangers of the “any” data type. It explains the potential problems and how to avoid them.
- A great section on how to go about un-pivoting complex nested tables, and another on how to get data from a web page when the data itself is not in a table format.
- The book explains the differences in the UI across Excel 2010, Excel 2013 and Excel 2016.
- There are lots of comparisons between Excel functions and the equivalent Power Query functions. Given most of us already know the Excel functions, this makes it really easy to understand the new Power Query syntax.
- And finally, the book is well indexed in the table of contents and also in the Index at the back of the book. This makes the book ideal to keep as a reference guide for when you need a refresher later.
M is for Data Monkey is available for purchase and immediate download from my Online Store here.
If you want more information about Power Query, you can also read my book review of Chris Webb’s book that I wrote in July 2015.
If you prefer instructor lead learning, I have a comprehensive online training course on Power Query and the M Language. The course consists of 7.5 hours of video instructions and guides that will teach you how to use Power Query from the UI as well as using the M Language.
I went over this web site and I conceive you have a lot of excellent info, saved to favorites (:.
I found your weblog web site on google and check a number of of your early posts. Proceed to maintain up the very good operate. I simply extra up your RSS feed to my MSN Information Reader. Seeking forward to reading extra from you afterward!…
Somebody necessarily help to make critically articles I might state. This is the first time I frequented your website page and thus far? I amazed with the research you made to make this actual submit amazing. Great task!
My wife and i ended up being very more than happy when Albert could finish up his homework from your ideas he gained using your web site. It’s not at all simplistic just to find yourself handing out secrets that others may have been selling. So we see we have you to appreciate because of that. The main explanations you made, the simple web site navigation, the relationships you can give support to foster – it’s all awesome, and it is making our son and us consider that the topic is excellent, which is particularly important. Thank you for all!
Terrific work! This is the type of info that should be shared around the internet. Shame on the search engines for not positioning this post higher! Come on over and visit my website . Thanks =)
There are actually a lot of details like that to take into consideration. That could be a great point to bring up. I provide the ideas above as basic inspiration but clearly there are questions just like the one you deliver up the place the most important factor shall be working in honest good faith. I don?t know if finest practices have emerged round issues like that, but I’m certain that your job is clearly recognized as a good game. Both girls and boys really feel the affect of only a second’s pleasure, for the remainder of their lives.
Wow that was odd. I just wrote an really long comment but after I clicked submit my comment didn’t show up. Grrrr… well I’m not writing all that over again. Regardless, just wanted to say superb blog!
Some really select blog posts on this site, saved to favorites.
I’d should examine with you here. Which is not something I usually do! I enjoy studying a post that may make folks think. Additionally, thanks for allowing me to comment!
Perfect work you have done, this website is really cool with good info .
I in addition to my friends were digesting the best techniques from your web page then at once developed a horrible suspicion I never thanked the website owner for those techniques. Most of the guys were definitely consequently glad to read all of them and now have actually been having fun with those things. Many thanks for simply being indeed thoughtful as well as for using these kinds of exceptional subjects most people are really desirous to understand about. Our own sincere apologies for not expressing appreciation to sooner.
I precisely wanted to thank you so much all over again. I do not know the things I would’ve created in the absence of the type of opinions contributed by you directly on that area of interest. It has been a real distressing condition in my position, nevertheless considering the specialized strategy you handled it made me to leap over joy. Now i am happy for the support and even believe you comprehend what a powerful job you are always doing teaching some other people by way of your webpage. Most probably you haven’t got to know all of us.
Simply desire to say your article is as astonishing. The clarity in your post is just cool and i could assume you are an expert on this subject. Fine with your permission let me to grab your RSS feed to keep up to date with forthcoming post. Thanks a million and please carry on the gratifying work.
magnificent submit, very informative. I ponder why the opposite specialists of this sector don’t notice this. You should continue your writing. I am sure, you have a great readers’ base already!
Hello. impressive job. I did not anticipate this. This is a impressive story. Thanks!
I consider something genuinely special in this web site.
Realmente soy un empirico en este tema, pero este libro me ha sido demasiado valioso.
Lo tengo de referencia porque lo utilizo no solo una sino muchas veces, cada vez que voy avanzando en el conocimiento del tema.
Este es el libro a tener y algun dia me vuelva experto, se con este libro lo voy a alcanzar.
—
I am really an empiricist on this subject, but this book has been too valuable to me.
I have it as a reference because I use it not only once but many times, each time I advance in the knowledge of the subject.
This is the book to have and one day I will become an expert, I know with this book I will achieve it.
Dear Matt,
is it worth reading this book in case I have already read the book by Chris Webb?
Thanks,
Lada
That’s a hard question and is really about personal preference and learning style. If you have read Chris’ book and are competent in all of the concepts then you will only get incremental knowledge from this book from Ken and Miguel. I have read them both and got something from both. I got the most from Chris’ book but only because I read that first.