Creating Business Intelligence Solutions with MOSS 2007


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
Microsoft Office SharePoint Server 2007 provides developers with the ability to create intelligent business solutions. This course provides an overview of the features that accomplish this and specifically how to use them to display data using Excel Services, create trusted workbook locations, process data from Windows SharePoint Services, and how to utilize reporting and key performance indicators in MOSS 2007. This course is one of a series in the SkillSoft learning path that covers the objectives for the Technology Specialist (TS): Microsoft Office SharePoint Server 2007 – Application Development 70-542. Passing this exam will earn the learner the MCTS: Microsoft Office SharePoint Server 2007 - Application Development certification.

Target Audience
Developers who use Microsoft Office SharePoint Server 2007 and consultants providing consulting services for Microsoft Office SharePoint Server 2007.

Prerequisites
Six months to one year of experience developing applications by using Microsoft Office SharePoint Server 2007; experience using the Microsoft .NET Framework, at least six months with ASP.NET 2.0; experience working with XML documents, XML Web services development and consumption; a working knowledge of Windows WorkFlow Foundation and IIS 6.0

Expected Duration (hours)
1.5

Lesson Objectives

Creating Business Intelligence Solutions with MOSS 2007

  • recognize the functionality of Excel Services and Business Intelligence in MOSS 2007
  • recognize how to display data using Excel Services and create a trusted workbook location
  • recognize how to process data using Excel services user-defined functions
  • recognize how to troubleshoot a user-defined function and filter workbook data
  • recognize how to provide parameters to a Report Viewer web part and expose a data source
  • recognize how to create a key performance indicator
  • recognize how to work with Excel Services
  • recognize how to work with report data
  • Course Number:
    es_ssad_a03_it_enus