Search Courses
Dates for this class:
No dates are available for this class.

Course Details    [choose new course]     [printable version]
Introduction to Microsoft Business Intelligence from SQL 2008 through SharePoint and Office 2007 (MOC50263)
Course Number: MOC50263
Category: Database & Collaboration Tools
Duration: 4.00 days
Description
This instructor-led course 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 course introduces the students to Microsoft Unified Data Model, SQL 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.
Target Audience
This course is intended for DBAs, Developers and Business Intelligence Professionals seeking an introduction to the Microsoft BI Stack whether for new or existing projects or migration to the Microsoft environment.
Prerequisites
Before attending this course, students must have:
  • A working knowledge of RDBMS.
  • A working knowledge of Business Intelligence Studio.
  • A working knowledge of Excel and the Office Ribbon.
  • Understanding of the goals of Business Intelligence.
Objectives

After completing this course, students will be able to:

  • Describe the Microsoft Business Intelligence stack.
  • Explain the Unified Dimension Model and when it can and cannot be used.
  • Use the new Business Intelligence Features in SQL 2008.
  • Create a SSAS Project using the Microsoft Unified Dimension Model.
  • Create a Data Mart using Business Intelligence Studio.
  • Create a Integration Services project and load a Data Mart.
  • Load a Data Mart from a flat file.
  • Model Dimensions, Measures and Cubes.
  • Understand the pros and cons of Integration into SharePoint.
  • Create a Report using Report Builder 2.0.
  • Load and Manage Reports with SharePoint.
  • Understand and Create a Shared Service Provider in SharePoint.
  • Understand and Create a Business Data Catalog in SharePoint.
  • Set permissions on objects within SharePoint.
  • Utilize the Business Intelligence add-ins for Excel 2007.
Outline
Module 1: Course Overview
This module explains how the class will be structured and introduces course materials and additional administrative information.
  • 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 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

 

Additional Reading
  • To help you prepare for this class, review the following resources:
    • The Microsoft Data Warehouse Toolkit by Ralph Kimbal.
    • Smart Business Intelligence Solutions with Microsoft SQL Server2008.
    • Microsoft SQL Server 2008 Analysis Services Unleashed.