Monday, May 22, 2006

Enhancements in SQL Server 2005 - Part II

I'm reading: Enhancements in SQL Server 2005 - Part IITweet this !
Analysis Services available in SQL Server 2005 has a lot to offer for the Business Intelligence platform. Microsoft has come up with a new Business Intelligence Studio. Analysis services makes it possible to create datawarehouses and also mine out data from OLAP data warehouses. Enhancements to Analysis services are as follows:

1) With the Business Intelligence Development Studio, it has become lot easy to use and implement this feature similiary like Visual Studio.
2) Multiple instance of Analysis services can now be implemented. I guess there's a limit of maximum 50 instances, still I am not sure of this limit.
3) New features KPI - Key Performance Indicators, support for stored procedures are avialable that enable business for making powerful analysis and decision making.
4) As published by Microsoft, Analysis services now supports Microsoft Naive Bayes algorithm which would enhance the performance of data mining.
5) Even for development there are major enhancements like Integration with CLR, XML for Analysis (XMLA), Enhanced MDX, ADOMD.Net API, Analysis Management objects, and Analysis Services Scripting Language.
6) There's a new support available now for development in live mode as well as project mode. Development in project mode makes it possible to make and test changes without affecting client's production systems.

Siddharth Mehta

No comments:

Related Posts with Thumbnails