Overview

This is a 3-day course designed to provide students with the knowledge and skills to use Excel Services to create business intelligence (BI) applications. In this course we cover the Excel Services components of SharePoint Server 2007. We use the Enterprise license of the product since the BI features are available only with that license. The course’s primary focus is on the Excel Services components of the BI features in the SharePoint Server 2007 Enterprise version. Much of the information in this course will assist in your deployment of Excel Services with SharePoint Server 2007. Students learn through numerous instructor-led demonstrations and hands-on labs.

Since the focus of this course is on Excel Services functionality, this course does not cover what is new in Excel 2007, nor does it broadly cover Microsoft Office SharePoint Server 2007.

Online

The online option is held in conjunction with the instructor-led course, with other students in the classroom and online, via Live Meeting technology.

For all labs to work, and to make the most of the event, you will need to set up your computer with the following:

• Operating System: Windows 2000, Windows XP, Vista or Windows 7
• Microsoft Office Live Meeting 2007 client - This should be downloaded (http://office.microsoft.com/en-us/help/HA101733831033.aspx) and installed in advance of the event.

Prerequisites

Students taking this course should have the prerequisite knowledge or experience listed below.

• Basic knowledge of Office SharePoint Server 2007 Enterprise.
• Some knowledge of administering Office SharePoint Server 2007.
• An understanding of BI concepts such as Analysis Services, Key Performance Indicators (KPIs), and data analysis.
• Have Microsoft Office Excel 2007 implemented in your environment.
• A working knowledge of Microsoft Office Excel 2007.

Intended Audience

The course is designed for those who intend to design, implement, and manage an Excel Services deployment, and also build BI solutions using SharePoint Server 2007. Individuals in the job categories listed below will benefit from the knowledge gained in this course.

• Current SharePoint Server 2007 administrators
• Experienced administrators or have some knowledge of SharePoint Server 2007
• Data analysts or business intelligence consultants
• Business users
• Experienced Excel 2007 users
• Business managers and financial analysts who are interested in the functionality of KPIs in reports and BI Dashboards

To register for these events, click on the registration icon below.

Attend In Person

Attend Online