Microsoft Business Intelligence from SQL 2008 through SharePoint and Office 2007

Delivery Options

• Live Online Training - Public Class (5 days): $2,375.00

» Free Demo

» Watch Presentation

» More Info

» Contact Education Consultant

• Customized Onsite Training (5 days): Request a Proposal

Upcoming Live eLearning Classes

There are currently no upcoming Live eLearning classes. Please contact us if you would like us to schedule a class.

Class Description

Class Overview

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.

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

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

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.

Technical Requirements

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

• Instructor-led Online course technical requirements and setup instructions.
• WebEx system requirements for Instructor-led Online delivery option.
• Onsite course technical requirements and setup instructions.