Installation of PowerPivot is 2 step process. First we have to enable PowerPivot mode in SQL Server 2012. We need to setup a new database instance with PowerPivot. It will also enable Analysis services as SharePoint Integrate Mode.
Step 1 – Install PowerPivot in SQL Server 2012
Click New SQL server standalone or add features
Wait to download the updates or Uncheck the checkbox to continue
Click OK if you don’t have any issue
Click Perform a new Installation of SQL Server 2012
Accept : Next
Select SQL Server PowerPivot for SharePoint
Change Instance ID if you want or click Next
Provide SQL Analysis Service Account and password
Click Add Current User and click Next.
I choose Mixed Mode for my installation and it is not required.
Click Add Current User to add it as administrator in SQL Analysis services.
Review the installation and click Install.
Give it couple of minutes.
End of Part 1.