Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

    Advertisements
  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand
  • Advertisements

SharePoint 2013 – Business Intelligence Features

Posted by Paul on August 29, 2013


In this article I would like to list down the Business Intelligence Features of SharePoint 2013. These features provide us a quick solution for various business requirements like presentations, integrations & connectivity to external systems.

Following are the core document management features in SharePoint 2013:

1. Performance Point Services

2. Excel BI

3. Excel Services

4. PowerPivot

5. PowerView

6. Visio Services

7. Integration Reports

8. External Data Integration

Performance Point Services

Performance Point Services provides Dashboards to provide data visualization. The dashboards can be interactive to display Key Performance Indicators (KPI).

clip_image001

Performance Point is enhanced to support Analysis Services & rendering to iPad.

Excel Services

Excel Services enables browser based Excel Sheet viewing & editing. Users can share an entire excel work book or a particular number of cells.

clip_image002

We can have different views for the same work sheet like Worksheet View, Gallery View.

PowerPivot

PowerPivot provides powerful data exploration through in-memory data storing. PowerPivot allows working with millions of rows from different data sources.

clip_image003

In SharePoint this feature comes under Excel Business Intelligence category.

PowerView

PowerView is a feature of SQL Server Reporting Services & it is supported in SharePoint 2013. PowerView provides interactive data exploration, visualization, and presentation experience.

clip_image004

In SharePoint this feature comes under Excel Business Intelligence category.

Visio Services

Microsoft Visio diagrams are supported in SharePoint through the Visio Services. Visio Services allows the following operations with Visio files:

1. Load

2. Preview

3. Interact

Additionally, Visio Workflow can be visualized through Visio Services.

clip_image006

Integration Reports

Microsoft SQL Server Reporting Services (SSRS) based reports can be viewed within SharePoint environment. This feature is supported through SharePoint Reporting Services component.

clip_image008

External Data Integration

SharePoint can be connected with external systems including:

1. SQL Server Databases

2. Oracle Databases

3. Other Databases

4. SAP ERP through Connectors

5. Custom Connectors

Additional to providing an Encapsulation, SharePoint external data integration features include External Content Type configuration, Offline support, Search, Secured Access etc.

The SharePoint server works in between of client browser & external system in providing data.

clip_image009

Advertisements

2 Responses to “SharePoint 2013 – Business Intelligence Features”

  1. Do you know if all these features are also accessible for external website users? We want to offer e.g. Powerview to our customers. Thanks!

    • jeanpaulva said

      Yes. These features are available for external users as well. The external users are those who have just different authentication mechanism. The browser rendering & Activex controls would work for all.

      You can verify using a free SharePoint 2013 site @ http://www.sharepointpower.com

      Regards,
      Jean Paul

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s