Configuring Power Pivot for SharePoint 2010

This post explains about how to install and configure the Power Pivot for SharePoint 2010. You can read installation instructions for SharePoint 2010 here. You need to install SharePoint 2010 with un-configure state. You will be having the PowerPivot for SharePoint package in SQL Server 2008 R2 media. We are using new server installation option in SQL Server 2008 R2 setup.