Monday, February 13, 2012

Analysis Services package in SQL2K

I'm new to Analysis Services package in SQL2K.

As data analyst I wanted to create a short presentation that would explore most advantages of using Analysis Services (Cube, datamart).

Questions:
1.Does this tool (Analysis Services) come with SQL2K?
2. Is there any light version (or client version)of Analysis Services?
3. How to start (what module I have to install , set up)
Any relevant info would be really appreciated.Thank you.

Analysis Services is the best in the market at present time. MS has the biggest market share in OLAP world. Please see the the link below for assurance. This is an independent report.

http://www.olapreport.com/market.htm

Yes Analysis Services (AS) comes free with SQL2K. If you / your organisation want to invest your money and effort into SQL Server at this point and time, I would recommend you to have a look at SQL 2005. The features and improvements to SQL2K are paramout.

You would use AS to build OLAP cubes on the server. Clients would use 3rd party products such as Pro Clarity / IA to access these cubes (to view this data, slice & dice). You can build local cubes on client if you really wanted to. Not recommended for various reasons, but nothing stopping you doing that.

Installation is very simple. Just put the CD and click on "SQL Server 2000 Components" and then select "Install Analysis Services". Please dont forget to install service pack (4 is the latest)

http://www.olapreport.com/Comment_Microsoft.htm
http://www.microsoft.com/sql/evaluation/bi/bianalysis.mspx
Thanks
Sutha

No comments:

Post a Comment