Answers

Question and Answer:

  Home  Basic SQL Server

⟩ Explain features and concepts of Analysis Services?

Analysis Services is a middle tier server for analytical processing, OLAP, and Data mining. It manages multidimensional cubes of data and provides access to heaps of information including aggregation of data One can create data mining models from data sources and use it for Business Intelligence also including reporting features.

Some of the key features are:

Ease of use with a lot of wizards and designers.

Flexible data model creation and management

Scalable architecture to handle OLAP

Provides integration of administration tools, data sources, security, caching, and reporting etc.

Provides extensive support for custom applications

 135 views

More Questions for you: