Record Details

Catalog Search

Back To Results
Showing Item 16 of 29

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

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

Raviv, Gil, (author.).


"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]

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.
Subject: Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Electronic spreadsheets > Computer programs.
Business intelligence > Computer programs.
Information visualization > Computer programs.
Business > Data processing.
Visual analytics.
Business > Data processing.
Electronic spreadsheets > Computer programs.
Visual analytics.

Available copies

  • 1 of 1 copy available at State Library of Alabama.


  • 0 current holds with 1 total copy.
Show All Copies
Location Call Number / Copy Notes Barcode Shelving Location Status Due Date
APLS 005.54 RAV 31291002937074 STACKS Available -

Back To Results
Showing Item 16 of 29

Additional Resources