Post reply

OLAP/ Analysis Services benefits for Shipping industry

  • April 6, 2011 at 2:31 am

    #248233

    Hello,

    Does anyone know what benefits can OLAP/ Analysis Services bring to the Shipping industry as a whole ? I mean something which cannot be achieved with Reporting services or Integration Services.

    Thanks in advance for your suggestions.

    Regards,

    Paul

  • April 7, 2011 at 5:42 am

    #1308432

    Paul,

    Creating a report with aggregation for database less than 10,000 of rows can be achieved using T-SQL queries. Consider if you want to analyse the database having millions of rows and you want to find trend how your business performed in the past and how it is performing now and what to expect in the future. If you are familiar with charting and tools stock brokers or analyst use ,the underlying knowledge is from OLAP.

    Integration services is complete different set of tool that you would use to bring data together from various source to form a single package.

    Reporting services sits on top of above mentioned services to provide the reporting functionality like charting etc.

    Check this link for more information. http://www.accelebrate.com/sql_training/ssas_tutorial.htm

    Hope this clear your doubt.

    Vidhya

  • April 15, 2011 at 7:57 am

    #1312152

    sqllearner-339367 (4/7/2011)

    Paul,

    Creating a report with aggregation for database less than 10,000 of rows can be achieved using T-SQL queries. Consider if you want to analyse the database having millions of rows and you want to find trend how your business performed in the past and how it is performing now and what to expect in the future. If you are familiar with charting and tools stock brokers or analyst use ,the underlying knowledge is from OLAP.

    Integration services is complete different set of tool that you would use to bring data together from various source to form a single package.

    Reporting services sits on top of above mentioned services to provide the reporting functionality like charting etc.

    Check this link for more information. http://www.accelebrate.com/sql_training/ssas_tutorial.htm

    Hope this clear your doubt.

    Vidhya

    Thanks a lot, Vidhya, that was quite informative !!!

Viewing 3 posts - 1 through 2 (of 2 total)

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