Friday, January 03, 2014

The difference between Power Pivot and Power Query

There may be a some overlapping functionality in accessing data as both of them have to access data sources but Power Query is more like SSIS (SQL Server Integration Services) a la EXCEL while Power Pivot (SQL Server Analysis Services) is more like SSAS.

The variety of data sources that Power Query can connect to manage is much wider than that of Power Pivot including the social media created data like Facebook and unstructured data.
Power Pivot has a more powerful analytical role than Power Query which you  can easily make out by just looking at the user interfaces.

However both of them are downloaded as add-ins for MS EXCEL 2010 or 2013 as shown (MS EXCEL 2010 in this case).

You may follow these link for more details:

Connecting to SQL Server 2012 Express from Power Pivot - 1

Connecting to SQL Server Express 2012 from Power Pivot - 2

No comments: Protection Status