50008A: SQL Server Business Intelligence
Course Outline
Module 1: Quick Start Introduction
Lessons
• Introduction
• Integration Services
• Analysis Services
• Reporting Services
• SQL Server Management Studio
Module 2: Integration Services
Lessons
• Introduction
• Cleanse Data Input
• Output to Multiple Destinations
• Script to Branch Control
• Lookup Fuzzy Values
• Package Configuration and Deployment
Module 3: Core Analysis Services
Lessons
• Introduction
• Explore Analysis Services Objects
• Create an Account (Parent-Child) Dimension
• Create Measure Groups
• Add Time
• Work with Measures
• Create AMO
Module 4: Analysis Services Scalability
Lessons
• Analysis Services Demonstrations
• Introduction
• Cube Scalability
• Aggregates in Natural Hierarchies
Module 5: Client Reporting Tools
Lessons
• Client Reporting Tools Demonstrations
• Introduction
• Use URL Access in Applications
• Use the Web Service
Module 6: Custom OLAP Clients
Lessons
• Custom OLAP Clients Demonstrations
• Introduction
• Render Cells
• Render a Flattened Rowset
Module 7: Analytical MDX
Lessons
• Analytical MDX
• Introduction
• MDX Queries: MDX vs. SQL
• MDX Stored Procedures
Module 8: Data Mining
Lessons
• Data Mining
• Introduction
• Browse Data Mining Models
• Add DM Viewers to a Web Page
Module 9: Extending Integration Services
Lessons
• Extend Integration Services
• Introduction
• Create and Execute a Package