BUSINESS INTELLIGENCE AND SHAREPOINT

Business Intelligence (BI) capabilities in SharePoint 2013 are vast and in many cases are achieved with a combination of SharePoint and Microsoft Office or SharePoint and SQL Server’s capabilities.

Traditionally, the tools for accessing large amounts of unstructured data for the purpose of analysis were available only to people with years of experience in data warehousing or data mining. Publishing to the Web by using data from multiple sources is something historically restricted to developers and consultants. By using the new features available in Office SharePoint Server 2007, information workers can assemble data from multiple sources and publish that data on the Web. Office SharePoint Server 2007 can link to business applications, such as SAP, Siebel, and Microsoft SQL Server 2005, allowing you to easily publish reports, lists, and key performance indicators (KPIs). When you publish reports from the data in one of these systems, you provide strategic or operational data for decision-makers. Examples of reports include Microsoft Office Excel workbooks, a SQL Server Reporting Services report, or a Microsoft Office Access report. Executives and line managers rely on timely and accurate reports to make informed decisions. At the center of the new Office SharePoint Server 2007 Business Intelligence features is the Report Center. The Report Center is a site that provides a central location for storing reports that are common to a group, whether it is as small as a one team or as large as an entire organization.