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.
Business Intelligence Center
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.
Calculated Measures and Members
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.
Data Connection Library
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.
Decoupled PivotTables and PivotCharts
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. Excel Services requires Office Online Server in the on-premises environment. Learn more about Excel Services.
Excel Web Access Web Part for SharePoint
You can use the Excel Web Access Web Part to display Excel content on a SharePoint site.
Field List and Field Support
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 File Support
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.
Power BI Web Part
Power BI is a cloud-based suite of business analytics tools that enables anyone to connect to, visualize, and analyze data with greater speed, efficiency, and understanding. It connects users to a broad range of live data through easy-to-use dashboards, provides interactive reports, and delivers compelling visualizations that bring data to life. To learn more about Power BI, see Get started with Power BI service.
Power Pivot for Excel in SharePoint
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.
Power View for Excel in SharePoint
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.
Refresh Excel Workbooks Interactively
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.
SQL Server Reporting Services (SSRS) Integrated Mode
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.
SQL Server Reporting Services (SSRS) Web Part
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.
Use and Interact with Excel Workbooks Containing Data Models
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. Visio Services is no longer available with SharePoint Online. Visio Services will continue to be available in SharePoint Server 2010, SharePoint Server 2013, and SharePoint Server 2016. Learn more about Visio Services.
To view feature availability across Office 365 plans, standalone options, and on-premise solutions, see SharePoint Online Service Description.
Send feedback about: