Features and concepts of Analysis Services

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

Features and concepts of Analysis Services.

Analysis service provides a combined view of the data used in OLAP or Data mining. Services here refer to OLAP, Data mining. Analysis services assists in creating, designing and managing multidimensional structures containing data from varied sources. It provides a wide array of data mining algorithms for specific trends and needs.
What is Analysis service repository?
What is Analysis service repository? - Each server running analysis service has a repository to store objects of the computer.......
SQL Server - What is SQL service broker?
What is SQL service broker? - SQL service broker provides asynchronous queuing functionality to SQL server.......
What is user defined datatypes and when you should go for them?
What is user defined datatypes? - User defined datatypes is created by using base SQL Server data type by providing......
Post your comment