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
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 | ||
| ||
| 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