Review

Microsoft Power Query for Excel

Overview

Synopsis

Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration.

Category

Data Preparation Software

Company

Microsoft

PAT Rating™

Editor Rating

Aggregated User Rating

Rate Here

Ease of use

7.7

5.3

Features & Functionality

7.7

4.2

Advanced Features

7.7

4.4

Integration

7.7

5.9

Performance

7.7

6.4

Customer Support

7.7

—

Implementation

—

Renew & Recommend

—

Bottom Line

Microsoft Power Query for Excel, provides a seamless experience for data discovery, data transformation and enrichment for Information Workers, BI professionals and other Excel users.

7.7

Editor Rating

5.9

Aggregated User Rating

5 ratings

You have rated this

Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery, access and collaboration. Microsoft Power Query for Excel, provides a seamless experience for data discovery, data transformation and enrichment for Information Workers, BI professionals and other Excel users.

Power Query features include identify the data about from the sources work with such as relational databases, Excel, text and XML files, OData feeds, web pages, Hadoop HDFS.

Power Query let discover relevant data from inside(*) and outside organization using the search capabilities within Excel and combine data from multiple, disparate data sources and shape it in order to prepare the data for further analysis in tools like Excel and Power Pivot, or visualization in tools like Power View and Power Map.