- Assemble data from multiple sources and publish on the web
- Consolidate your organization’s reports in the Report Centre
- Publish Excel workbooks on the web or intranet using Excel Services
- Connect to external data sources
- Create and track KPI’s for your teams using KPI Web Parts
- Use Filter Web Parts to create subsets of data
- Use Dashboards to communicate status and drive action
|
 |
Data from Multiple Sources
| |
|
Until recently assembling reports and accessing data from disparate systems has required specialised skills such as date warehousing or data mining. Publishing that data to the web was also difficult and has been restricted to developers and consultants. However Microsoft SharePoint Server Business Intelligence tools now make it much easier for your employees to assemble, consolidate and publish data on the web.
|
|
Report Center
| |
|
The core component of SharePoint’ reporting tools is the Report Center. It provides a central location for all BI-related information, with document libraries for storing reports, lists, and external data connections. There are standard page and report templates for building new reports and Web Parts. The Report Center is a default site at the top-level of your portal site, but any team can create their own Report Center using all of the tools available.
|
|
Excel Services
| |
|
Excel is a key business tool in most orgnisations, but using Excel to communicate valuable business information can be problematic. Excel Services is a new server technology included in Microsoft SharePoint Server that enables you to load, calculate, and display Excel workbooks on SharePoint Server. You can easily reuse and share Excel workbooks on SharePoint Server portals and dashboards.
|
|
Data from External Sources
| |
|
You can use data from external sources such as other business applications (e.g. Siebel, SAP), and manage a library of stored external data connections so that other employees can access the data and create new reports. Permissions can of course be deployed on all connections to ensure data integrity. Web Parts can be created that allow users to interact with the external source data without ever leaving the browser.
|
|
Key Performance Indicators
| |
|
Communication is of course an important element of Business Intelligence – you can create specialised Key Performance Indicators (KPI’s) for your teams that communicate to them how they are progressing towards a goal. Quick visual feedback is invaluable in a fast-paced business environment. Filter Web Parts are Web Parts that allow you to show only the data that needs to be shown – subsets or filters of data can be more meaningful to users. The final element of SharePoint Business Intelligence is Dashboards – specialised sites that assemble all of a user’s reports, charts, connections, filters, and KPI’s in one location.
|