I have just completed the final two pages for the server installation section of the blog (see here for details). These sections cover:
(3) To install PowerPivot on a new single server with a dedicated DB server, click here. Use this document to install and configure PowerPivot for SharePoint on a single server SharePoint 2010 farm with a dedicated SQL Server. It is a modified version of #2, except that it has been specialized for the 2-server environment.
(4) To set up Reporting Services integrated with SharePoint, click here. Use this document to install and configure Reporting Services in SharePoint Integrated mode. You can then use Report Builder to create reports using PowerPivot workbooks that you have been published to a PowerPivot Gallery as data sources. After installation, you can design reports by entering the URL of the PowerPivot workbook as the “Server:” in your Report Builder or Report Designer data source. The underlying PowerPivot infrastructure will make the appropriate connection to the embedded PowerPivot database residing within the workbook.
As always, if you use them and have corrections or changes, please post feedback in the Comments section of the page.
Enjoy.
_-_-_ Dave
Thank you Dave for the awesome read that you have compiled in here. It was really interesting to read the profile especially in terms of your transformation into the BI space and its evolution
Thank you for the detailed read on installation and hoping to read much more useful stuff especially in the context of having just entered the BI world.
Wishing you a Happy 2010