Free PDF M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query
This letter might not affect you to be smarter, yet the book M Is For (Data) Monkey: A Guide To The M Language In Excel Power Query that we offer will stimulate you to be smarter. Yeah, at least you'll recognize greater than others which don't. This is what called as the top quality life improvisation. Why must this M Is For (Data) Monkey: A Guide To The M Language In Excel Power Query It's considering that this is your preferred theme to review. If you such as this M Is For (Data) Monkey: A Guide To The M Language In Excel Power Query style about, why do not you review guide M Is For (Data) Monkey: A Guide To The M Language In Excel Power Query to enrich your conversation?
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query
Free PDF M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query
Subsequent exactly what we will provide in this short article regarding M Is For (Data) Monkey: A Guide To The M Language In Excel Power Query You understand truly that this book is coming as the best vendor book today. So, when you are actually a great viewers or you're fans of the writer, it does will be amusing if you do not have this book. It indicates that you have to get this publication. For you who are beginning to learn more about something new and feel interested concerning this book, it's simple after that. Simply get this book and also really feel just how this publication will certainly give you much more exciting lessons.
This is a really reasonable publication that ought to read. The following might provide you the method to get this book. It is in fact ease. When the other people have to walk around and also go outside to obtain the book in the book store, you can simply be by visiting this website. There is provided web link that you can find. It will lead you to go to guide web page and also obtain the M Is For (Data) Monkey: A Guide To The M Language In Excel Power Query Finished with the download and get this book, begin to read.
Reading publications will not obligate you to complete it in a day. After your reading publication now, M Is For (Data) Monkey: A Guide To The M Language In Excel Power Query can be the selected book to be. We recommends due to the high quality of this publication. It includes something new and also different. You may not need to believe considerably, but simply read and also you will certainly see why this book is much recommended.
You could carefully include the soft data M Is For (Data) Monkey: A Guide To The M Language In Excel Power Query to the gadget or every computer hardware in your office or home. It will certainly aid you to always continue reading M Is For (Data) Monkey: A Guide To The M Language In Excel Power Query whenever you have spare time. This is why, reading this M Is For (Data) Monkey: A Guide To The M Language In Excel Power Query does not offer you problems. It will certainly give you essential sources for you which wish to start composing, blogging about the comparable book M Is For (Data) Monkey: A Guide To The M Language In Excel Power Query are different book field.
About the Author
Ken Puls is the controller/director of IT at the Fairwinds Community & Resort on Vancouver Island, British Columbia. He also runs Excelguru Consulting Inc, a company dedicated to helping users get the most out of Microsoft Excel, and is a winner of the prestigious Microsoft MVP – Excel award. He lives in Vancouver. Miguel Escobar is an Excel MVP and a consultant and expert on business intelligence, PowerPivot, Excel, Power View, and SharePoint. He is the author of Fórmulas DAX para PowerPivot.
Read more
Product details
Paperback: 212 pages
Publisher: Holy Macro! Books (December 1, 2015)
Language: English
ISBN-10: 9781615470341
ISBN-13: 978-1615470341
ASIN: 1615470344
Product Dimensions:
8 x 0.5 x 10 inches
Shipping Weight: 1 pounds (View shipping rates and policies)
Average Customer Review:
4.6 out of 5 stars
82 customer reviews
Amazon Best Sellers Rank:
#18,836 in Books (See Top 100 in Books)
I had been wondering for a while (like the past year or so) what Power Query was, but I was not really finding a good, clear answer. When this book became available I got a good, clear answer. I was excited previously by Power Pivot and what was possible with it, but this book changed the way I looked at a number of my usual tasks when I thought Power Pivot was going to be the answer. Power Query provides SQL query capabilities from within Excel, and provides an excellent pathway for data to come into Excel from both external and internal sources, and the authors demonstrate those capabilities very well. This was my favorite book purchase for 2015 and I plan on using it heavily in the coming years.
Having danced around Ken Puls' ExcelGuru.ca website in moments of Power Query need I felt it was time to get back to the basics and finally learn a solid foundation as opposed to jumbled pieces put together over time. The one thing that I will say about this book is there is a LOT of information packed into 226 pages from getting started to the much more advanced topics found in the later chapters. Several times my eyes were almost in disbelief at the potential of Power Query (Get & Transform) and how I could immediately start putting this into action at the day job. Having an earlier edition of the book I realized several times throughout that Microsoft's improvements have eliminated some of the more tedious steps of Power Query past. Both Ken and Miguel's overall tone throughout the book was also a testament to respecting their audience's Excel experience and going in depth only as needed to allow each lesson to continue to build on one another.I would highly recommend this book to anyone in a Data Analyst or Reporting Analyst role.
Probably the only decent book out there that is specifically geared to the power query model. I was looking for a solution to merge two QuickBooks reports I had dumped out to CSV files. This book solved my problem. Can't beat that. If you are a QB user and hate the Advance Report engine, dump that junk and dig into power query.11/22/16: I have since used PQ extensively since acquiring this book. This is a great starter book, but I quickly flew past it into more complicated areas not covered by this edition. There is a whole lot of stuff Ken and Miguel can go into in a follow up book. They should look at publishing an edition that focuses on the Mashup Query Language solutions itself as a companion to the this book.
I bought this book with the expectation that I needed to know M and that I would start learning M from the beginning of this book. But this book does an excellent job of demonstrating why the Power Query user interface is so powerful, and why -- although you sometimes do need to write M code -- the UI is still your starting point. By the time I reached chapter 6 (unpivoting a table) I felt the book had already paid for itself... and there's way more to come.
Good book on M, it successfully straddles the how and why. This may be the only definitive guide on M out there at the moment, I'm not sure how I got by without Power Query for as long as I have. There are some useful books on DAX (this is NOT a book on DAX), but don't overlook the role of pre-shaping and automating your data model. Power Query is one of those things that once you get it, you just get it. This was the first book I purchased on my recent journey into Power BI, and I'd do it all again. Bought the Kindle version, and after getting through it, I bought the physical book. It's that useful.
I learned about the multiple uses of Power Query about a year ago and it has revolutionized my data analysis skillset. The stuff I can do with PQ now is unbelievable whereas beforehand, it was impossible. I can take reports from a .txt and do wizardry through PQ and create a proper dataset that can then be summarized. I can do this each month now and be done literally within minutes. This book teaches the wizardry for becoming a data magician. Well worth my money.
Awesome reference - I have used it so much that it is ragged and frayed! And what's neat is that everything that you learn about Power Query (PQ) is translatable to Excel Power BI (where it found as Get Data). I like to describe PQ as the "Excel import wizard on steroids" and it is invaluable to those of us that use/combine/mash together data from disparate sources. This reference has the broadest and deepest compilation of PQ "stuff" out there. Couple that with a well keyed Google/Bing search and you can easily find a way to your data end point.
Power Query, although it's been around for a few years now, is just coming into its own, and there aren't many books on the subject. So for Excel users wanting to know more about Power Query, Ken & Miguel have done a great job of collecting what you need to know to save yourself A LOT of time automating the transforming, cleaning, & loading of data. They focus on teaching Power Query through examples that will be recognizable to anyone who deals with data on a regular basis. For all the Excel users out there that are just discovering Power Pivot, do yourselves a big favor and go ahead and get familiar with Power Query as well - this is a good book to have on your shelf.
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query PDF
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query EPub
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query Doc
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query iBooks
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query rtf
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query Mobipocket
M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query Kindle
