Architecting Business Intelligence in MOSS 2007
Architecting Bus. Intelligence MOSS 2007 - Description
This course is for
Solution Architects, Developers, Power Users, Administrators and Designers to use SharePoint 2007
as the enterprise business intelligence platform.
Recommended Audience for Architecting Bus. Intelligence MOSS 2007
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.
Prerequisites
Before attending this course, students should have:
- At least six months combined experience as a technical and solution architect for Microsoft Office SharePoint Server 2007 projects.
- Led consulting engagements that are focused on the business intelligence technologies of Microsoft Office SharePoint Server 2007.
- Experience gathering and analyzing customer experience.
- Completed course 5061A: Implementing Microsoft Office SharePoint Server 2007 OR MOSS 2007 End User Training - Power User (or equivalent knowledge)
Architecting Bus. Intelligence MOSS 2007 - Objectives
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
If you do not have Flash Player and cannot read the contents of this page, please install the latest version of the Flash Player.
If you are unable to install the Flash Player, please call the NTG training department for the course and class details that you need.
Phone: 866-464-7790 x.4014
