Use Excel and PowerPivot for Excel to analyze SQL Server Analysis Services data

  • Article

Analyzing data that you import from an external source such as SQL Server Analysis Services (SSAS) can be complicated. The Microsoft TechNet article, Analyze data from SQL Server Analysis Services explains how to use Excel or PowerPivot for Excel to analyze this data.

This newly published article includes three sections:

Analyzing data in Excel 2010

This section illustrates how to create an Office Data Connection (ODC) file to store the connection string and then how to use the ODC file to import external data from SSAS. Next, this section explains how to create and use PivotTables and PivotCharts to analyze this data in Excel.

Analyzing data in PowerPivot for Excel 2010

This section demonstrates how to use PowerPivot for Excel to import data from an SSAS cube and analyze the data with PivotTables and PivotCharts. Then this section shows methods for preparing and analyzing the imported data with PowerPivot.

Saving the PivotTable or PivotChart to SharePoint Server 2010

The third section shows how to save the PivotTables and PivotCharts that you created to a SharePoint Server 2010 site.

This article is a follow-up to the previously published article, Configure Excel and Excel Services with SQL Server Analysis Services.