|
Microsoft Office SharePoint Server 2007 helps organizations provide business intelligence capabilities to
every employee, so they can share, control, and reuse business information in order to make better business
decisions. The business intelligence features in Microsoft Office SharePoint Server 2007 provide Web and
programmatic access to published Microsoft Office Excel spreadsheets, programmatic reuse of critical LOB data,
and easy development of Web-based business intelligence dashboards that can incorporate rich, data-bound KPIs,
Web Parts, and published spreadsheets.
Business Data Catalog
With Microsoft Office SharePoint Server 2007 you can include data from back-end systems in SharePoint lists,
Web Parts, and search results by using the Business Data Catalog. The Business Data Catalog also allows access
to data by using Microsoft ADO.NET.
Dashboards
Microsoft Office SharePoint Server 2007 makes it easy to create rich business intelligence dashboards that
incorporate dynamic KPIs, Office Excel 2007 workbooks, and Microsoft SQL™ Server Reporting Services reports.
Microsoft Excel Services
Microsoft Office Excel 2007 Services help information workers publish spreadsheets to SharePoint sites,
including spreadsheets that incorporate powerful new client capabilities such as data visualisation 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
Microsoft 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
Microsoft Excel Services provide a Web services model for programmatically accessing published spreadsheets.
Custom applications can send data to Microsoft Excel Services for server-side calculation, and the results are
returned to the custom application without exposing the spreadsheet's business logic.
Report Center
Microsoft Office SharePoint Server 2007 includes out-of-the-box websites optimised for report access and
management. These sites, hosted by the new Report Center, provide consistent management of reports,
spreadsheets, and data connections.
Read more about Business Forms Automation with Microsoft Office SharePoint Server (MOSS) 2007
|