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