SharePoint Rangers - Onsite Business Intelligence
Schedule Your SharePoint Training Now
SharePoint 2007 Business Intelligence
Customer Service Rating by LivePerson
Curve

Other Ways to Reach Us

For General Comments and questions. contact Aivea at
1-800-779-7506 or email us
at sales@aivea.com
phone
Curve

Audience: This course is for Solution Architects, Business Intelligence Developers, SharePoint Power Users, Site Collection Administrators, Enterprise Portal Designers, System Administrators, Software Architects and Developers who will be responsible for building business intelligence applications on MOSS 2007.

MOSS 2007 Platform Architecture Overview

Understand SharePoint Server 2007 platform architecture from the Operating System to Application Layers toward building business intelligence applications

  • Microsoft SharePoint 2007 architecture overview
  • SharePoint Services architecture
  • SharePoint Product architecture
  • SharePoint Administration architecture


Excel Services and Key Performance Indicators (KPIs)

This session provides a detailed overview and hands-on labs for Excel Services, KPIs and Business Data Catalogs.

  • Excel Services Overview
  • Setting up a trusted file location
  • Using the Excel Web Access Web Part
  • Creating Dashboards
  • Management and Administration of Excel Services
  • KPI Lists and KPI Web Parts


Business Data Catalog (BDC) Features

  • Create a Business Data Catalog (BDC) and connect to a SQL Server Database and Web Services
  • BDC Web Parts
  • The Application Definition File
  • Consuming the BDC data through the associated web parts and in lists
  • Searching your BDC data with the new BDC search capabilities


SharePoint 2007 Enterprise Report Center Capabilities

  • Creating a Reporting Center Site from the MOSS site template
  • Creating a BI Dashboard Page
  • Modifying the Report Library with custom columns
  • Creating manual KPIs and adding them to the Dashboard page


Excel Services and the Data Connection Library

Explore Excel Services ability to connect to external data sources using the standard data connection, called the Office Data Connection (ODC), and storing it in a MOSS Data Connection Library (DCL) which can then be accessed by Excel Spreadsheets or directly from MOSS 2007 Enterprise.

  • Setting up a trusted Data Connection Library (DCL)
  • Setting MOSS security for the Data Connection Library
  • Creating an ODC spreadsheet in Excel Services
  • Changing the global access control for the MOSS environment to allow Excel to refresh data
  • Creating automatically updating web parts


OLAP-based Dashboards with Excel Services and SQL Server Analysis Services

The new OLAP features of the Excel 2007 client take it from an analysis tool and place it center stage in the BI revolution. The new OLAP functions in Excel 2007 allow the report developer to move beyond pivot tables and make it possible to retrieve report data directly from an OLAP cube and place it in any cell on the workbook. This module will cover the basics of the new features and functionality and will walk the student through creating an Excel Report based on the OLAP Functions. Topics to be discussed are:

  • Retrieving data from a Cube using OLAP Formulas
  • Building an Excel Report with OLAP functions
  • Creating Excel based KPI lists
  • Deploying the new report and KPI to an interactive dashboard
  • Setting up filters to drive parameters in an Excel Report


Integrating SQL Server Reporting Services (SSRS) with MOSS 2007 Enterprise

Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies to provide a direct integration between Reporting Services and MOSS 2007 Enterprise.

  • Working with Reporting Services Configuration Manager
  • Creating an integrated database and changing SSRS to integrated mode
  • Configuring Central Administration 3.0 for Reporting Services
  • Deploying Reports using SQL Server Business Intelligence Development Studio
  • Accessing Reporting Services Reports through a MOSS 2007 Enterprise Report Library


Business Intelligence Dashboards with SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and MOSS 2007 Enterprise

  • Deliver data-rich reports in MOSS 2007 Enterprise and creating SSRS dashboard pages with SSAS KPIs and SSAS filters.
  • Incorporating Reporting Services Reports in Web Parts
  • Connecting to the SSAS cube via the ODC connection in MOSS
  • Displaying SSAS KPIs on a dashboard page
  • Filtering SSAS KPIs via SSAS filters


Aivea SharePoint Training courses are trusted by hundreds of organizations and professionals since 2004. The quality and return on investment from our SharePoint training is unparalleled to any other in the industry. We provide SharePoint Training for some of the most respected organizations in the country.

Please contact an Aivea SharePoint 2007 Training Sales Professional at sales@aivea.com or call 1-800-779-7506  to Register or to get a no obligation needs assessment and proposal for your Microsoft Office SharePoint Server (MOSS) 2007 training needs.