Chapter 20. SQL Server Analysis Services (SSAS)

SQL Server Analysis Services (SSAS) provides online analytical processing (OLAP) and data mining functionality using a combination of client- and server-side components.

A data warehouse is a data repository used to overcome issues arising from performing strategic analysis on data in an online transaction processing (OLTP) database. An OLTP database supports the day-to-day business activity of the organization and is configured to let applications write data for a single transaction as quickly as possible. A data warehouse provides users easy access to information used to make strategic business decisions.