MS5008: SQL Server Business Intelligence

This two-day course provides students with the knowledge of the many new and enhanced Microsoft SQL Server business intelligence (BI) features designed to give a students a competitive advantage. These advantages include integrating multiple data sources with Integration Services; enriching data and building complex business analytics with Analysis Services; and writing, managing, and delivering rich reports with Reporting Services.

Doelgroep

IT developers.

Voorkennis

Basic knowledge of SQL Server.

Inhoud

Module 1: Quick Start Introduction

• Integration Services
• Analysis Services
• Reporting Services
• SQL Server Management Studio

Module 2: Integration Services

• Cleanse Data Input
• Output to Multiple Destinations
• Script to Branch Control
• Lookup Fuzzy Values
• Package Configuration and Deployment

Module 3: Core Analysis Services

• 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

• Analysis Services Demonstrations
• Cube Scalability
• Aggregates in Natural Hierarchies

Module 5: Client Reporting Tools

• Client Reporting Tools Demonstrations
• Use URL Access in Applications
• Use the Web Service

Module 6: Custom OLAP Clients

• Custom OLAP Clients Demonstrations
• Render Cells
• Render a Flattened Rowset

Module 7: Analytical MDX

• Analytical MDX
• MDX Queries: MDX vs. SQL
• MDX Stored Procedures

Module 8: Data Mining

• Data Mining
• Browse Data Mining Models
• Add DM Viewers to a Web Page

Module 9: Extending Integration Services

• Extend Integration Services
• Create and Execute a Package

• Gratis brochure aanvragen
• Contact opnemen