Business Intelligence (Advanced End Users)

View Schedule | Sign-Up  | Add to Cart


Business Intelligence with Office SharePoint Server 2007 makes it easy for decision-makers 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 employee's objectives with your corporate goals is as easy as creating a spreadsheet or report in this class.


Class Syllabus

The following topics will be covered in the class as well as discussions on best practices:

  • Introduction to Business Intelligence
  • Overview of Business Intelligence features
  • The Report Center
  • Excel Services
    • What is Excel Services?
    • What is Office Excel Web Access?
    • How do Excel Services and Office Excel 2007 work together?
    • Interacting with an Excel workbook in Excel Services
    • Excel Services scenarios
    • Creating "one version of the truth"
    • Connecting to data in a secure way
    • Excel Services and Information Rights Management
    • Using Excel Services with other Business Intelligence features
  • Business data integration and discovery - Seamlessly integrate external data into your applications using the Business Data Catalog (BDC), part of Office SharePoint Server 2007. The BDC simplifies the process of discovering and accessing data residing within back-end line-of-business applications. Discover back-end data quickly using SharePoint search and interact with data through a set of Business Data Web Parts.
  • Key Performance Indicators (KPIs)
    • Using Office SharePoint Server 2007 KPIs
    • Create a KPI list
    • Add a KPI to the KPI list
    • Add a Web Part to a page
    • Link the KPI list to the Web Part
  • Filter Web Parts
    • Overview
    • Types of filters
    • Using filters
  • Dashboards and Report Center - Create rich, interactive business intelligence (BI) dashboards that assemble and display business information from disparate sources by using built in Web Parts. These Web Parts include dynamic key performance indicators (KPI), Office Excel 2007 spreadsheets, Microsoft SQL Server 2005 Reporting Services reports and a collection of business data connectivity Web Parts that can visualize information residing in back-end line-of-business applications.
    Example of a dashboard page

Class Location

ABC Learning Center
Building 4322
5122 India Blvd, San Diego, CA 92123

View Larger Map

Class Notes