We have a SP farm set up and it is in it's infancy.

Our department is BI.

There are 10 products within our company, each with different management and BI needs, therefore we'd like to create a site for each of these products.

Should we use a BI Center site as a template for each of these 10 sites ?

  • what version and edition of SharePoint are you using? Dec 17, 2013 at 17:11
  • @SupriyoSBChatterjee pretty sure we've got one of the latest versions (2012?) definitely Enterprise
    – whytheq
    Dec 17, 2013 at 17:49
  • the versions & editions have varying features & capabilities Dec 17, 2013 at 18:52
  • @SupriyoSBChatterjee Ok - we're using 2013 Enterprise
    – whytheq
    Dec 19, 2013 at 8:55
  • what version of SQL are you using? Part of the BI stack relies on this as well Dec 20, 2013 at 9:36

3 Answers 3


You can create One BI Center for Each Product,its easy to manager( i am assuming each Product having Different set of users).

But [Configuring the BI][1] is more tricky...Couple of things you should make sure.

  1. Plan it properly
  2. Mapping User License
  3. Creating the Secure Store Services
  4. Properly Configuration of Excel Services, Performance Point and Visio
  • yes - we have different users for each product
    – whytheq
    Dec 24, 2013 at 7:52
  • what does this mean "But [Configuring the BI][1] is more tricky" ...or is it just some strange formatting?
    – whytheq
    Dec 24, 2013 at 12:22

You have excellent environment for BI platform with SQL 2012 and SharePoint 2013 enterprise edition.

So my strong recommendation would be to please extend the BI site template to all the other 10 products and make sure you activate the SharePoint enterprise features so that you will be able to utilize the core SharePoint collaboration features along with BI.

A bunch of other features that you would also need is managed metadata services and so on.

Coming back to BI tools currently excel services is the key which can be widely used for either graphical data interpretations or to pull data from the external data sources using pivot tables/power views for all your 10 product sites.

  • is Power View part of SP 2013 Enterprise?
    – whytheq
    Dec 21, 2013 at 13:41
  • 1
    power view is an add on for SSRS and is not part of sharepoint installation.
    – kesava
    Dec 24, 2013 at 2:11
  • +1....so a little confused: you say "....pull data from the external data sources using pivot tables/power views". Power View isn't really part of Excel Services is it - I thought it was pretty much stand alone - or will I be able to embed graphics from Power View into Excel Services dashboards?
    – whytheq
    Dec 24, 2013 at 7:54
  • check this technet, will give you more detail about the BI....ECS< Power View, Performance Point, PowerPivot etc technet.microsoft.com/en-us/sharepoint/fp142398.aspx
    – Waqas Sarwar MVP
    Dec 24, 2013 at 8:00
  • @kesava in terms of "make sure you activate the SharePoint enterprise features" does this need to be done for each site - or because I 'm using the BI site template I assume provisions have already been made within the template for our needs re. SSRS, XL services etc.
    – whytheq
    Dec 27, 2013 at 9:33

In my opinion you can use single BI Center site template to manage content for all 10 products site.

In one single BI Center site you can show multiple content of multiple products using score-cards, dashboards, excel BI reports, SQL reporting services reports, PerformancePoint reports, Chart web-parts, etc.

You need to do a little home work and understand the capabilities that is offered in BI in SharePoint. You will find good resources over the web and enough video and presentation tutorials to kick start your learning.

  • think I'm favouring multiple BI Center Sites ...one for each product. Doesn't seem like there will be a massive overhead of taking that route.
    – whytheq
    Dec 24, 2013 at 12:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.