Microsoft SQL Server 2000 Analysis Services is a middle-tier server for online analytical processing (OLAP) and data mining.
The Analysis Services system includes a server that manages multidimensional cubes of data for analysis and provides rapid client access to cube information. Analysis Services organises data from a data warehouse into cubes with data to provide rapid answers to complex analytical queries.
Analysis Services also allows you to create data mining models from both multidimensional (OLAP) and relational data sources. You can apply data mining models to both types of data.
PivotTable Service, the included OLE DB compliant provider, is used by Microsoft Excel and applications from other vendors to retrieve data from the server and present it to the user, or create local data cubes for offline analysis.
If you are currently thinking about alternatives to your relational database and are considering OLAP tools, data mining and other multidimensional analysis techniques, then IMGroup can help you. We can offer you advice based on years of expertise in this area, examples of how we have implemented this technology in a wide range of environments and industries, and a thorough understanding of the potential benefits that this technology can provide.