Q.What is SQL Server 2005 Analysis Services (SSAS)?
A.SSAS gives the business data an integrated view. This integrated view is provided by combining online analytical processing (OLAP) and data mining functionality. SSAS supports OLAP and allows data collected from various sources to be managed in an efficient way. Analysis services, specifically for data mining, allow use of a wide array of data mining algorithms that allows creation, designing of data mining models.
A.SSAS gives the business data an integrated view. This integrated view is provided by combining online analytical processing (OLAP) and data mining functionality. SSAS supports OLAP and allows data collected from various sources to be managed in an efficient way. Analysis services, specifically for data mining, allow use of a wide array of data mining algorithms that allows creation, designing of data mining models.
Q.What are the new features with SQL Server 2005 Analysis Services (SSAS)?
A.
1.It offers interoperability with Microsoft office 2007.
2.It eases data mining by offering better data mining algorithms and enables better predictive analysis.
3.Provides a faster query time and data refresh rates.
4.Improved tools – the business intelligence development studio integrated into visual studio allows to add data mining into the development tool box.
5.New wizards and designers for all major objects.
6.Provides a new Data Source View (DSV) object, which provides an abstraction layer on top of the data source specifying which tables from the source are available.
A.
1.It offers interoperability with Microsoft office 2007.
2.It eases data mining by offering better data mining algorithms and enables better predictive analysis.
3.Provides a faster query time and data refresh rates.
4.Improved tools – the business intelligence development studio integrated into visual studio allows to add data mining into the development tool box.
5.New wizards and designers for all major objects.
6.Provides a new Data Source View (DSV) object, which provides an abstraction layer on top of the data source specifying which tables from the source are available.
No comments:
Post a Comment