Collect, Combine, and Transform Data Using Power Query in Excel and Power BI

by Raviv Gil

Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it. Discover how to eliminate time-consuming manual data preparation, solve common problems, avoid pitfalls, and more. Then, walk through several complete analytics challenges, and integrate all your skills in a realistic chapter-length final project. By the time you’re finished, you’ll be ready to wrangle any data–and transform it into actionable knowledge .   Prepare and analyze your data the easy way, with Power Query ·         Quickly prepare data for analysis with Power Query in Excel (also known as Get & Transform) and in Power BI ·         Solve common data preparation problems with a few mouse clicks and simple formula edits ·         Combine data from multiple sources, multiple queries, and mismatched tables ·         Master basic and advanced techniques for unpivoting tables ·         Customize transformations and build flexible data mashups with the M formula language ·         Address collaboration challenges with Power Query ·         Gain crucial insights into text feeds ·         Streamline complex social network analytics so you can do it yourself   For all information workers, analysts, and any Excel user who wants to solve their own business intelligence problems.  

Genres: Nonfiction

431 pages, Kindle Edition

Published October 8, 2018

Reviews

[Kevin Narvaes · Rating 4 out of 5]

Really cool and overall extremely useful techiniques and applied concepts to get your data wrangling skills to the next level. The book covers many uses cases with guided examples that will prove useful on you power query journey.
I would've liked if the book spended a little more time on the comprehension of the M languages (which if you can learn to use it, it's EXTREMELY useful, however, not many resources are around, especially for advanced uses cases).
The chapters on text analytics and social media analysis were cool as well. Might get around trying some social media insights soon :).

[En · Rating 4 out of 5]

It is the best book about power query and M language I read. It describes the methods of modification UI queries to get the desired result, using custom functions and advansed M functions. But the last 25% of the book is devoted to the text analysis which is not relevant for me. So 4 stars

[Micheal Reynolds · Rating 5 out of 5]

Great book to advance your M knowledge

I found the applied practice approach very informative. M is a very powerful language and Gil makes it very accessible. He takes a building block approach where sections build upon previous sections. I was amazed at examples that use the generic methods to clean data. This book will remain as a reference guide for me for many years.

[Asim Javed · Rating 2 out of 5]

Compared to “ M is for Data Monkey” this book is not good. It’s poorly organised and author has messed up the required flow of information. Although author’s knowledge is impressive however it have less value to learners.
I hope the next edition accounts for these concerns.

[Annie · Rating 4 out of 5]

Much of the book requires the user to follow all the steps to complete the exercises and understand how Power Query is transforming the data. There are a few chapters providing general information, such as explaining M formulas and common pitfalls.

[Peeravich Paoprayoon · Rating 5 out of 5]

The only book from Microsoft Press devoting to Power Query, as far as I know.
It has a lot of examples that are readily applicable to real problems in data analysis.

[Rohit Kumar · Rating 4 out of 5]

Good book

Its great book to understand and learn M language. Very nicely explained with examples and steps.

Very useful book to have.