Filter
Top Products
www.microsoft.com/office/preview/servers/sharepointserver
27
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
Spreadsheets
New
Office Excel 2007 Services help information workers publish
spreadsheets to SharePoint sites, including spreadsheets that
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
Publishing
New
Office Excel 2007 provides an integrated publishing experience
that helps information workers easily choose what they want to
show and how users can interact with their published
spreadsheets.
Programmatic Access to
Published Spreadsheets
New
Excel Services provide a Web services model for
programmatically accessing published spreadsheets. Custom
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
New
Data Connection Libraries are new SharePoint document libraries
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.