Watch this: Using business intelligence features in Microsoft Office SharePoint Server 2007

Microsoft Office SharePoint Server 2007 gives the information worker the power to compile, manage, and report on data from multiple data sources. Users can publish this data to intranets, extranets, and the global Internet. Business intelligence, which is also referred to as BI, helps organizations deploy processes across business units.

The BI features included in Office SharePoint Server allow users to:

  • Share data across organizational and technological boundaries
  • Link to business applications such as SQL Server 2005, Siebel, and SAP
  • Present data in user-friendly ways
  • Publish lists, reports, and Key Performance Indicators (KPIs)
  • Deliver timely and accurate reports to key decision-makers that summarize strategic and operational data

These capabilities come from these SharePoint Server features and functionality:

  • Report Center
  • Excel Services
  • Business Data Catalog
  • Business Data Web Parts
  • Key Performance Indicators
  • Dashboards
  • Connections to External Data Sources

For more information about business intelligence features in Office SharePoint Server, view these computer-based-training lessons presented by Mindsharp:

This lesson provides an overview of Business Intelligence, Report Center, Excel Services, Business Data Catalog, Business Data Web Parts, and Key Performance Indicators.

This lesson describes the business uses of Excel Services, the basics of publishing Excel workbooks, and how to configure Excel Services.

This lesson explains how to publish an Excel worksheet in the Excel Web Access Viewer, describes the associated Excel Web Access Toolbar, and provides an overview of workbook parameters.

This lesson describes the Excel Web Access Web Part. It explains how to use both the Excel Web Access Web Part and Key Performance Indicators. It also introduces SQL Server Analysis Services and explains how to use it with Excel Services.


About Mindsharp

Mindsharp, a Microsoft Gold Certified Partner, is a global education company that shows organizations how to use Microsoft enterprise technologies to achieve powerful business solutions. Mindsharp offers a full line of comprehensive training courses that target the needs of executives, end users, administrators, developers, designers, and architects.

Mindsharp’s instructors, including Microsoft Most Valuable Professionals, teach clients to increase productivity using secure and scalable collaboration, communication, and messaging services. Mindsharp’s portfolio of educational products and services includes design and planning sessions, public training events, on-site training, electronic courseware for in-house training, computer-based training, and online instructor-led training.


 
 
Applies to:
SharePoint Server 2007