I hope my PowerPivot posts and videos are proving useful, and continuing this them I want to cover off installation.
PowerPivot for Excel is a free download for Excel 2010 and simply doesn’t need any edition of SQL Server behind it. It comes in 32 bit and 64 bit depending on which variant of Excel you have installed and you can get it the beta of this from the http://www.powerpivot.com site.
However to deploy that PowerPivot to SharePoint 2010, you’ll need to do quite a bit of work. Rather than rewrite these I will simply direct you to the set of draft setup guides on the PowerPivotGeek blog.
The basic setup is to..
I have used the first option, a single server setup to produce my PowerPivot videos and posts. However my demo rig is a bit more complicated in that I have three virtual machines (vms) on my shuttle (BINKY) which has 4 cores 8Gb RAM and 2 x NICs which are setup as follows:
It’s a miserable Friday out there so why not persuade the boss for a bit of R&D time and set this up this afternoon.
Andrew, you've missed the "r" from the powerpivot url!!