SharePoint 2007: The Definitive Guide
by James Pyles, Christopher M. Buechler, Bob Fox, Murray Gordon, Michael Lotter, Jason Medero, Nilesh Mehta, Joris Poelmans, Christopher Pragash, Piotr Prussak, Christopher J. Regan
Business Intelligence
Business Intelligence with Office SharePoint Server 2007 makes it easy for decisionmakers to access and analyze information anytime, anywhere. You can get up-to-date information wherever people work, collaborate, and make decisions, whether it's on the desktop or over the Web. Now, aligning employees' objectives with your corporate goals is as easy as creating a spreadsheet or report.
Features
The "Business Intelligence" functional area can be summed up with the following feature list:
Excel Services
Report Center
Dashboards and Key Performance Indicators (KPIs)
Business Data Web Parts
Business data in lists
SQL Reporting Services/AS Integration
Excel Services
MOSS 2007 has introduced a new feature to SharePoint that enables spreadsheet authors to easily share their work. The web-based Business Intelligence features use Excel Services to provide new Business Intelligence functionality through the browser. These spreadsheets allow users to develop interactive, data-bound spreadsheets that include charts, tables, and PivotTable output. These views can be created and included as part of a portal, dashboard, or business scorecard, without requiring any development.
Report Center
The Report Center feature of MOSS 2007 provides users with an out-of-the-box site optimized for report access and management. The Report Center includes a report library, data connection library, and a Dashboard template, and allows users to consistently manage reports, spreadsheets, and data connections. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access