Analysis Services is a data engine used in decision support and business intelligence (BI) solutions, providing analytical data used in reports and client applications such as Excel, Reporting Services reports, and other third-party BI tools.
Use Analysis Services to create high-performance query structures, business logic, and KPIs within a multi-purpose data model that can be accessed by any client application supporting Analysis Services as a data source.
To create a model, use SQL Server Data Tools, choosing either a Tabular or Multidimensional and Data Mining project template. Models are populated with data from external data systems, usually data warehouses hosted on a SQL Server or Oracle relational database engine (Tabular models support additional data source types).
To use a model, it's deployed to an Analysis Services instance that runs databases in a particular server mode, making the data available to authorized users who connect through Excel or other applications.
You can install an Analysis Services instance in one of three server modes:
As a Tabular instance, running Tabular models.
As a Multidimensional and Data Mining instance, running OLAP cubes and data mining models (this is the default).
As PowerPivot for SharePoint, running PowerPivot and Excel data models in SharePoint (PowerPivot for SharePoint is a middle-tier data engine that loads, queries, and refreshes data models hosted in SharePoint).
Same data engine; three different ways to use it. Note that server modes are set during installation and cannot be changed later. You should install a new instance if you require a different mode.
Foundational documentation for Analysis Services is organized into sections that correspond to the type of project you are building. Choose from the following links to learn more about each mode or feature area.