3

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? – Supriyo SB Chatterjee Dec 17 '13 at 17:11
  • @SupriyoSBChatterjee pretty sure we've got one of the latest versions (2012?) definitely Enterprise – whytheq Dec 17 '13 at 17:49
  • the versions & editions have varying features & capabilities – Supriyo SB Chatterjee Dec 17 '13 at 18:52
  • @SupriyoSBChatterjee Ok - we're using 2013 Enterprise – whytheq Dec 19 '13 at 8:55
  • what version of SQL are you using? Part of the BI stack relies on this as well – Anders Rask Dec 20 '13 at 9:36
1
+50

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 '13 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 '13 at 12:22
2

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 '13 at 13:41
  • 1
    power view is an add on for SSRS and is not part of sharepoint installation. – kesava Dec 24 '13 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 '13 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 '13 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 '13 at 9:33
2

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 '13 at 12:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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