Home » business intelligence » Broad Overview of the New Features of Excel Services for SharePoint Server 2013

Broad Overview of the New Features of Excel Services for SharePoint Server 2013

With SharePoint Server 2013, Microsoft® has taken steps to better align the computing platform to service the needs of Line of Business (LoB) units. Several of the out of the box features are, apparently, designed to provide LoBs with powerful capabilities to gather data to support efforts to build Business Intelligence (BI).

For SharePoint administrators, developers, designers and power users, the most obvious indication of this shift is the absence of the long-familiar “pie” graphic depiction of SharePoint broad benefits. A tile interface, consistent with Windows 8 and the latest Office suite has been developed to take its place as the primary method of promoting the platform via a new slogan, including the following catch words:

  • Share
  • Organize
  • Discover
  • Build
  • Manage

As Jason Himmelstein notes in the first video tutorial in our new set on Business Intelligence for SharePoint 2013, Business Intelligence Features and Excel Services 2013, these 5 points can be used to support a wide range of reasons to implement SharePoint Server 2013, including BI for LoBs.

For example, the “Organize” benefit may take the form of using BI processes to present Key Performance Indicators (KPIs), etc, in a “cleaner way”. Similarly, the “Discover” benefit may sum up an implementation of a “right type of BI” for a specific organization.

The rest of this first video tutorial in our set on “SharePoint 2013: BI” is devoted to the new features included in the server platform for Excel Services. These new features are:

  • 3D Charts
  • Interactive PivotCharts
  • PivotTable Field Well
  • Timeline Slicers
  • Quick Explore
  • PowerView

Certainly Excel is a very popular charting application for LoBs. The comparative cost of developing management dashboards with Excel Services, vs SQL Server Reporting Services, especially for Small to Mid size Businesses (SMBs) weighs in strongly towards Excel.

So the enhanced performance of each of these features, as Jason Himmelstein broadly notes in the remaining few minutes of this video tutorial, provides SharePoint administrators and other platform stakeholders with another strong reason for LoBs to adopt the the SharePoint 2013 computing experience.

Ira Michael Blonder

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