Accelerated Microsoft Business Intelligence SQL 2008

This four-day, comprehensive 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

A working knowledge of RDBMS, Business Intelligence Studio, and Excel and the Office Ribbon. Students must also possess an understanding of the goals of Business Intelligence.

The Goal of Business Intelligence
Informed and Timely Decisions
The Microsoft BI Stack
Key Concepts
Data Warehouse
Data Mart
Cubes
Dimensions
Measures
Fact Table
Key Components
SQL Server Analysis Server
SQL Server Integration Server
SQL Server Reporting Services
Data Mining
MDX
Microsoft Office SharePoint Server 2007
PerformancePoint Server
Microsoft Office 2007
Common Business Challenges in BI

UDM Defined
Definition
Structure
Data Sources
Data Views
Proactive Caching
XML Definitions
User Experience
Relational Querying the Data Sources Directly
UDM and Simplified Access
Advantages
OLAP Built on Transactional Data
Extremely Low Latency
Ease of Creation and Maintenance
Design Versioning with Source Control
Trouble in River City

What is SharePoint?
Collaboration
Portals
Enterprise Search
Content Management
Business Process and Forms
Business Intelligence
What Does SharePoint Bring to the MS BI Stack?
Key SharePoint Concepts
SharePoint or WSS?
SharePoint Architecture
Collections, Sites, Webs, SubSites
Content Types
Solutions
Features
12 Hive

Integration Services
Analysis Services
Reporting Services

Major Components
Data Import/Export Wizard
ETL Tool
Control Flow Engine
Application Platform
High Performance Data Transformation Data Pipeline
New or Changed Features
Code Samples
The SSIS Object Model
Downloading a File Using HTTP
Loading the Contents of a Text File into a Variable
Simple Custom Logging
Handling Exceptions

ETL
ETL Life Cycle
Extract
Transform
Load
Transformers
Best Practices for Deployment
Scope
Deploying Packages
Testing Packages
Data Flow Practices
Package Design
Best Practices for Design

Key Concepts
Cubes
Multi Dimension Space
Measures
Dimensions
Hierarchies
Time Dimension
Slowly Changing Dimension
Schemas

Cube Processing
Partitions
Proactive Caching
Notification Settings
Aggregations
Design of Aggregations
Monitoring Aggregations

Integration with SharePoint
SharePoint Integrated Mode
Integrated Install
Report Builder 2.0
Tablix
Charts
New Chart Types
Advanced Chart Functionality
Parameters
Interactive Sorting
Actions
Document Maps
Sub-Reports
Differences Between Environments
Developers
Basic Users
Power Users

Why a Business Data Catalog
Special BDC Only Web Parts
Business Data Web Parts
Business Data List
Business Data Item Web Pat
Business Data Related List Web Part
Business Data Item Builder
Application Definition Files
Line of Business
Entity
Method
Parameter
Filter Descriptor
Association
Action
Authentication and Security
PassThrough
RevertToSelf
WindowsCredentials/RDBCredentials
Credentials

Understanding SharePoint Security
Groups
Securable Items
Who Can See What
All Those Groups
Report Content Types
Report Subscriptions
Workflows
Out of Box
SharePoint Designer
Visual Studio
Exploring the Report Center
Reports Library
Data Connection Library
Business Web Parts
Dashboards
KPIs

Excel on the Server
Utilizing Excel Services
Limitations
Excel Web Services
Trusted File Locations
Excel User Defined Functions
SOAP
Excel Web Access
Web Parts
User Controls
Smart Part

Notable Uses of Data Mining
Pattern Mining
Subject Based Mining
Games
Business
Key Terms in Data Mining
Data Mining Model
Columns
Cases
Case Table sand Nested Tables
Types of Data Mining Algorithms
Classification Algorithms
Regression Algorithms
Segmentation Algorithms
Association Algorithms
Sequence Analysis Algorithms
The Algorithms
Excel and the BI Extensions
Add Ins
Forecast Table Analysis Tool
Prediction Calculator Tool
Shopping Basket Analysis Tool
Detect Categories Table
Analyze Key Influencers
Visio 2007