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

About This Presentation
Title:

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

Description:

IQ online training is a World Class IT, Software Online Training that offers web-based training for numerous IT courses from business experts along with job support and offers guidance in Certification Exams. Absolutely providing quality online training courses at affordable prices. Register now for FREE Live Demo, training in flexible timings, certification preparation, 24*7 Support team, Weekday and weekend batches, Job Support. Register Now@ – PowerPoint PPT presentation

Number of Views:118

less

Transcript and Presenter's Notes

Title: 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
Write a Comment
User Comments (0)
About PowerShow.com