Business Intelligence

Office SharePoint Server 2007 helps organizations provide business intelligence (BI) capabilities to every employee, so they can share, control, and reuse business information in order to make better business decisions. The BI features in Office SharePoint Server 2007 provide Web and programmatic access to published Office Excel spreadsheets, programmatic reuse of critical LOB data, and easy development of Web-based BI dashboards that can incorporate rich, data-bound KPIs, Web Parts, and published spreadsheets.

Feature Area

Feature Description

Web Access to Published

Office Excel 2007 Services help information workers publish

Spreadsheets

spreadsheets to SharePoint sites, including spreadsheets that

New

incorporate powerful new client capabilities such as data

 

 

visualization and richer PivotTable views and PivotChart views.

 

Users require no additional software to access these interactive

 

spreadsheets in a Web browser, and all calculations are

 

performed on the server.

 

 

Integrated, Flexible

Office Excel 2007 provides an integrated publishing experience

Publishing

that helps information workers easily choose what they want to

New

show and how users can interact with their published

 

 

spreadsheets.

 

 

Programmatic Access to

Excel Services provide a Web services model for

Published Spreadsheets

programmatically accessing published spreadsheets. Custom

New

applications can send data to Excel Services for server-side

 

 

calculation, and the results are returned to the custom application

 

without exposing the spreadsheet’s business logic.

 

 

Data Connection Libraries

Data Connection Libraries are new SharePoint document libraries

New

in which organizations can centrally publish connection files to

 

 

make it easy for users to find and use the data sources they

 

need. Data connection files are easy to create and update, and

 

solution designers can easily reuse them from within the 2007

 

Microsoft Office system client applications, such as forms in Office

 

InfoPath 2007.

 

 

www.microsoft.com/office/preview/servers/sharepointserver27

Page 30
Image 30
Microsoft 2007 manual Business Intelligence