Delivering Business Intelligence using Microsoft SQL Server 2005

Course Outline

• Data Warehousing & BI Concepts
• Business Intelligence
• Structure Continuum
• Reporting Solution Alternatives
• Quick Start: Introduction to BI Tools
• Demos

• Cleanse Data Input
• Split an Output Channel
• Script to Branch Control
• Lookup Fuzzy Values
• Loop through Folder
• Configure and Deploy
• Demos
• Labs

• Analysis Services (OLAP)
• Programmability Preview
• Deployment
• Account Dimension
• Measure Groups and Time
• Alternate Aggregations
• AMO Development
• Tools Proactive Management
• Demos
• Labs

• Partitions and Processing
• Aggregation Concepts
• Designing Aggregations
• Aggregations and AMO
• Specialized Topics
• Demos
• Labs

• Reporting Tool Overview – Excel, Reporting Services
• Integrating Reports
• Demos

• Introduction to MDX
• Query Statements
• Key Query Techniques
• MDX Formulas
• Formula Examples
• Scripts
• Stored Procedures
• Demos
• Labs

• DTS Extensibility
• Custom Transformation
• Custom Package
• Demos
• Labs

• Reporting Services Development Opportunities
• Generating RDL Programmatically
• Deploying Reports
• Security Overview
• Demos
• Labs

Back to Course Description   Onsite Training   Class Schedule