CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

ATSP-BI - SharePoint 2007 - Business Intelligence Features using Excel

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

This one day course will introduce the user to the Business Intelligence features of SharePoint Server 2007, with a focus on Excel Services. You will learn how to create and publish Excel workbooks that can be viewed in a browser. You will learn how to create a workbook that allows for interactivity and forecasting. You will learn the intricacies of the publishing process to control what parts of a workbook can be seen by end users. You will also learn how to integrate data from external data sources and embed database queries into your workbooks. Finally, you will learn about the other business intelligence features of SharePoint such as Key Performance Indicators and dashboard pages.

Click here for a printer-friendly version of this page

Prerequisites

SharePoint Power End User and familiarity with Excel 2007

Detailed Class Syllabus

Required Understanding of MS Excel

Importing Data

Excel Tables

Table Sorting and Filtering

Named Ranges

Pivot Tables

Pivot Charts

Introduction to Excel Services

Publishing to Excel Services

Capabilities of Excel Services

Controlling and Managing Workbook Distribution

Excel, Excel Services and External Data

Using a Data Connection

External Data Connection Definition

Excel Services Features

Supported and Unsupported File Formats

Supported and Unsupported Features

Excel Services Architecture

Sharing Workbooks

Savings versus Publishing

Controlling What's Visible in the Browser

The Excel Viewer Page

The Excel Web Access Web Part

Navigation

Workbook Parameters

Excel Web Access Toolbar

Workbook Authoring and Distribution

Controlling Authoring

Controlling Viewing

Business Intelligence Solutions

Key Performance Indicators

Filtering

Reporting

Dashboard Pages