SQLShorts: Installing and Configuring PowerPivot, Power View, and the BI Semantic Model ( BISM ) [Setup]May 10, 2012 at 7:48 PM
Thanks Mike for the detailed installation / configuration steps, it was very helpful.!
Issues faced during the install -
(1) 'No available web app...' message when adding new Reporting Services Service Application, but solved following @ecassaro's comment (thanks ecassaro.!).
(2) I was not able to access the Ppvt site's PowerPivot Gallery from Excel when I tried save to sharepoint - Ppvt1 excel, working locally on the sharepoint server, but I was able to access the same from a client outside of Sharepoint server.