MSBI(SSIS,SSAS, SSRS) Online Training Course - Job Support

1
Microsoft Business IntelligenceSSIS SSAS
SSRS Online Training Job
SupportWithCertification Preparation
MSBI INTRODUCTION AND ITS ENTITIES (SSIS, SSAS,
SSRS)
2
MSBI ONLINE TRAINING

• MSBI Overview
• Entities of MSBI
• Course Objective
• Course Curriculum
• Benefits Of Learning MSBI at IQ Online

3
MSBI OVERVIEW

• - MSBI stands for Microsoft Business
  Intelligence that is a most effective suite with
  the collection of a device
• - It lets in offering best solutions for the
  Business Intelligence and Data Mining Queries.
• - MSBI empower customers to gain the access to
  accurate and up to date facts for higher decision
  making in an company.

4
ENTITIES OF MSBI

• MSBI is divided into 3 entities-
• SSIS  SQL Server Integration Services
  Integration tool.
• SSAS  SQL Server Analytical Services Analysis
  tool.
• SSRS  SQL Server Reporting Services Reporting
  tool.

5
SSIS

• SSIS is a tool used for ETL. ETL stands for
  Extract Transform and Load. These are simple
  day-to-day words we use in our daily lives. The
  figure below depicts ETL in real world scenario.
• E-Extract Data
• Extract Data from various homogeneous or
  non-homogeneous source systems. Data could be
  stored in any of the following forms though not
  limited to them. 

6
SSIS

• T-Transform Data
• The data are coming from various sources. We
  cannot assume that the data is the structure in
  the same way across all the sources. Thus, we
  need to transform the data to a common format so
  that the other transformations are done on them.
• L-Load Data 
• Once the transformations were done and data takes
  the form as per the rule. We have to load the
  data to the destination systems.

7
SSAS

• This is the method of changing two dimensional
  (rows and columns/OLTP) statistics into
  multi-dimensional data version (OLTP).
• Benefits of SSAS are as follows
• - Multi-dimensional evaluation
• - Key performance Indicator (KPI)
• - Slice, cube, drill down
  functionalities
• - Good performance

8
SSRS

• Microsoft SQL Server Reporting Services (SSRS) is
  a company reporting platform helping conventional
  and interactive reports delivered over the net or
  through custom applications. It supports two
  dimensional and multi-dimensional.
• The following are a few functions of SSRS
• - Retrieve information from different source
• - Web based access to reports
• - Support for Ad-hoc reporting

9
COURSE OBJECTIVE
10
COURSE CURRICULUM
11
BENEFITS AT IQ ONLINE TRAINING
12
Call Us 1 732-593-8450, 91 998-952-7180
Email Us info_at_iqtrainings.com
www.iqonlinetraining.com