Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access.
Microsoft Power Query for Excel is an add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access. Power Query enables users to easily discover, combine, and refine data for better analysis in Excel. Power Query includes a public search feature that is currently intended for use in the United States only.
With Power Query, you can:
- Identify the data you care about from the sources you work with (e.g. relational databases, Excel, text and XML files, OData feeds, web pages, Hadoop HDFS, etc.).
- Discover relevant data using the search capabilities within Excel.
- Combine data from multiple, disparate data sources and shape it in order to prepare the data for further analysis in Excel and PowerPivot.
Download http://www.microsoft.com/en-us/download/details.aspx?id=39379