Introduction to Microsoft Business Intelligence from SQL 2008 through SharePoint and Office 2007

Introduction to Microsoft Business Intelligence from SQL 2008 through SharePoint and Office 2007

Course 50263 : 4 days; Instructor-Led

About this Course

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, Excel Web Services, and Business Intelligence with Excel 2007 and Visio 2007.

Audience Profile

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.

At Course Completion

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.

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.

Course 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 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 Kimbal
Smart Business Intelligence Solutions with Microsoft SQL Server2008
Microsoft SQL Server 2008 Analysis Services Unleashed

For more information or to give feedback, send e-mail to info@OneApex.com or call 949-597-2100