SQL Server - SQL Server Analysis Services (OLAP)

1 - About

Data Mining and OLAP cube.

Powerpivot: Excel engine for cube connection/client ?

2 - Tool

2.1 - Builder

To develop cubes, you use:

  • SQL Server Data Tools

2.2 - Front-end

  • Microsoft Office
  • Microsoft SharePoint

3 - Service

SSAS is a service that host multidimensional databases.

These databases contain:

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

4 - Installation

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

5 - Excel

Cubevalue function


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap