Collect, combine, and transform data using Power Query in Excel and Power BI

Summary:

"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."-- Provided by publisher.

Record details

ISBN: 9781509307951
ISBN: 1509307958
Physical Description: xxvii, 402 pages : illustrations ; 23 cm
Publisher: [United States] : published with the authorization of Microsoft Corporation by Pearson Education, Inc., [2019]
Copyright: ©2019

Content descriptions

Bibliography, etc. Note:

Includes bibliographical references and index.

Formatted Contents Note:

Introduction to Power Query -- Basic data preparation challenges -- Combining data from multiple sources -- Combining mismatched tables -- Preserving context -- Unpivoting tables -- Advanced unpivoting and pivoting of tables -- Addressing collaboration challenges -- Introduction to the Power Query M formula language -- From pitfalls to robust queries -- Basic text analytics -- Advanced text analytics: extracting meaning -- Social network analytics -- Final project: combining it all together.