• Data Flow Overview

• Data Sources

• Data Destinations

• Data Flow Transformations

• Data Viewers

• Excel Source

• Flat File Source

• OLE DB Source

• XML Source

• Aggregate Transformation

• Audit Transformation

• Character Map Transformation

• Conditional Split Transformation

• Copy Column Transformation

• Derived Column Transformation

• Data Conversion Transformation

• Multicast Transformation

• OLE DB Command Transformation

• Percentage Sampling Transformation

• Row Count Transformation

• Sort Transformation

• Union All Transformation

• Lookup Transformation

• Merge Transformation

• Merge Join Transformation

• Slowly Changing Dimension Transformation

• Pivot Transformation

• Export Transformation

• Import Transformation

• Unpivot Transformation

• Data Reader Destination

• Excel Destination

• Flat File Destination

• OLE DB Destination

• Control Flow Overview

• Precedence Constraints

• The Execute SQL Task

• The Bulk Insert Task

• The File System Task

• The FTP Task

• The Send Mail Task

• Bulk Insert Task

• Data Flow Task

• Execute DTS 2000 Package Task

• Execute Package Task

• Execute Process Task

• Web Service Task

• XML Task

• For Loop Container

• For Each Loop Container

• Sequence Container

• Variables Overview

• Variable scope

• SSIS system variables

• Using variables in control flow

• Using variables in data flow

• Using variables to pass information between packages

• Property expressions

• Configuration Overview

• Configuration options

• Configuration discipline

• SSIS debugging overview

• Breakpoints in SSIS

• Control Flow: The On Error event handler

• Data Flow: Error data flow

• Configuring Package Logging

• Built-in log providers

• Extending SSIS through Custom Code – Scripting

• The SSIS script editor

• The SSIS object model

• The script in Control flow: The Script Task

• The script in Data flow: The Script Component

• Introduction to SSIS component development

• Configurations and deployment

• The deployment utility

• Deployment options

• Deployment security

• Executing packages – DTExec and DTExecUI

• The SSIS Service

• Managing packages with DTUtil

• Managing packages with SQL Server Management Studio

• Scheduling packages with SQL Server Agent

What Is Microsoft Business Intelligence?

• Defining Microsoft Business Intelligence

• Understanding the UDM

• Building and Viewing a Sample Cube

• Viewing a Cube Using Excel

• Cubes in Reporting Services

• Using SSAS in BIDS

• Understanding BIDS

• Creating Data Sources

• Creating Data Source Views

• Creating a Cube Using the Wizard

• Refining Dimensions and Measures

• Creating KPIs

• Creating Perspectives

• Creating Translations

• Creating Actions

• Working with Multiple Fact Tables

• Using Advanced Dimension Types

• Working with Changing Dimensions

• Using the Business Intelligence Wizard

• Basic Storage: MOLAP

• Customised Aggregations

• Advanced Storage: MOLAP, HOLAP, or ROLAP

• Implementing Proactive Caching

• Using Partitions: Relational or SSAS

• Beginning MDX

• Understanding MDX

• About Members, Tuples, and Sets

• Common MDX Functions Explained

• New or Updated MDX Functions or Keywords

• Understanding the Calculations Sub tab

• Adding Calculated Members

• Adding MDX Scripts

• Adding Named Sets

• Implementing SSAS Security

• Implementing XMLA Scripts

• Understanding SSAS Backup and Restore

• Understanding Performance Optimization

• Using Excel 2007 Pivot Tables

• Using SQL Server Reporting Services

• SQL Server 2008R2 Reporting Services

• Report types and formats

• SSRS Web Services

• Report Server

• Report Builder

• Model Designer

Authoring Reports

• Creating basic reports

• Tabular

• List

• Matrix

• Chart

• Constructing data sources and Datasets

• Inserting a data region, fields and images

• Leveraging expressions

• Calculating fields

• Integrating expressions in properties

• Applying conditional formatting

• Adding images

• Grouping and sorting data

• Grouping to multiple levels

• Sorting the results

• Employing aggregate functions

• Building parameters into reports

• Returning subsets of data with query parameters

• Mapping report parameters to query parameters

• Building cascading report parameters

• Passing parameters to stored procedures

• Exploiting multivalve parameters

• Restricting report data with filters

• Enhancing performance with filters

• Filters vs query parameters

• Localising tables and queries

• Leveraging Advanced Reporting Features

• Combining data regions in one report

• Utilising sequential and nested regions

• Producing master/detail reports

• Linking subreports

• Presenting data with appropriate detail

• Revealing report detail with drill down

• Displaying related data with drill through

• Navigating with document maps

• Deploying reports to the server

• Preparing reports for publishing

• Configuring project properties

• Units of deployment: Individual reports, projects, solutions, data sources

• Checking results with Report Manager

• Securing the RS environment

• Assigning users to roles

• Setting permissions on report items

• Granting and revoking system-level permissions

• Deploying Report Builder to users

• Dragging and dropping entities onto charts and tabular reports

• Navigating data with infinite drill through