Is there any difference between MSBI and SSAS?

  • Is there any difference between MSBI and SSAS?

    if yes?whats it?

    Thanks

  • Yes, SSAS is a component of MSBI, which usually utilizes SSRS and SSIS and sometimes MOSS. Loosely defined, MSBI doesn't even need to include SSAS. It can be argued that most MSBI is done solely in MS Excel.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • Thanx Allen Can u help me in start with practical LABS for MSBI and SSAS and MOSS.

    Why MSBI is dependedent on Excel?

    Thanks

  • You can start SSAS from below listed sites:

    http://www.learnmicrosoftbi.com/

    This website contain lot of videos to learn SSAS basics. I found this website quite useful.

    http://www.msbiconcepts.com/

    This website has some good articles on proactive caching, performance tuning, Key performance indicators, excel BI reporting. This provides good tutorials to learn MDX functions.

  • forsqlserver (9/1/2011)


    Thanx Allen

    It's either Drew or Mr. Allen.

    Can u help me in start with practical LABS for MSBI and SSAS and MOSS.

    That's beyond the scope of this site. There's a tool called a search engine that will help you. I use Google. Here's a link to show you how it works.

    http://lmgtfy.com/?q=MSBI+tutorials

    Why MSBI is dependedent on Excel?

    MSBI is not dependent on any particular tool. It just refers to using MS products to do business intelligence. Excel qualifies as a MS product and pivot tables qualify as rudimentary BI, so using Excel pivot tables qualifies as MSBI in a very loose interpretation of that term.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply