Welcome!

XML Authors: Jayaram Krishnaswamy, Jason Bloomberg, Asim Saddal, Greg Schulz

Blog Feed Post

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:
http://hodentekhelp.blogspot.com/2013/12/what-is-difference-between-ms-query-and.html

Here is the ribbon tab for POWER QUERY

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

Read the original blog entry...

More Stories By Jayaram Krishnaswamy

Jayaram Krishnaswamy is a technical writer, mostly writing articles that are related to the web and databases. He is the author of SQL Server Integration Services published by Packt Publishers in the UK. His book, 'Learn SQL Server Reporting Services 2008' was also published by Packt Publishers Inc, Birmingham. 3. "Microsoft SQL Azure Enterprise Application Development" (Dec 2010) was published by Packt Publishing Inc. 4. "Microsoft Visual Studio LightSwitch Business Application Development [Paperback] "(2011) was published by Packt Publishing Inc. 5. "Learning SQL Server Reporting Services 2012 [Paperback]" (June 2013) was Published by Packt Publishing Inc. Visit his blogs at: http://hodentek.blogspot.com http://hodentekHelp.blogspot.com http://hodnetekMSSS.blogspot.com http://hodnetekMobile.blogspot.com He writes articles on several topics to many sites.