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
SQL Training Audience:
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.
SQL Training Prerequisites
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.
SQL Training Course duration
4 days
SQL Training Course outline
The Microsoft Business Intelligence Stack
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
SharePoint Report Center
Office 2007
Common Business Challenges in BI
Unified Data Model
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
Trouble in River City
When Not to Use the UDM
SharePoint and Business Intelligence
What is SharePoint?
Collaboration
Portals
Enterprise Search
Content Management
Business Process and Forms
Business Intelligence
What Does SharePoint Bring to BI?
Key SharePoint Concepts
SharePoint or WSS?
SharePoint Architecture
MOSS Adopts a Typical 3-Tier Model
The Shared Service Provider
Content Types
Document Classification System
Metadata
Document Templates
Forms Associate With
Workflows Associated With
Supports Inheritance
Solutions
Features
12 Hive
New BI Features in SQL 2008
Integration Services
Analysis Services
Reporting Services
SQL Server Integration Services Major Components
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
SQ Server Integration Services Extract/Transform/Load
SSIS and 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
SQL Server Analysis Server Part 1
Key Concepts
Cubes
Multi Dimension Space
Schemas
Star
Snowflake
Measures
Dimensions
Hierarchies
Time Dimension
Slowly Changing Dimension
SQL Server Analysis Server Part 2
Cube Processing
Partitions
Proactive Caching
Notification Settings
Aggregations
Design of Aggregations
Monitoring
SQL Server Reporting Services
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
Interactive Features
Differences Between Environments
Developers
Basic Users
Power Users
SharePoint Business Data Catalog
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
Credential
SharePoint Integrated Security and Report Management
Understanding SharePoint Security
Groups
Securable Items
Report Content Types
Report Subscriptions
Scheduled Delivery
Rendering Type
Where to Deliver
SharePoint
File Share
Workflows
Out of Box
SharePoint Designer
Visual Studio
Reports Library
Part of the Report Center Template
Default Content Types
Can be Created in Any Site
Default Launch is Excel
Business Web Parts
What is a Web Part?
Excel 2007 and Data Mining
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
