SQL Server Analysis Services Tabular

E185657

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.

All labels observed (6)

How this entity was disambiguated

Statements (50)

Predicate Object
instanceOf business intelligence platform component ⓘ
in-memory analytical engine ⓘ
tabular data modeling technology ⓘ
alternativeTo 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 ⓘ
Reporting Services ⓘ
SQL Server Data Tools ⓘ
SQL Server Management Studio ⓘ
Visual Studio ⓘ
introducedIn SQL Server 2012 ⓘ
linked to: SQL Server
optimizedFor fast query performance ⓘ
in-memory analytics ⓘ
partOf Microsoft BI stack ⓘ
Microsoft SQL Server ⓘ
linked to: SQL Server

SQL Server Analysis Services ⓘ
queryLanguage DAX ⓘ
MDX (limited) ⓘ
storageEngine VertiPaq ⓘ
supports DAX ⓘ
DirectQuery mode ⓘ
KPIs ⓘ
MDX (limited) ⓘ
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 Excel PivotTables ⓘ
linked to: Power Pivot

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 ⓘ

How these facts were elicited

Referenced by (14)

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 models ⓘ
linked to: SQL Server Analysis Services Tabular
Power View → dataSource → SQL Server Analysis Services ⓘ
linked to: SQL Server Analysis Services Tabular
Power Pivot → compatibleWith → SQL Server Analysis Services Tabular ⓘ
Power BI Report Server → integratesWith → SQL Server Analysis Services ⓘ
linked to: SQL Server Analysis Services Tabular
Power BI Gateway → supportsDataSource → Analysis Services Tabular ⓘ
linked to: SQL Server Analysis Services Tabular
Data Analysis Expressions → usedIn → SQL Server Analysis Services Tabular ⓘ
xVelocity in-memory analytics engine → usedBy → SQL Server Analysis Services Tabular mode ⓘ
linked to: SQL Server Analysis Services Tabular
xVelocity in-memory analytics engine → integratedInto → SQL Server Analysis Services Tabular ⓘ
Analysis Services Multidimensional → contrastedWith → Analysis Services Tabular ⓘ
linked to: SQL Server Analysis Services Tabular
Tabular Editor → supportsPlatform → SQL Server Analysis Services Tabular ⓘ
Power BI paginated reports (via connections) → supportsConnectionTo → Analysis Services models ⓘ
linked to: SQL Server Analysis Services Tabular
xVelocity → usedIn → SQL Server Analysis Services Tabular mode ⓘ
linked to: SQL Server Analysis Services Tabular