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:
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.
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.
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.