|PowerPivot to the People (Getting Started with PowerPivot for Excel)|
|Written by Deanna Dicken|
|Sunday, 19 September 2010 22:53|
New with SQL Server 2008 R2, PowerPivot is an extension of Analytical Services providing power users with a familiar tool for analyzing massive amounts of data from disparate sources (including web and data feeds). PowerPivot comes in two flavors: PowerPivot for Excel and PowerPivot for Sharepoint. This article gets you started with PowerPivot for Excel.
The PowerPivot plugin for Excel can be downloaded from the official PowerPivot site: www.powerpivot.com.
PowerPivot can be installed on both x86 and x64 systems including Windows XP sp3, Windows Vista sp1, and Windows 7. If you aren’t installing it on Windows 7, you will need to install .Net Framework 3.5 SP1.
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- How to install PowerPivot for Excel and list of know issues
- List of PowerPivot DAX functions with description
- List of suggested datasets to test PowerPivot
- Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months)
- DAX cheat sheet
- Learning PowerPivot and DAX
- Using Power Pivot and Power View for Profit Analysis