Course Description

MSBI Suite. MSBI stands for Microsoft Business Intelligence. MSBI is a powerful suite and is composed of tools which helps in providing best solutions for BusinessIntelligence and Data Mining Queries. MSBI empower users to gain access to accurate and up-to-date information for better decision making in an organization.

Course Content

MSBI Course Content


The course will provide an insight in MSBI using tools – SSIS, SSAS and SSRS. The contents will give a proper introduction covering all basics and advanced topics of MSBI.


SQL Server Integration Services (SSIS)

Course Contents

  • Introductory topics:
    • Overview of ETL Concepts
    • Introduction to SSIS as a tool
  • SSIS Environment Overview
    • Control Flow
    • Data Flow
    • Event Handlers
  • Basic data exchange methods
    • Using Import and Export Wizard
    • Running an Integration Services Packages
  • Data Flow Components
    • Data Flow Source
    • Data Flow Transformation
    • Data Flow Destination
  • Data Flow Transformation Components
    • Aggregates
    • Conditional Split
    • Derived Column
    • Merge
    • Merge Join
    • Multicast
    • Sort
    • Union All
  • Control Flow Components
    • For Loop Container
    • For-Each Loop Container
    • Bulk Insert Task
    • Execute SQL task
    • Precedence Constraints
    • Using Variables
    • OLE DB Source & Destination Properties
    • Error Handling/Trouble Shooting Packages
    • Break Points and Check Points
    • Dynamic Connections
    • Deploying a package
    • Schedule the package
    • Command line utilities


SQL Server Analysis Services (SSAS)

Course Contents

  • Basic concepts of Facts, Measures, Dimensions, OLAP, OLTP
  • Understanding the development environment
  • Intro to Data Warehouse
  • Intro to Dimension Modeling
  • Schemas – Star and Snow Flake Schema
  • Hierarchies, Dimension and Facts
  • Types of Hierarchies
  • FactLess Fact Table
  • Creating Data Sources
  • Creating Data Source Views
  • Creating Cubes
  • Refining Dimensions and Measures in BIDS
  • Intro to MDX
  • KPIs
  • Perspectives
  • Aggregations
  • Partitions
  • Build and Deploy the cube
  • Process Options
  • Storage Modes – MOLPA, ROLAP, HOLAP
  • Types and Facts and Dimensions
  • Security
  • Deploying Cube and Schedule the process
  • Performance Tips


SQL Server Reporting Services (SSRS)

Course Contents

  • Introduction to Reporting Concepts
  • New Environment of SSRS
  • Creating Report By Wizard
  • Page-wise Reports
  • Group Report
  • Creating a Report without wizard
  • Concept of Tablix
  • Sub-Totals
  • Matrix Report
  • Parameter Report
  • Filtering data
  • Chart/Gauge/Indicator etc
  • Format Property
  • Aggregate Functions in Reports
  • Running Totals
  • Document Map/Sub Reports
  • Drill Down and Drill Thru Reports
  • Cascade Parameter Reports
  • Build and Deploy Reports to Report Server
  • Configure Report Server
  • Linked Reports
  • Subscriptions – Standard and Data Driven Subscriptions
  • Cache/Snapshot
  • SSRS Logging