> > > 50263 Detailed outline

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

Course Description Kurs tarihleri 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
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!