Site Templates Part 7: Business Intelligence Center in SharePoint 2013 and Office 365

Before reading this article, I highly recommend reading my previous parts:

Welcome to the 7th Site template, Business Intelligence Center in SharePoint 2013/Office 365. This will be the parts of my article Site Templates in SharePoint 2013/Office 365. Here we will see what the components available are. We will see what the Business Intelligence Center template provides us.

Click on create a new site, the following form opens up.

  • Title and Description:

  • Web Site Address: Here you can make it different from your default site name.

  • Template Selection: Here you have an option to select the language and to choose a site from a template having many options.

    Here in this article we will be seeing the Business Intelligence Center template under the Enterprise group so select it.

    Template Selection in sharepoint

  • Permissions: Here you can assign permission to the site directly, either by inheriting the permissions from the parent or assigning it unique permissions.

  • Navigation Inheritance: Using this option you can inherit the same navigation as your parent site.

    Navigation Inheritance

  • Click on Create, it will create the site.
Welcome to the Business Intelligence Center, a site for presenting Business Intelligence content in SharePoint, as in the screen below we can see the Home Page of the new site.

Let's see what it has for us.

Business Intelligence Center
Business Intelligence Center is a portal that contains the tools of all the services we can use to connect Power Pivot, Excel and Power services.

This will help an organization to connect using various services.

The Home page has been divided into three categories, Explore and Analyze Data, Design Interactive Reports and Share Dashboards.
  • Explore and Analyze Data

    Here we can create data rows using the Power Pivot tool. Once you click on the link it will take you to the Power Pivot help center as in the following screen and to the link below.

    SharePoint Online Enterprise

    Link: SharePoint Online Enterprise (E3 and E4) Help.

  • Design Interactive Reports:

    Here you can create presentations in the form of reports and place it on the view using Excel and Power tools. Once you click on the link it will take you to the Excel and Power help center as in the following screen and to the link below.

    Create and share reports scorecards

    Link: Create and share reports, scorecards and dashboards by using Excel and Excel Services.

    3. Share Dashboards:

    Here we can share a dashboard where the users can connect to Excel services. Once you click on the link it will take you to the Excel services as in the following screen and to the link below.

    Need assistance
    Link: Need assistance?
Site Contents

Site Contents

Here we have contents as:
  1. Dashboards: It contains all the dashboards you want to add your views to.

  2. Data Connections: It contains all the data connections files in the site.

  3. Documents: It contains all the document files in a library.

  4. Images: It contains all the image files in a library.

  5. Power BI: Microsoft provides comprehensive BI tools that integrate across Office applications and other Microsoft technologies. These tools enable analysis, reporting, dashboards and visualizations.

  6. Workflow Tasks: It stores all the tasks of the site.

  7. Pages: It stores all the pages of the site.

Data Connections

Now when you see the data connections library, you have the option to upload to various kinds of data connections.

  1. Office Data Connection File: A general connection file.

  2. Universal Data Connection File: A connection file to Microsoft InfoPath and a place to store the values of the Data Connection File.

    Data Connections


The following are the examples of the dashboards we can get them connected to Excel, pivot and presentation services.


share Dashboards

excel online

excel service sample

Site Settings

Finally we can see the site settings, that you can see from the previous blogs an C# Corner. Link: Site Settings in SharePoint 2013.

Site Settings

communication administration

Here it was a new user friendly and a wonderful portal for the users using Business Intelligence Center.

Keep Learning!!