Implement Business Intelligence Solutions Using Excel Services

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.

Description:

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. 

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