Hi

I might be posting this in the incorrect forum but here goes:

I'm SQL Server BI specialist with +15years SQL Server experience. I want to use SharePoint 2013 to surface BI content to consumers. I have visions of "process centric BI pages/sites" on our SharePoint 2013 intranet. I imagine users logging into (for eg) a "Revenue BI" intranet page that contains key visualisations & thumbnails there on the page alongside interactive charts & links to SSRS reports, data models (UDM & Tabular), supporting documents and other related sites on the intranet.

Well at the moment all's I can do is imagine because I don't seem to be able to work out what components I need to install where & how to configure them in SharePoint.

I have read many excellent blogs (but they seem to focus on installing everything on a single host rather a production multi-server environment) and have been down numerous TechNet documentation rabbit holes.

From a infrastructure point of view I have:

• a SharePoint 2013 EE farm (this is black box to me although in the "test" environment I have access to SP Central Admin)
• a separate "Data Warehouse" dedicated SQL environment running (on which I have OS admin and SQL sysadmin rights): SQL Server 2012 EE (DW database host); SSRS 2012 EE Native mode instance; SSAS 2012 EE Multidimensional instance, SSAS 2012 EE Tabular instance

If we take an example - surfacing interactive PowerView reports embedded in a SharePoint page so they are embedded within the browser shell and a user (without an local install of Excel) can take advantage of PowerView's excellent interaction & animation capabilities - I have questions such as:
- Do I need to install SSRS in SharePoint Interactive Mode?
- or PowerPivot for SharePoint?
- or a SSAS Tabular instance?
- or some combination of the above?
- do I build my xVelocity models in Excel and save the PowerPivot to SharePoint?
- or in Visual Studio and deploy to a SSAS Tabular instance? (I read that this was down to development process preferences i.e. develop in Excel & deploy to PowerPivot to SharePoint, or develop in Visual Studio (our preference) and deploy to SSAS Tabular)
- if I need PowerPivot for SharePoint where do I install this? On a separate SQL host or one of the servers in the SharePoint farm? If I install it inside the farm does this mean that when an Excel PowerPivot workbook is opened the xVelocity engine grabs & holds potentially GBs of memory inside the farm to support the processed data model (something that my SharePoint admin would go mad about)? I appreciate that SharePoint is  new tech to me but it seems *massive* and I'm really struggling to work out what I need to do. Any pointers/links to useful sites/papers *very* much appreciated. Steve

- Do I need to install SSRS in SharePoint Interactive Mode?
- or PowerPivot for SharePoint?
- or a SSAS Tabular instance?

Hi Steve,

According to your description, you are trying to configure PowerView report on SharePoint site, now you need to know which components do we need to install, right?

• Do I need to install SSRS in SharePoint Interactive Mode?
  Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition. So we need to install SSRS before we can use PowerView report on SharePoint site.
• or PowerPivot for SharePoint?
  If you only use Power View connected to SSAS servers with tabular models and cubes, you dont need to install PowerPivot for SharePoint. You create RSDS connection files for the SSAS connections and can create Power View reports directly from RSDS files.
  But PowerPivot for SharePoint provides additional capabilities:
  workbooks as data source (i.e. using PowerPivot models within XLSX workbooks as data sources for Power View)
  BISM connection files
  PowerPivot Gallery
  Excel Web app in SharePoint (with Excel Services) e.g. pivot tables over PowerPivot workbooks
• or a SSAS Tabular instance?
  We can connect to another server which have SSAS tabular installed as PowerView report data source. So SSAS tabular in not the necessaries for PowerView on SharePoint.

Please refer to the link below to see the details about
Installing & Configuring PowerView for SharePoint 2010/2013

Regards,