Explain the elements of SQL Server Business Intelligence.

Input and output data, script to branch control, and configure and deploy packages.

Create an account and work with measures.

Scale Analysis Services.

Use Client Reporting Tools and the web service.

Create custom OLAP clients.

Create queries using Analytical MDX.

Create and execute a package using Integration Services.

Basic knowledge of SQL Server

Introduction

Integration Services

Analysis Services

Reporting Services

SQL Server Management Studio

Introduction

Cleanse Data Input

Output to Multiple Destinations

Script to Branch Control

Lookup Fuzzy Values

Package Configuration and Deployment

Introduction

Explore Analysis Services Objects

Create an Account (Parent-Child) Dimension

Create Measure Groups

Add Time

Work with Measures

Create AMO

Analysis Services Demonstrations

Introduction

Cube Scalability

Aggregates in Natural Hierarchies

Client Reporting Tools Demonstrations

Introduction

Use URL Access in Applications

Use the Web Service

Custom OLAP Clients Demonstrations

Introduction

Render Cells

Render a Flattened Rowset

Analytical MDX

Introduction

MDX Queries: MDX vs. SQL

MDX Stored Procedures

Data Mining

Introduction

Browse Data Mining Models

Add DM Viewers to a Web Page

Extend Integration Services

Introduction

Create and Execute a Package