Applies to: Office 365
Topic Last Modified: 2016-09-28
SharePoint Online is a collection of Web-based tools and technologies that help your organization store, share, and manage digital information. Built on Microsoft SharePoint Server 2013, this hosted service is ideal for working on projects, storing data and documents in a central location, and sharing information with others. The following Insights features allow organizations to use the information in databases, reports, and business applications to address their specific business needs.
The Business Intelligence Center site enables you to store data connections, workbooks, reports, scorecards, and dashboards in a central, secure location. Learn more about configuring Business Intelligence Center.
When you create PivotChart reports of PivotTable reports that use data that is stored in SQL Server Analysis Services, you can create calculated measure and calculated members for that report. Learn more about Business intelligence capabilities in Excel Services.
A data connection library is a special SharePoint library that is designed to store and manage shared data connections. These can include ODC files that you create by using Excel. Learn more about Trusted Data Connection Libraries in SharePoint Server 2013.
When you create a PivotChart report, a corresponding PivotTable report is automatically created. New in Excel 2013, you do not have to display a PivotTable report on the same worksheet as its corresponding PivotChart report. You can choose to display only the PivotChart report. This capability is called “decoupled PivotTables and PivotCharts”. Learn more about PivotTables and PivotCharts.
Excel Services enables you to share workbooks with others, interact with reports, view and explore information in a browser window, and refresh data. Excel Services also enables you to share all or parts of workbooks with others, and control what information is displayed in those workbooks. In SharePoint 2016, Excel Services capabilities are available through Excel Online on Office Online Server. Requires Office Online Server in the on-premises environment. Learn more about Excel Services.
You can use the Excel Web Access Web Part to display Excel content on a SharePoint site.
Excel Online enables you to open the Field List and Field Well for PivotChart reports and PivotTable reports that are viewed in a browser windows. This capability makes it easy to temporarily change the information that is displayed in a PivotChart report or a PivotTable report without having to open Excel. Learn more about Business Intelligence in Excel Services.
Slicers are easier to create and connect to reports. You can adjust the size and orientation of a slicer. You can also format slicers by applying built-in styles or defining your own style.
You can search on filter results, which makes it easy to jump to a particular item in a long list. Learn more about using filters and slicers.
ODC files enable you to manage, share, and reuse data connections to Enterprise data sources. Data connections to particular data sources can be configured and managed centrally by IT personnel, and be made available for any workbook that consumes the ODC files. You can maintain sets of ODC files in central locations on the SharePoint farm, and you can edit Excel workbooks to utilize these files.
Not available to SharePoint Online customers. PerformancePoint Services enables SharePoint Server 2013 customers to create interactive dashboards that display key performance indicators (KPIs) and data virtualizations in the form of scorecards, reports, and filters. Learn more about PerformancePoint Services.
Not available to SharePoint Online customers. With Dashboard Migration, SharePoint Server 2013 customers will be able to copy complete dashboards and dependencies. This includes the .aspx file, to other users, servers, or site collections. This feature also allows the ability to migrate single items to other environments and migrate content by using Windows PowerShell commands. Learn more about creating Dashboards by using PerformancePoint Services.
With Power Pivot for Excel, you can perform powerful data analysis and create sophisticated data models. You can also mash up large volumes of data from various sources, analyze data quickly, and share insights. With SharePoint Online, you can use Excel Online to view and interact with charts, tables, PivotChart reports and PivotTable reports in a browser window. You can also use the Excel Web Access Web Part to display Excel content in a SharePoint Site. Power Pivot sheets must be created in Excel before being viewed in SharePoint. Learn more about using Power Pivot in Excel.
With Power View for Excel, you can visualize and interact with modeled data by using highly interactive visualizations, animations, and smart querying. With SharePoint Online, you use Excel Online to view and interact with workbooks that contain Power View sheets in a browser window. You can also use the Excel Web Access Web Part to display Excel content in a SharePoint Site. Power View sheets must be created in Excel before being viewed in SharePoint. Learn more about using Power View in Excel.
Quick Explore enables organizations to select a value in a PivotChart report or a PivotTable report and see additional information about that value. For example, if you are viewing a sales report and you select a value that represents total sales amounts, you can use Quick Explore to view additional information such as sales amounts across different product categories or geographical areas. Learn more about Quick Explore.
Allows you to see up-to-date data in your Excel Online workbooks that are connected to external data sources (for example, MS SQL databases). Note that you must connect your workbooks to external data sources in Excel before viewing them in Excel Online.
Not available to SharePoint Online customers. A scorecard shows at a glance whether performance is on or off target for one or more key performance indicators (KPIs). A dashboard is a collection of views that can include scorecards and other reports. Scorecards and dashboard are designed to show current performance information and are typically rendered in a site such as a SharePoint Server 2013 site. Learn more about creating and using a report or a scorecard.
When SQL Server 2012 Reporting Services is integrated with SharePoint, you can use powerful SharePoint collaboration and centralized document management features for SQL Server 2012 Reporting Services content. Reports are stored in SharePoint document libraries, alongside other reports such as Excel Online files. SharePoint permissions can be used to control access to Reporting Services content, and people are able to start Report Designer, Model Designer, and Report Builder within a document library. Learn more about Reporting Services Report Server.
The SQL Server 2012 Reporting Services Web Part enables people to display an existing Reporting Services report in its own Web Part in a SharePoint site. If the Reporting Services report contains parameters, people can connect filters to that report using the Web Part settings. Learn more about Report Viewer Web Part.
A timeline slicer is a control that can be added to a dashboard created by using Excel. A timeline control enables people to view information for a particular period of time. Learn more about Business Intelligence in Excel Services.
You can use Excel Online to view and interact with workbooks connected to OLAP/tabular data sources. Note that workbooks must be created in Excel before being used in Excel Online or displayed in SharePoint through Excel Web Access Web Part.
Excel Workbooks sometimes contain Power Pivot data models that allow you to perform powerful data analysis, mash up large volumes of data from various sources, analyze data quickly, and share insights.
User-defined functions (UDFs) give you the ability to use formulas in Excel Online worksheet cells to call custom functions written in managed code. UDFs are an advanced programmability feature that allows your enterprise to develop and plug custom code into Excel Online worksheets. You can create UDFs to call custom mathematical functions, get data from custom data sources into worksheets, and call Web services from the UDFs.
Visio Services is a service application that lets users share and view Microsoft Visio Drawing (*.vsdx) and Visio 2010 Web drawing (*.vdw) files. Learn more about Visio Services.
To view feature availability across Office 365 plans, standalone options, and on-premise solutions, see SharePoint Online Service Description.