Microsoft Business Intelligence from SQL 2008 through SharePoint and Office 2007

Microsoft Business Intelligence from SQL 2008 through SharePoint and Office 2007 Class Overview

This Business Intelligence (BI) training class provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 in an integrated environment with SharePoint and Office 2007. The BI class introduces students to Microsoft Unified Data Model, SQL Server 2008 Analysis Services, Integration Services, Reporting Services, Report Builder 2.0, SharePoint 2007 Integration, Reporting Services Content Types, Business Data Catalog, and Business Intelligence with Excel 2007 and Visio 2007.

Microsoft Business Intelligence from SQL 2008 through SharePoint and Office 2007 Class Goals

• Learn to describe the Microsoft Business Intelligence stack.
• Learn to explain the Unified Dimension Model and when it can and cannot be used.
• Learn to use the new Business Intelligence Features in SQL 2008.
• Learn to create a SSAS Project using the Microsoft Unified Dimension Model.
• Learn to create a Data Mart using Business Intelligence Studio.
• Learn to create a Integration Services project and load a Data Mart.
• Learn to load a Data Mart from a flat file.
• Learn to model Dimensions, Measures and Cubes.
• Learn to understand the pros and cons of Integration into SharePoint.
• Learn to create a Report using Report Builder 2.0.
• Learn to load and Manage Reports with SharePoint.
• Learn to understand and Create a Shared Service Provider in SharePoint.
• Learn to understand and Create a Business Data Catalog in SharePoint.
• Learn to set permissions on objects within SharePoint.
• Learn to utilize the Business Intelligence add-ins for Excel 2007.

Microsoft Business Intelligence from SQL 2008 through SharePoint and Office 2007 Class Outline

1. Overview Of the Microsoft BI Stack
   1. The Goal of Business Intelligence
   2. Key Concepts
   3. Key Components
   4. SharePoint Report Center
   5. Office 2007
   6. Common Business Challenges in BI
2. Unified Data Model
   1. UDM Defined
   2. User Experience: Relational vs. UDM
   3. Advantages
   4. Trouble in River City
   5. Lab: Unified Data Model
3. SharePoint and Business Intelligence
   1. What is SharePoint?
   2. What Does SharePoint Bring to the BI?
   3. Key SharePoint Concepts
   4. SharePoint or WSS?
   5. SharePoint Architecture
   6. Content Types
   7. Solutions
   8. Features
   9. Lab: SharePoint and Business Intelligence
4. New BI Features in SQL 2008
   1. Integration Services/Analysis Services/Reporting Services
   2. Performance Enhancements
   3. Programmability Enhancements
   4. Architectural Enhancements
   5. Usability Enhancements
   6. Lab: New BI Features in SQL 2008
5. SSIS Major Components
   1. Major Components
   2. New or Changed Features
   3. Script Task
   4. Samples
   5. Lab: SSIS Projects
6. SSIS ETL
   1. SSIS and ETL
   2. Transformers
   3. Best Practices 1
   4. Best Practices 2
   5. Lab: SSIS ETL
7. SSAS Key Concepts
   1. Key Concepts
   2. Schemas
   3. Measures
   4. Dimensions
   5. Lab: SSAS Key Concepts
8. SSAS Cube Details
   1. Cube Processing
   2. Partitions
   3. Proactive Caching
   4. Aggregations
   5. Lab: SSAS Cube Details
9. SQL Server Reporting Services
   1. Integration with SharePoint
   2. Report Builder 2.0
   3. Differences Between Environments
   4. Tablix
   5. Charts
   6. Lab: SQL Server Reporting Services
10. SharePoint Business Data Catalog
    1. The BDC
    2. Special BDC Only Web Parts
    3. Application Definition Files
    4. Lab: SharePoint Business Data Catalog
11. SharePoint Integrated Security and Report Management
    1. Understanding SharePoint Security
    2. Report Content Types
    3. Report Subscriptions
    4. Workflows
    5. Reports Library
    6. Business Web Parts
    7. Lab: SharePoint Integrated Security and Report Management
12. Excel 2007 and Data Mining BI
    1. Key Terms in Data Mining
    2. Types of Data Mining Algorithms
    3. The Algorithms
    4. Excel and The BI Extensions
    5. Visio 2007
    6. Lab: Excel 2007 and Data Mining BI

Microsoft Business Intelligence from SQL 2008 through SharePoint and Office 2007 Class Prerequisites

Experience in the following areas is required:

• RDBMS
• Business Intelligence Studio
• Excel and the Office Ribbon
• Understanding of the goals of Business Intelligence.

Microsoft Business Intelligence from SQL 2008 through SharePoint and Office 2007 Class Materials

Each student will receive a comprehensive set of materials, including course notes and all the class examples.

Class Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away:

• Click here for technical requirements and setup instructions