I've a SharePoint farm having two machines: the first one represents the wfe/app SharePoint server, the second one is the db server. I'd like to install the SSAS PowerPivot mode instance on the db server, but it seems that with the configuration tool of
PowerPivot for SharePoint 2013 I need to install a local instance of PowerPivot and so this instance should be on the wfe/app server.
Moreover, is the best practice creating the site collection for PowerPivot by the configuration tool? Does the configuration tool allow to create a PowerPivot site with the PowerPivot gallery?
The PowerPivot for SharePoint Configuration tool will not create the PowerPivot Gallery during the configuration, it automates all of the configuration steps that are described in the article below:
Initial Configuration (PowerPivot for SharePoint):
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.