SQL Server Analysis Services Tabular

E185657
business intelligence platform component in-memory analytical engine tabular data modeling technology

SQL Server Analysis Services Tabular is a Microsoft in-memory analytical engine for building tabular data models that support fast, interactive business intelligence and reporting.

Try in SPARQL Jump to: Surface forms Statements Referenced by

All labels observed (5)

Label Occurrences
SQL Server Analysis Services Tabular canonical 5
Analysis Services Tabular 2
SQL Server Analysis Services 2

Statements (50)

Predicate Object
instanceOf business intelligence platform component ⓘ
in-memory analytical engine ⓘ
tabular data modeling technology ⓘ
alternativeTo Analysis Services Multidimensional ⓘ
surface form: SQL Server Analysis Services Multidimensional
deploymentModel cloud (via Azure Analysis Services and Power BI Premium) ⓘ
on-premises ⓘ
developer Microsoft ⓘ
integratesWith Azure Analysis Services ⓘ
Excel ⓘ
Power BI ⓘ
SQL Server Reporting Services ⓘ
surface form: Reporting Services

SQL Server Data Tools ⓘ
SQL Server Management Studio ⓘ
Visual Studio ⓘ
introducedIn SQL Server ⓘ
surface form: SQL Server 2012
optimizedFor fast query performance ⓘ
in-memory analytics ⓘ
partOf Microsoft BI stack ⓘ
SQL Server ⓘ
surface form: Microsoft SQL Server

SQL Server Analysis Services ⓘ
queryLanguage DAX ⓘ
MDX (limited) ⓘ
storageEngine xVelocity in-memory analytics engine ⓘ
surface form: VertiPaq
supports DAX ⓘ
DirectQuery mode ⓘ
KPIs ⓘ
MDX (limited) ⓘ
xVelocity in-memory analytics engine ⓘ
surface form: VertiPaq storage engine

bi-directional relationships (in some versions) ⓘ
calculated columns ⓘ
columnar storage ⓘ
hierarchies ⓘ
import mode ⓘ
in-memory storage ⓘ
measures ⓘ
partitions ⓘ
perspectives ⓘ
role-based security ⓘ
row-level security ⓘ
tabular data models ⓘ
translations ⓘ
supportsClientTool Power Pivot ⓘ
surface form: Excel PivotTables

Power BI Desktop (Report Server optimized) ⓘ
surface form: Power BI Desktop

Report Builder ⓘ
custom applications via AMO and ADOMD.NET ⓘ
usedFor business intelligence ⓘ
enterprise data models ⓘ
interactive reporting ⓘ
self-service analytics ⓘ
semantic data modeling ⓘ

Referenced by (11)

Full triples — surface form annotated when it differs from this entity's canonical label.

DAX → usedIn → SQL Server Analysis Services Tabular ⓘ
M → usedIn → SQL Server Analysis Services Tabular ⓘ
Power View → uses → SQL Server Analysis Services Tabular ⓘ
this entity surface form: SQL Server Analysis Services Tabular models
Power View → dataSource → SQL Server Analysis Services Tabular ⓘ
this entity surface form: SQL Server Analysis Services
Power Pivot → compatibleWith → SQL Server Analysis Services Tabular ⓘ
Power BI Report Server → integratesWith → SQL Server Analysis Services Tabular ⓘ
this entity surface form: SQL Server Analysis Services
Power BI Gateway → supportsDataSource → SQL Server Analysis Services Tabular ⓘ
this entity surface form: Analysis Services Tabular
Data Analysis Expressions → usedIn → SQL Server Analysis Services Tabular ⓘ
xVelocity in-memory analytics engine → usedBy → SQL Server Analysis Services Tabular ⓘ
this entity surface form: SQL Server Analysis Services Tabular mode
xVelocity in-memory analytics engine → integratedInto → SQL Server Analysis Services Tabular ⓘ
Analysis Services Multidimensional → contrastedWith → SQL Server Analysis Services Tabular ⓘ
this entity surface form: Analysis Services Tabular