Microsoft 2007 manual Business Intelligence

Page 30

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

Image 30
Contents Microsoft Office SharePoint Server Evaluation Guide Abstract Table of Contents Introduction How to Use This Guide Resources Available for Evaluating Office SharePoint ServerOverview of This Guide Page Product Overview Effectively Manage and Repurpose Your Information AssetsAccelerate Internal and External Shared Business Processes Page Page Top 10 Benefits Page Features at a Glance PortalIt easier to discover social networking connections between Way video conversation Content Management Document Management Records Management Include Managing e-mail content across Microsoft Office Outlook Web Content Management Important company information to customers, partners Services for the end-to-end content management of content Search Improved rendering of search results Support for indexing and searching any Ldap directory Improved crawl rules and crawl log Business Processes Windows SharePoint Services library, while making the form Business Intelligence Back-end systems in SharePoint lists, Web Parts, pages, By the new Report Center, provide consistent management Architectural Overview Office SharePoint Server 2007 ArchitectureOperating System and Database Services Windows SharePoint ServicesOffice SharePoint Server 2007 Applications and Services Server ApplicationsShared Services Installing Your Evaluation Server Product Tour An Administrator’s Perspective Developer’s Perspective For More Information Hardware and Software Requirements For complete system requirements, visit