> > > 50263 Detailed outline

Introduction to Microsoft Business Intelligence from SQL 2008 Through SharePoint and Office 2007 (50263)

Course Description Schedule Course Outline

Detailed Course Outline

Module 1: Course Overview

Lessons

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We'll Be Discussing

Module 2: Overview of the Microsoft BI Stack

Lessons

  • The Goal of Business Intelligence
  • Key Concepts
  • Key Components
  • SharePoint Report Center
  • Office 2007
  • Common Business Challenges in BI

Module 3: Unified Data Model

Lessons

  • UDM Defined
  • User Experience: Relational vs. UDM
  • Advantages
  • Trouble in River City

Lab : Unified Data Model

  • Creating a Data Mart using Business Intelligence Development Studio
  • Enabling Table Compression

Module 4: SharePoint and Business Intelligence

Lessons

  • What is SharePoint?
  • What Does SharePoint Bring to the BI?
  • Key SharePoint Concepts
  • SharePoint or WSS?
  • SharePoint Architecture
  • Content Types
  • Solutions
  • Features

Lab : SharePoint and Business Intelligence

  • Setting up A Report Center
  • Shared Service Provider

Module 5: New BI Features in SQL 2008

Lessons

  • Integration Services/Analysis Services/Reporting Services
  • Performance Enhancements
  • Programmability Enhancements
  • Architectural Enhancements
  • Usability Enhancements

Lab : New BI Features in SQL 2008

  • Explore Some Of The New Features

Module 6: SSIS Major Components

Lessons

  • Major Components
  • New or Changed Features
  • Script Task
  • Samples

Lab : SSIS Projects

  • Create A SSIS Project
  • Add a Data Source
  • Create A Data Flow
  • Create Another Data Flow
  • Load Data via a SQL Statement

Module 7: SSIS ETL

Lessons

  • SSIS and ETL
  • Transformers
  • Best Practices 1
  • Best Practices 2

Lab : SSIS ETL

  • Populating the Fact Table
  • Loading Manufacturing Facts
  • Handling Errors
  • Inventory Fact Flow

Module 8: SSAS Key Concepts

Lessons

  • Key Concepts
  • Schemas
  • Measures
  • Dimensions

Lab : SSAS Key Concepts

  • Define an OLAP Cube
  • Working with Measures and Measure Groups
  • Time and Hierarchies
  • Relating Dimensions
  • Build Deploy and Browse the Cube

Module 9: SSAS Cube Details

Lessons

  • Cube Processing
  • Partitions
  • Proactive Caching
  • Aggregations

Lab : SSAS Cube Details

  • Multiple Partitions
  • Set Storage
  • Design Aggregations
  • Default Members

Module 10: SQL Server Reporting Services

Lessons

  • Integration with SharePoint
  • Report Builder 2.0
  • Differences Between Environments
  • Tablix
  • Charts

Lab : SQL Server Reporting Services

  • SSRS Projects Report Wizard
  • SSRS SMDL
  • Report Builder 2.0

Module 11: SharePoint Business Data Catalog

Lessons

  • The BDC
  • Special BDC Only Web Parts
  • Application Definition Files

Lab : SharePoint Business Data Catalog

  • Use a BDC Application
  • Explore BDC Web Parts
  • Use a BDC List

Module 12: SharePoint Integrated Security and Report Management

Lessons

  • Understanding SharePoint Security
  • Report Content Types
  • Report Subscriptions
  • Workflows
  • Reports Library
  • Business Web Parts

Lab : SharePoint Integrated Security and Report Management

  • Examine Permissions
  • Set Shared Schedule for Subscriptions
  • Manage Data Connections
  • Set up a Subscription

Module 13: Excel Web Services
Lessons

  • Excel Web Access
  • Excel Web Services
  • User Defined Function

Lab : Excel Web Services (Optional)

  • Excel Web Access
  • Excel Web Services
  • User Defined Function

Module 14: Excel 2007 and Data Mining BI

Lessons

  • Key Terms in Data Mining
  • Types of Data Mining Algorithms
  • The Algorithms
  • Excel and The BI Extensions
  • Visio 2007

Lab : Excel 2007 and Data Mining BI

  • Utilize the Excel Data Mining Tools
 

Accessing our website tells us you are happy to receive all our cookies. However you can change your cookie settings at any time. Find out more.   Got it!