SharePoint 2007 Expands Business Intelligence

New features in SharePoint Server 2007 allow nontechnical workers to define KPIs, manage reports, and create dashboards—Web pages that display KPIs and related information. Furthermore, a new component called Excel Services supports server-side spreadsheet management and could help organizations that distribute Excel spreadsheets for reporting or analysis. The new features could strengthen Microsoft’s hand in the BI market by helping organizations track and report performance with limited ongoing involvement of developers and IT. However, developers and IT workers must set up SharePoint Server 2007 carefully for its BI features to be very useful.

Web-Based Performance Tracking, Reports

SharePoint Server 2007, released in Nov. 2006, is the latest version of Microsoft’s server application for hosting intranet Web portals. Along with refined features for collaboration and document management, SharePoint Server 2007 adds new reporting capabilities to Microsoft’s growing list of BI tools and applications for business users and other nontechnical workers.