• support@conveytechlabs.com

online_training

300.00$

Categories: ,

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 Information

  • Duration: 30 hrs
  • Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day
  • Method: Online/Classroom Training
  • Study Material: Soft Copy

Course Content

Contents

  1. 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

Key Features

  • Career oriented training.
  • One to One live interaction with a trainer.
  • Demo project end to end explanation.
  • Interview guidence with resume preparation.
  • Support with the trainer through E-mail.

    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 business intelligence and Data Mining Queries. MSBI empower users to gain access to accurate and up-to-date information for better decision making in an organization.

Live Traffic

Live Traffic Feed

Registration

Enquery

conveytechlabs