Home » Office 365 » Adding a Business Intelligence Site Collection to SharePoint Online, Office 365 2013

Adding a Business Intelligence Site Collection to SharePoint Online, Office 365 2013

We planned to add a status list to the top level site collection of our Office 365, SharePoint Online account. But we quickly learned about the removal of this out of the box type of list from an article, Discontinued features and modified functionality in Microsoft SharePoint 2013, which was published on the Microsoft® Office web site.

The reason for the removal of this feature? “Similar features can be used with other applications, such as Excel Services”. The workaround is as follows:

  1. “If you used SharePoint Status Indicators in SharePoint Server 2010, you can continue to use them in SharePoint Server 2013.”
  2. or, ” If you did not use SharePoint Status Indicators and Status Lists in SharePoint Server 2010 you can use other SharePoint functionality such as Excel Services to create key performance indicators (KPIs).”

(all quotes have been extracted from the Office article. We’ve provided a link to the entire article above)

Before you attempt to follow 2), keep in mind the following:

  • You must have an Office 365 Enterprise Service Plan in order to activate Excel Services
  • SharePoint Online is a multi tenancy computing environment. As a tenant, you cannot access central administration
  • You will need to make sure “SharePoint Server Enterprise Features”, including “Features such as Visio Services, Access Services, and Excel Services Application, included in the SharePoint Server Enterprise License”, is enabled (quotes are extracted from the SharePoint Online, 2013 user interface) for each and every site collection for which you decide to implement Excel Services to produce the color coded status feature
  • This administrative control at the site collection level can be extended to the site level within each of your site collections. You can choose, at any time, to activate the “SharePoint Server Enterprise Features” at the site level

You must first have a site collection before you can access the site collection features we’ve just noted. We chose to set up a Business Intelligence Center (BIC) site collection for the list. SharePoint Online includes an Enterprise Site Template for a BIC Site Collection. In the next post to this blog we’ll discuss the BIC site collection in further detail.

Ira Michael Blonder

© Rehmani Consulting, Inc. & Ira Michael Blonder, 2013 All Rights Reserved