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 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
Additional Reading
To help you prepare for this class, review the following resources:
• The Microsoft Data Warehouse Toolkit by Ralph Kimball
• Smart Business Intelligence Solutions with Microsoft SQL Server 2008
• Microsoft SQL Server 2008 Analysis Services Unleashed