Microsoft SQL Server Analysis Services (SSAS) is part of Microsoft SQL Server, which is a relational database management system (RDBMS). SSAS contains online analytical processing (OLAP) and data mining functionality for business intelligence applications. Many of the business intelligence and data mining functions within SSAS are applicable to environmental datasets. Mining historical data using SSAS can provide new insights and form a basis for forecasting, and may be particularly interesting for analysis of environmental time series data.
SSAS supports OLAP by assisting you in designing, creating, and managing multidimensional structures that contain data aggregated from other sources, such as relational databases. OLAP data cubes constructed using SSAS can be accessed using Microsoft Excel, which can be a powerful way to present data to potential users. In data mining applications, SSAS can assist you in designing, creating, and visualizing data mining models that are constructed from data sources using a wide variety of industry-standard data mining algorithms.