|Analyze data from SQL Server Analysis Services|
|Written by Microsoft|
|Wednesday, 24 August 2011 21:58|
You can use Microsoft Excel 2010 and Microsoft SQL Server 2008 R2 PowerPivot for Microsoft Excel 2010 to create PivotTable and PivotChart reports to analyze data imported from Microsoft SQL Server 2008 Analysis Services (SSAS). PowerPivot for Excel 2010 is an add-in to Excel 2010 that you can download from the Microsoft Download Center (http://go.microsoft.com/fwlink/p/?LinkId=224183).
Whether you use Excel 2010 or PowerPivot for Excel 2010 depends largely on how much data that you are analyzing. PowerPivot for Excel 2010 supports more rows of data and lets users import data from multiple sources. It also uses all native Excel 2010 features but processes calculations faster through the in-memory business intelligence engine.Read more...
- Profit and Loss Data Modeling and Analysis with Microsoft PowerPivot in Excel
- Create a memory-efficient Data Model using Excel 2013 and the PowerPivot add-in
- PowerPivot Table Import Wizard cannot find provider
- Analytics for Twitter 2013
- Refreshing Excel workbooks with embedded PowerPivot models from SharePoint Online
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- How to install PowerPivot for Excel and list of know issues
- List of PowerPivot DAX functions with description
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- Learning PowerPivot and DAX
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?