WSS vs. MOSS - Business Intelligence

WSS MOSS

Business Data Catalog Integration
The Business Data Catalog (BDC) tightly integrates external data into the Office SharePoint Server 2007 user experience, providing access to external data residing within backed line-of-business applications, and enabling the display of and interaction with external data through a set of Business Data Web Parts. Learn more about BDC Integration

WSS MOSS

Integrated B.I. Dashboards
Create rich, interactive BI dashboards that assemble and display business information from disparate sources by using built-in Web parts such as dynamic KPIs, Excel spreadsheets, Microsoft SQL Server Reporting Services reports, or a collection of business data connectivity Web Parts that can visualize information residing in back end line-of-business applications.

WSS MOSS

Key Performance Indicators (KPI)
KPIs communicate goals and status to drive results. Using the KPI Web part, a MOSS user can create a KPI list within a Web part page, without writing custom code. The KPI Web part can display KPIs from Hosted Microsoft® SQL Server Analysis Services, spreadsheets, SharePoint lists, or manually entered data.

WSS MOSS

Report Center MOSS Sites
An out-of-the-box site optimized for report access and management, including a report library, data connection library, and a dashboard template. These sites, hosted by the new Report Center, provide consistent management of reports, spreadsheets, and data connections.

WSS MOSS

Filter Web Parts
Filters enable dashboards to be personalized by communicating shared parameters among Web Parts on a dashboard. The parameters passed can be automatically applied based on user profiles, SharePoint lists, the BDC, manually entered information, and so forth.

WSS MOSS

Business Data Web Parts
Use SharePoint Business Data Web Parts for viewing lists, entities, and related information retrieved through the Business Data Catalog.

WSS MOSS

Excel Services: Web-based B.I.
Excel Services empowers authors to share spreadsheets through a browser using the new MOSS business intelligence(BI) functionality. Fully interactive, data-bound spreadsheets can be created as part of a portal, dashboard, or business scorecard, without requiring any custom code or Web part development.

WSS MOSS

Publish Excel Spreadsheets
Office Excel 2007 and MOSS provide an integrated publishing experience that lets information workers easily choose what they want to share with others and determine how others interact with published spreadsheets. Learn more about integrating Excel and MOSS

WSS MOSS

Share, Manage & Control Spreadsheets
Share business data across an enterprise while maintaining control and helping to protect sensitive information. MOSS 2007 Provides access to spreadsheet data and analysis through server-calculated, interactive Office Excel spreadsheets from a Web browser. Use these spreadsheets to maintain and efficiently share one centralized version of the “truth” while helping to protect any sensitive or proprietary information embedded in documents, such as financial models, by limiting access to portions of the spreadsheet and auditing their usage.

WSS MOSS

Data Connection Libraries
Data Connection Libraries are centralized SharePoint document libraries that store Office Data Connections (ODC); ODCs describe connections to external data. Centralizing ODCs makes it easier to share, manage, and discover data connections that can be used by any Microsoft Office program. Learn more about Data Connection Libraries

WSS MOSS

Business Data Actions
With no custom coding, easily create actions that open Web pages, display the user interfaces of line-of-business applications, launch InfoPath forms, and perform other common tasks. Use the convenient links that appear beside business objects returned from the Business Data Catalog.

Back to top
More WSS and MOSS Feature Comparisons:

Custom Quote

A SharePoint Architect will evaluate your specific needs and help you build the perfect SharePoint hosting solution. Get a Quote Today