About Course

Course Information

MSBI stands for “Microsoft Business Intelligence”. It’s a powerful tool; it makes information in ‘ETL’ format. Where ETL is (Extract Transform and Load) tool.

The main concept present in MSBI is ETL tool it makes easy to find a solution. MSBI Uses Visual studio and SQL Server.

There are 3 types of Tools in MSBI

  • SSIS Integration Tool
  • SSAS Analysis Tool
  • SSRS Reporting Tool

SSIS Integration Tool: There are 2 types of packages present in SSIS Integration Tool they are:

  1. SSIS Deployment Package
  2. SSIS Management Package

SAS Analysis Tool: There are 2 types in Analysis of SSAS Tool:

  1. SSAS Clients
  2. SSAS Reporting Services

SSRS Reporting Tool:

  1. Authoring Reports
  2. Expressions of Leverages
  3. Sorting& Grouping of Information
  4. Filtering and Parameterized concepts
  5. Deploying &Delivering Reports

This tool makes users to access information accurately and makes work easily. It is easy to enhance business ability.

Development of Business Intelligence Tool:

>> Data Flow

>> Data Source

>> Transformation of Data Flow

>> Dynamic Data Flow

>> Destinations Data Flow

>> Data Flow in Advanced

>> Control Flow & their configurations

Course Content

Please Download for Detailed Course Content

Core topics of MSBI Online Course

SQL SERVER 2012 INTEGRATION SERVICES:

  • Control Flow
  • Data Flow
  • Administration

SQL SERVER 2012 REPORTING SERVICES:

  • Designing reports – Fundamentals
  • Designing reports – Further techniques
  • Multiple Reports
  • Alternative Visualisation
  • Administration

SQL SERVER 2012 ANALYSIS SERVICES:

  • Building dimension tables
  • Dimension design
  • Cube design
  • Visualisation

Demo Video

Watch MSBI Demo Video

About Trainer

Trainer Information

  • Having 12 Years of hands on experience on different Domains
  • Working from last 12 years on MicroSoft Technologies
  • Working from last 7 years on MSBI (SSAS, SSIS, SSRS)
  • Having 5 Years of Corporate and Online training Experience
  • MS-BI Certified Consultant