Sharepoint2013 brief overview of business intelligence learning notes (1)

SBusiness Intelligence (BI) in harepoint 2013 provides a comprehensive Bi tool that integrates Microsoft Office applications and other Microsoft technologies. These Bi tools include: excel services in Excel 2013, Sharepoint 2013, performancepoint services in Sharepoint Server 2013, Visio services in Sharepoint, Sharepoint 2013, and Microsoft SQL server integrated workbook for Sharepoint and Reporting Service for Sharepoint.

By using these powerful graphical tools, you can quickly and efficiently analyze data without code. Data is displayed on the SharePoint website in a rich array of charts..

Excel services in Sharepoint Server 2013 allows you to browse Excel documents in a browser window and interact with them online, just like using Excel on the client. For more information, see Excel services in Sharepoint Server 2013.

Workbook for Sharepoint The Excel services function is enhanced so that SharePoint can manage and display the Excel files created using the workbook. In Excel, using the powe.pdf component to create data allows EXCEL to break through row and column restrictions, so that more data can be imported, workbook for Excel allows you to import, filter, and sort millions of rows of data, far exceeding the limit of 1 million rows in Excel. More importantly, by using the workbook for Excel component, you can establish relationships between data from different data sources. For more information, seeWorkbook Overview

 

 

Performancepoint services allows you to create dashboards with rich functions to aggregate content from multiple sources and display it in a web browser that is easy to understand and collaborate. With the rich interactivity of dashboards, you can quickly and easily analyze the latest information and process data to identify critical opportunities and trends. Performancepoint services and its creation tool Dashboard designer allow you to display Key Performance Indicators (KPIs) and data visualization content in the form of a scorecard, analysis report, and filter. In addition to creating a scorecard that collects data from multiple data sources, you can also integrate with SQL Server Reporting Services (SSRS) and Excel services to track and monitor key business drivers. For more information, seePerformancepoint services in Sharepoint Server 2013

Reporting Service for Sharepoint makes it possible to create, manage, and display Microsoft SQL Server Reports on SharePoint, by using Microsoft SQL Server Report builder on a Sharepoint website, you can easily create reports with powerful interfaces. Compared with dashboards in performancepoint services, dashboards only display data from Analysis Service data sources. Microsoft SQL Server Report builder allows you to create graphical reports from multiple data sources, such as SQL Server, SQL Azure, and Oracle.