MOSS 2007 Capabilities

Business Intelligence with Office SharePoint Server 2007 provides a simple accessible infrastructure that simplifies use of SharePoint for decision-makers to access information at any point of time. Users can get information related to where they work, collaboration, and decisions. They can also acquire information whether information is on the desktop or Web based.

Refer http://www.microsoft.com/sharepoint/capabilities/bi/features.mspx

Content Management, Organization, and Collaboration are solutions that enable publishing, managing and retrieving content quickly and securely.

• Control on delivery of content
• Team sites, collaboration dashboards, process repositories and workflow integration
• Document collaboration across organization

Helps in searching business data currently obscured in system

• Documents and data from multiple repositories and business sources across your enterprise can be recovered within fractions of second.
• Intelligently handle indexing and content propagation
• Customize the reporting and administration suites

Refer http://technet.microsoft.com/en-us/magazine/2007.01.search.aspx

Excel Services, part of Office SharePoint Server 2007, extend the capabilities of Microsoft Office Excel 2007 by allowing broad sharing of spreadsheets, improved manageability and security and the ability to re-use spreadsheet models using a scalable server-based calculation service and interactive Web-based user interface across organization. Excel Services help in

• sharing and reusing of excel workbooks
• viewing live, interactive workbooks via web browser
• connecting workbooks to external data sources
• Maintaining a data connection library
• Maintain only one copy of a workbook, instead of multiple versions

Microsoft Office SharePoint Server (MOSS) makes it easy to build and maintain portal sites and intranets for every part of your organization. A flexible, highly scalable architecture supports personal, divisional, intranet, extranet and Internet sites. Incorporating existing business applications into your intranet or portals allows you to consolidate your applications and create new customized applications to support your business processes.

• Comprehensive framework to easily build portal and intranet sites for your organization.
• Centrally managed site design built in functionality, publishing and deployment.
• Combine multiple types of documents, information and applications to create a powerful business tool for all your employees.
• Creation of libraries with templates and images for employees to create their own sites and portals.
• Storage facility for employee data into personalized Sites.
• Built in role-based templates to address unique needs of different job function in an organization.

There are various types of forms as a built in functionality in SharePoint.

• Server-based Forms – These are server-based electronic forms used to streamline business processes and help in centralizing the organization database making process more cost effective than paper based forms
• Accessing forms via browser- InfoPath Forms services help employees with access to a browser/HTML- enabled device in accessing forms. Mainly used by marketing executives, customer service representatives outside office.
• Validating Data- Automatically validate collected data with input masks. Office InfoPath 2007 is used as a user interface when integrated with back-end systems or lists. Data validation rules which are a built in functionality in Office InfoPath 2007 keeps check for errors during data entry.
• Repository for Centralized forms – Access to forms in the centralized repository can be controlled by administrator, despite forms usage by users of system.