Thursday, May 8, 2014

MSBI: Architectural Overview of SSIS,SSRS and SSAS

So guys! We are getting closer now to the technical side of Business Intelligence !

Let me present you the architectural overview of BI tools.

Components of SQL Server

  • Database Engine
  • SSIS:  SQL Server Integration Services
  • SSAS: SQL Server Analysis Services
  • SSRS: SQL Server Reporting Services

Architecture of SSRS
As we know SSRS is Reporting tool which means should have reach and fast user interface Primary Component.

Above diagram are self-explanatory, we can see report server fetching data for Users where we can also insert custom code if required.

Architecture of SSIS
  • The run-time engine implements the control flow and package management infrastructure
  • The data flow engine is a specialized, high performance engine that is exclusively dedicated to extracting, transforming, and loading data.
  • Integration Services supports both native and managed code.
  • The Integration Services service, monitors running Integration Services packages and manages the storage of packages.

Architecture of SSAS

Server Architecture for SSAS
Client Architecture

For Multidimensional Data Architecture

Hope this helps!! :)


  1. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in MSBI, kindly contact us
    MaxMunus Offer World Class Virtual Instructor led training on in MSBI. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Nitesh Kumar
    Skype id: nitesh_maxmunus
    Ph:(+91) 8553912023

  2. I just see the post i am so happy the post of information's.So I have really enjoyed and reading your blogs for these posts.Any way I’ll be subscribing to your feed and I hope you post again soon.
    MSBI Training in Chennai

  3. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Android Training in Chennai
    Ios Training in Chennai

  4. it is really amazing...thanks for sharing....provide more useful information...
    Mobile app development company

  5. Nice post about MSBI, are you looking for best msbi online training.