SharePoint24x7 It's all about SharePoint.


Article – Creating a BI Center and Testing Excel Services

Posted by Joy

Business Intelligence (BI) is one of the most compelling features in SharePoint. All the BI features of SharePoint come with the Enterprise edition of SharePoint. Following are some of the BI components come with SharePoint:

  • Excel Services
  • Visio Services
  • Access Services
  • Power View
  • PowerPivot
  • PerformancePoint Dashboard

In order to leverage all of these BI features in SharePoint, you need to create and configure a BI Center in SharePoint. In this article I will guide you through the process of creating a BI Center in SharePoint and testing Excel Services as Excel Services being a very important/ core feature for rest of the BI features in SharePoint.

Creating a BI Center

  • Navigate to SharePoint 2013 Central Administration web site
  • Select Create site collections link from Application Management sectionApplication Management section
  • From the Create Site Collection page, make sure you select the correct Web Application in which you want to create the BI Center. Provide a Title and an option Description. Provide a URL.Create Site Collection page
  • From the Select a template: section, go to Enterprise tab and select Business Intelligence Center site template. Provide a Primary Site Collection Administrator and click OK.Create Site Collection page
  • It will notify you saying that Site Collection has been successfully created. Open the new site and it will take you to the home page of the new BI Center.BI Center

Testing Excel Services

  • From the BI Center home page, from the Left Navigation (Quick Launch), select Site Contents link.BI Center
  • Select Documents libraryCapture7
  • Click the name of the Excel Services Sample Workbook to test the Excel Services.Capture8
  • You will see the following output if you have configured Excel Services correctly.Capture9

Now you are all set to explore rest of the BI features of SharePoint 2013. Smile