Export (0) Print
Expand All

Insights

Office 365
 

Applies to: Office 365

Topic Last Modified: 2014-04-24

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.

To see if an Insights feature is available in a certain SharePoint solution, see Insights feature availability across SharePoint solutions.

NoteNote:
For a list of all SharePoint features, see. SharePoint feature availability across solutions

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, view and explore information in a browser window, and refresh data. Excel Services enables you to view and interact with reports, scorecards, and dashboards in a browser window, much like you would use the Excel client. Excel Services also enables you to share all or parts of workbooks with others, and control what information is displayed in those workbooks. Learn more about Excel Services.

Excel Services 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 and scorecards. 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.

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 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.

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.

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.

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 Services 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.

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.

Use the following Insights feature availability tables to compare Office 365 plans to SharePoint on-premises solutions.

 

Features

Office 365 Small Business

Office 365 Small Business Premium

Office 365 Midsize Business

Office 365 Enterprise E1

Office 365 Education A2

Office 365 Government G1

Office 365 Enterprise E3

Office 365 Education A3

Office 365 Government G3

Office 365 Enterprise E4

Office 365 Education A4

Office 365 Government G4

Office 365 Enterprise K1

Office 365 Government K1

Business Intelligence Center

No

No

No

No

Yes

Yes

No

Calculated Measures and Members

No

No

No

No

Yes

Yes

No

Data Connection Library

No

No

No

No

Yes

Yes

No

Decoupled PivotTables and PivotCharts

No

No

No

No

Yes

Yes

No

Excel Services

No

No

No

No

Yes

Yes

No

Field list and Field Support

No

No

No

No

Yes

Yes

No

Filter Enhancements

No

No

No

No

Yes

Yes

No

Filter Search

No

No

No

No

Yes

Yes

No

PerformancePoint Services

No

No

No

No

No

No

No

PerformancePoint Services (PPS) Dashboard Migration

No

No

No

No

No

No

No

Power View for Excel in SharePoint

No

No

No

No

Yes

Yes

No

Power Pivot for Excel in SharePoint

No

No

No

No

Yes

Yes

No

Quick Explore

No

No

No

No

Yes

Yes

No

Scorecards & Dashboards

No

No

No

No

No

No

No

SQL Server Reporting Services (SSRS) Integrated Mode

No

No

No

No

No

No

No

Timeline Slicer

No

No

No

No

Yes

Yes

No

Visio Services

No

No

No

No

Yes

Yes

No

If you have comments or questions about this topic, we'd love to hear from you. Just send your feedback to Office 365 Service Description Feedback. Your comments will help us provide the most accurate and concise content.

 
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft