Currently I am in the middle of a deployment with PowerPivot in SharePoint 2013, for the sake of have as much new stuff as possible, at least from the SharePoint end. My scenario looks like this:
For the installation the high-level steps are:
So, the checklist itself to ensure your PowerPivot for SharePoint installation works smoothly:
If you want a very granular user account setup, you will need the following users:
The mentioned users should be the minimal accounts. One of the main reasons for so many are the Kerberos delegation, you may want to just allow the Excel Service Account for Kerberos delegation, or the C2WTS (Claim to Windows Token Service) who needs specific privileges.
Ensure you install SQL Server 2012 with Service Pack 2, I've found an issue when trying to connect to the PowerPivot instance with the management studio that is solved in SP1/SP2. Follow the instruction on this article: Install Analysis Services Server in SharePoint Mode for SharePoint 2013 (SQL Server 2012 SP1). Two important points here:
This, as mentioned earlier, have been tested over a Windows 2012 R2 installation.
There is a lot of ways to test this, but my way would be: