MSBI (SSIS, SSRS and SSAS) Certification Training

✔ SSIS Package Architecture Overview

✔ Development and Management Tools

✔ Deploying and Managing SSIS Packages

✔ Source Control for SSIS Packages

✔ The Import and Export Wizard

✔ Importing and Exporting Data

✔ Working with Packages

✔ Database Maintenance Plans

✔ Creating Database Maintenance Plans using SSMS

✔ Scheduling and Executing Plans

✔ Examining Database Maintenance Plan Packages

✔ Launching BIDS

✔ Project templates

✔ The package designer

✔ The Toolbox

✔ Solution Explorer

✔ The Properties window

✔ The Variables window

✔ The SSIS menu

✔ Control Flow Overview

✔ Precedence Constraints

✔ Execute SQL Task

✔ Bulk Insert Task

✔ File System Task

✔ FTP Task

✔ Send Mail Task

✔ Containers – grouping and looping

✔ Web Service Task

✔ WMI tasks

✔ Analysis Services tasks

✔ Execute Process Task

✔ Execute Package Task

✔ Data Flow Overview

✔ Data Sources

✔ Data Destinations

✔ Data Transformations

✔ Copy Column Transformation

✔ Derived Column Transformation

✔ Data Conversion Transformation

✔ Conditional Split Transformation

✔ Aggregate Transformation

✔ Sort Transformation

✔ Data Viewers

✔ 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

✔ SSIS debugging windows

✔ Control Flow: The OnError event handler

✔ Data Flow: Error data flow

✔ Configuring Package Logging

✔ Built-in log providers

✔ Revisiting data sources and destinations

✔ He Lookup Transformation

✔ Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations

✔ Multicast Transformation

✔ Merge and Merge Join Transformations

✔ Data Mining Query Transformation

✔ Data Mining Model Training Destination

✔ Slowly Changing Dimension Transformation

✔ Introduction to SSIS scripting

✔ SSIS script editor

✔ SSIS object model

✔ Script in Control flow: The Script Task

✔ Script in Data flow: The Script Component

✔ Introduction to SSIS component development

✔ Configurations and deployment

✔ Deployment utility

✔ Deployment options

✔ Deployment security

✔ Executing packages – DTExec and DTExecUI

✔ Data Mining Model Training Destination

✔ Slowly Changing Dimension Transformation

✔ SSIS Service

✔ Managing packages with SQL Server Management Studio Scheduling packages with SQL Server Agent

✔ Tour of Features

✔ Reporting Services Architecture

✔ Reporting Services Terminology

✔ Reporting Services Editions

✔ Taking Reporting Services for a Spin

✔ Deconstructing Reporting Services

✔ Shared Data Sources

✔ Creating Reports from Scratch

✔ Creating Expressions

✔ Using the Global Collections

✔ Formatting Items

✔ Conditional Formatting

✔ Creating Groups

✔ Calculating Totals and Percentages

✔ Interactive Sorting

✔ Creating Drill-Down Reports

✔ Creating Report Parameters

✔ Creating Drop-Down Parameters

✔ Multi-Valued Parameters

✔ Debugging Parameter Issues

✔ Creating a Basic Matrix Report

✔ Matrix Subtotals

✔ Creating a Basic Chart

✔ Exploring the Charting Possibilities

✔ Deploying Reports and Data Sources

✔ Exporting Reports and Printing

✔ Using the Web-Based Report Manager

✔ Using SQL Server Management Studio-based Reporting Services Manager

✔ Caching and Snapshots

✔ Creating Standard Subscriptions

✔ Creating Data-Driven Subscriptions

✔ Managing Subscriptions

✔ Report Builder Architecture

✔ Creating Report Model Projects

✔ Running Report Builder

✔ Core concept – BI is the cube or UDM

✔ Example cube as seen using Excel pivot table

✔ MSBI is comprehensive – more than Analysis Services on SQL Server

✔ Demonstration of SQL Reporting Services with cube as data source

✔ Understanding the development environment

✔ Creating Data Sources and Data Source Views

✔ Creating cubes – using Cube Build Wizard

✔ Refining Dimensions and Measures in BIDS

✔ KPIs Calculations

✔ Translations – cube metadata and currency localization

✔ Actions – regular, drill-through and reporting

✔ Storage topics – basic aggregations, MOLAP

✔ Advanced Storage Design – MOLAP, ROLAP, HOLAP

✔ Partitions – relational and Analysis Services partitions

✔ Customizing Aggregation Design – Processing Design

✔ Welcome to the Real-Time – Proactive Caching

✔ Cube processing options

✔ Basic syntax

✔ Using the MDX query editor in SQL Server Management Studio

✔ Most-used Functions & Common tasks

✔ New MDX functions

✔ Adding calculated members

✔ Adding scripts

✔ Adding named sets