Posted by: kurtsh | February 19, 2014

RELEASE: Microsoft Power Query for Excel

imageMicrosoft Power Query for Excel, is a new add-in that provides a seamless experience for data discovery, data transformation and enrichment for Information Workers, BI professionals and other Excel users.
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 from inside(*) and outside your organization 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 tools like Excel and Power Pivot, or visualization in tools like Power View and Power Map.
  • Share the queries that you created with others within your organization, so they can be easily found via Search. (*)

(*) This capability requires Power BI for Office 365. You can learn more at Power BI for Office 365.


Categories

%d bloggers like this: