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!! :)



8 comments:

  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 http://www.maxmunus.com/contact
    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
    MaxMunus
    E-mail: nitesh@maxmunus.com
    Skype id: nitesh_maxmunus
    Ph:(+91) 8553912023
    http://www.maxmunus.com/


    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete



  3. INSTEAD OF GETTING A LOAN,, I GOT SOMETHING NEW
    Get $10,050 USD every week, for six months!

    See how it works
    Do you know you can hack into any ATM machine with a hacked ATM card??
    Make up you mind before applying, straight deal...
    Order for a blank ATM card now and get millions within a week!: contact us
    via email address:: besthackersworld58@gmail.com or whats-app +1(323)-723-2568

    We have specially programmed ATM cards that can be use to hack ATM
    machines, the ATM cards can be used to withdraw at the ATM or swipe, at
    stores and POS. We sell this cards to all our customers and interested
    buyers worldwide, the card has a daily withdrawal limit of $2,500 on ATM
    and up to $50,000 spending limit in stores depending on the kind of card
    you order for:: and also if you are in need of any other cyber hack
    services, we are here for you anytime any day.
    Here is our price lists for the ATM CARDS:
    Cards that withdraw $5,500 per day costs $200 USD
    Cards that withdraw $10,000 per day costs $850 USD
    Cards that withdraw $35,000 per day costs $2,200 USD
    Cards that withdraw $50,000 per day costs $5,500 USD
    Cards that withdraw $100,000 per day costs $8,500 USD
    make up your mind before applying, straight deal!!!

    The price include shipping fees and charges, order now: contact us via
    email address::besthackersworld58@gmail.com or whats-app +1(323)-723-2568

    ReplyDelete
  4. IntelliMindz is a best IT Training in Bangalore with placement, offering 200 and more software courses with 100% Placement Assistance.
    MSBI Training In Bangalore
    MSBI Online Training
    MSBI Training In Chennai

    ReplyDelete
  5. An awesome blog for the freshers. Thanks for posting this information.
    Msbi Online Training
    Msbi Developer Course

    ReplyDelete