In this article we can explore the Business Intelligence feature of SharePoint 2010.
What is Business Intelligence?
Business Intelligence in SharePoint is a set of applications and tools that helps in achieving the Business Goals, Performance Needs in anz enhanced manner.
In summary we can say Business Intelligence is Storage, Analysis and Reporting of Data targeting Business Decisions.
SharePoint 2010 provides the following Business Intelligence tools:
· Excel Services
· Chart Web Part
· Performance Point Services
· Site Dashboard
· SQL Server Reporting Services
· SQL Server Analysis Services
· Visio Services
We can see each of them in detail.
This service provides sharing of excel work books among users. This service have the capability to render excel sheets inside a browser. Users can view and edit the excel sheet using their browsers. This service was introduced in SharePoint 2007 version.
For trying this feature create a Document library template with the Advanced Options set as shown below.