Audience
This course is 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
A working knowledge of RDBMS, Business Intelligence Studio, Excel and the Office Ribbon is suggested.
Delegates must possess an understanding of the goals of Business Intelligence.
Duration
4 days. Hands on.
This course is available on site only. Please call for details.
Course Objectives
This course provides delegates with the knowledge and skills necessary to develop Microsoft End-to-End business solutions using SQL Server 2008 in an integrated environment with SharePoint and Office 2007.
Delegates will be introduced to:
- 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.
- Business Intelligence with Excel and Visio.
Course Content
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.
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.
SQL 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.