SQL Server - SQL Server Analysis Services (OLAP)

About

Data Mining and OLAP cube.

Powerpivot: Excel engine for cube connection/client ?

Tool

Builder

To develop cubes, you use:

SQL Server Data Tools

Front-end

Microsoft Office
Microsoft SharePoint

Service

SSAS is a service that host multidimensional databases.

These databases contain:

the data sources,
data source views,
dimensions,
measures,
and cubes

Installation

Multidimensional analysis is supported in SQL Server Standard, Business Intelligence, Enterprise, Developer, or Evaluation edition

Excel

Cubevalue function