Sunday, December 15, 2013

What is Microsoft Power Query?

Sharpen you BI skill set!!

It is an Microsoft Excel add-in that is intended to enhance the Business Intelligence that you can carry out as it provides a simplified path to discover the data and access it. Once discovered the dat can be analyzed in EXCEL. It also has a US only Public search feature.
It is available in both x32 and x64 bit versions.
Features of Power Query:
The following types of data can be discovered,
  • Relational databases
  • Excel Spread sheets
  • Data in text
  • XML data
  • OData Feeds
  • Web Pages,
  • Hadoop HDFS and many others
You can mash up data from different sources and can be analyzed by Power Pivot and EXCEL.

It is supported on Windows 7, Windows 8. With .NET 3.5 SP1 it is also supported on Windows Vista, Windows Server 2008

You would also require,
Office 2013 professional plus
Office 2013 standalone
Excel 2013 Standalone
Office 2010 Professional Plus

Power Query is different from MS Query. How different? Follow this link:

Here is the ribbon tab for POWER QUERY

Here is how you access data or discover it.
Yet another great tool to work with.

No comments: Protection Status