SharePoint 2013 – Business Intelligence Features

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:

  • Performance Point Services
  • Excel BI
  • Excel Services
  • PowerPivot
  • PowerView
  • Visio Services
  • Integration Reports
  • 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).


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.


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


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


In SharePoint this feature comes under Excel Business Intelligence category.


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


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:

  • Load
  • Preview
  • Interact

Additionally, Visio Workflow can be visualized through Visio Services.


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.


External Data Integration:

SharePoint can be connected with external systems including:

  • SQL Server Databases
  • Oracle Databases
  • Other Databases
  • SAP ERP through Connectors
  • 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.


Leave a Reply


  • SriramGanapathySriram Ganapathy
    Strategist – Cloud Solutions at Microsoft


    Sriram Ganapathy is a Technical Specialist with Microsoft. He has been with Microsoft for 17+ years and has held a variety of roles including solution sales, technical and partner sales, services, support and consulting. During his tenure at Microsoft, his focus has been on the Microsoft Data platform technologies. Sriram is based in Dallas and is focused on providing technology and solution guidance to customers in the US central region in SQL Server, Azure, Big Data, Advanced Analytics and related technologies. 

  • 4242c2728ednthumbabhi_vantaram

    Abhi Vantaram
    Director, iLink Systems

    Abhi has over ten years of experience working on an array of strategic planning, technology assessment, internet infrastructure, software architecture, development and implementation projects. He has over 6 years of experience in working on Environmental applications including Compliance, EMS, Sustainability, Haz Waste, Haz Mat, Conservation, NEPA, etc. He has worked with several fortune 500 clients, startups and product companies, as well as Federal, State & Local, Global Government. He has managed large teams, developed and delivered multiple enterprise solutions. He is well versed and has experience working with both Java/Oracle and Microsoft based technologies.

  • manigandan-gopalakrishnan

    Manigandan Gopalakrishnan
    Director NE Region, iLink Systems


    Mani has over 20 years of IT experience that spans Solution and Services Sales experience across various verticals such as Financial Services, Communications, Manufacturing, Media and Entertainment, CPG etc. He has worked with iLink for over 6 years, is based out of NJ and currently heads the NE Region Practice for iLink managing Sales and Business Development for NE, Mid Atlantic and some states in North Central, Mid-West and Heartland Districts.

  • ambujbigAmbuj Parihar
    Director – Central region, iLink Systems


    Mr. Parihar, with over 15 years of experience, has overall responsibility for the strategy and business development, including sales and marketing, of the Central region. Mr. Parihar holds a Master degree in Wireless Communication from the University of British Columbia and a Masters of Business Administration degree from Darden School of Business, University of Virginia.


  • leadership-page-piyushprakash Piyush Prakash
    VP – Business Operations & Innovation, iLink Systems

    Piyush is a performance driven technology leader with 16 years of experience in IT, and has overall delivery responsibility for all projects at iLink. He is intrigued by the ways in which technology binds us all, and touches our life (and business) on a daily basis. He enjoys discovering and simplifying the true value, often veiled behind the seemingly complex technology landscape of today. He has worked with several Fortune 500 companies, startups and ISVs to delivery large scale enterprise solutions as well as innovation driven R&D engagements. Personally responsible for iLink’s TCG (Technology Consulting Group) team, he relishes the opportunity to work on cutting-edge technologies, including delivery of various frameworks and accelerators.

    Prior to iLink, he has served in key positions in Infosys Technologies and TATA Interactive Systems. He holds a Bachelors of Technology degree from IIT (ISM) Dhanbad, and Masters in Electrical & Computer Engineering from The University of Texas at Austin.

  • [contact-form-7 404 "Not Found"]
  • Register Here