SQL Server Reporting Services (SSRS)
SQL Server Reporting Services (SSRS) is server-based reporting software developed by Microsoft and used as a solution for companies that need to generate customized reports from a variety of data sources, such as SQL databases and other external sources.
They give administrators the ability to prepare and deliver various reports (interactive and printed) to users according to access permissions and user groups.
With SQL Server Reporting Services (SSRS), companies have a unified solution for report design and data warehousing.
SSRS can help you create tabular, graphical and free-form reports from relational, multidimensional and XML data sources.
Reports can also be published and accessed on demand.
SSRS also has an integrated scheduling tool for deploying basic reports via e-mail, file sharing or SharePoint.
Microsoft SQL Server Analysis Services (SSAS)
Microsoft SQL Server Analysis Services is a tool for online analytical processing (OLAP) and data mining in Microsoft SQL Server.
SSAS is used by companies to transform and analyze information that may be spread across multiple databases, tables or disparate files.
Many of the business intelligence and data mining functions within SSAS apply to environmental datasets.
Mining historical data with SSAS can provide new information and a basis for forecasting, and is particularly interesting for the analysis of time-series data.
Data built in cube form using SSAS can be accessed using Microsoft Excel, an efficient way of presenting your data to potential users.
In data mining applications, SSAS can help you design, create and visualize data mining models using a wide variety of algorithms.