You are watching: M is for monkey
Power query is one ingredient of the strength BI (Business Intelligence) product indigenous Microsoft, and “M” is the name of the programming language developed by it. As much more business intelligence pros begin using strength Pivot, they discover that they carry out not have actually the Excel an abilities to clean the data in Excel; power Query solves this problem. This publication shows exactly how to usage the strength Query device to get difficult data sets right into both Excel and also Power Pivot, and is solely dedicated to strength Query dashboarding and reporting.
ns was amazed at what ns learned in this book. I have been utilizing Excel power Query because that a year and also I had actually missed so countless features. After analysis the very first 7 chapters of this book, i was law a seminar because that a client. They had actually a horrible-looking document being developed by Oracle. It take it an intern almost a totality day to clean the document so it was usable. In much less than 10 minutes with Power Query and also my new-found tools, we had actually cleaned the whole file. The monthly process will currently take 2 clicks rather of eight ns was amazed in ~ what ns learned in this book. I have been using Excel power Query for a year and I had actually missed so plenty of features. After reading the first 7 chapters the this book, i was law a seminar because that a client. They had a horrible-looking record being created by Oracle. It take it an intern nearly a entirety day come clean the file so it was usable. In less than 10 minutes with Power Query and my new-found tools, we had cleaned the entire file. The monthly process will currently take 2 clicks instead of eight hours. If over there was ever a book that would revolutionize white-collar productivity with Excel, this is the book. ...more
flag 6 likes·Like·see testimonial
january 15, 2017 Meg rated it really chosen it · review of one more edition
Shelves: non-fiction, owned, technical
A great introduction to progressed data querying utilizing Excel's power Query because that ETL or further evaluation in Excel. I'm an commercial accountant who has actually used Microsoft Query come extract data indigenous ERP solution for the previous eight years. I recently moved right into a BI role with an SME so am trying to concerned grips with a MS power BI and also Powerpivot. As a beanie quite than an it person, strength Query and also Powerpivot are the finest tools I've ever before used because that extracting data and also I look forward to proceeding to acquire bette A good introduction to progressed data querying using Excel"s strength Query because that ETL or further analysis in Excel. I"m an commercial accountant who has actually used Microsoft Query to extract data from ERP solution for the past eight years. I freshly moved right into a BI duty with an SME so to be trying to pertained to grips v a MS power BI and Powerpivot. As a beanie rather than an that person, strength Query and also Powerpivot room the finest tools I"ve ever used for extracting data and I look forward to proceeding to get far better with them.This publication is a great how-to guide and also made far more sense than the MS guide online. The writer throws in some advantageous code which replicates Excel attributes in M language which ns found useful coming indigenous an Excel background. ...more
flag 3 likes·Like·see review
Feb 13, 2019 Stefan Shirley rated that it was exceptional · testimonial of another edition
Shelves: intellectual-wellness, occupational-wellness
Quite maybe the most an effective "how-to" guide out there. I'm not an expert in excel but know sufficient to it is in dangerous. When I learned around Power ask (Power Pivot), i was puffy away. This publication helps individuals at every levels understand the basics of PQ and also how come implement the ideas with family member ease. The authors administer working data together well. This isn't simply a step-by-step guide but a tool to assist users think second and 3rd order impacts of data mining. Kudos Ken Puls and Miguel Escobar for providing Quite possibly the most an effective "how-to" guide out there. I"m no an experienced in excel yet know enough to be dangerous. When I learned around Power query (Power Pivot), ns was blown away. This publication helps customers at all levels know the basics the PQ and also how to implement the principles with relative ease. The authors administer working data together well. This isn"t just a step-by-step guide yet a device to assist users think 2nd and third order impacts of data mining. Kudos Ken Puls and Miguel Escobar for giving such a an excellent tool! ...more
an excellent intro come learn about Power Query. Many of the instances used a an extremely detailed and well explained. I like the practical approached the Ken and also the papers available. This publication is a great stepping stone to walk towards more advanced strength Query skills.
flag Like·see evaluation
Sep 25, 2020 Christoph Weber rated it chosen it · evaluation of one more edition
Shelves: computers, non-fiction
Was great for beginners, strength query readjusted a lot due to the fact that this book came out, so that was good that i knew which components I can skip. But it was likewise kinda negative because there to be not lot in over there that ns didn't understand (if no in detail maybe). Was good for beginners, strength query changed a lot because this book came out, so that was an excellent that ns knew which parts I could skip. Yet it was also kinda negative because there to be not lot in over there that i didn"t understand (if not in information maybe). ...more
flag Like·see evaluation
january 15, 2021 JeremyDanger rated the it was amazing
In my opinion this very practical book is a must read because that anyone making use of Excel in 2021, not just Data Monkeys. Because that anyone making use of Excel the relocate to power Query is as far-ranging as moving from a candle come the irradiate bulb.
Terrific and informative readTerrific and also informative review with an excellent incentives and also encourages you much more beyond the book itselfLook front to learning much more
Brilliant resource for a novice choose me So much beneficial information and also well structured to taste the demands of both novices and also power users alike. Fine worth the check out
See more: Anti-Addiction Online Time Outs Are Now Live In China, Limit Play Time
Very helpfulVery straightforward to follow, good structure, an excellent content. An extremely useful! i really recommend this publication to people who are brand-new to data extraction topic through the power Query.