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 Disambiguation Statements Elicitation Referenced by

All labels observed (5)

Label	Occurrences
SQL Server Analysis Services Tabular canonical	5
Analysis Services Tabular	2
SQL Server Analysis Services	2
SQL Server Analysis Services Tabular mode	1
SQL Server Analysis Services Tabular models	1

How this entity was disambiguated

This entity first appeared as the object of triple T1647553 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.

NED1 Entity disambiguation (via context triple) gpt-5-mini-2025-08-07

Target entity: SQL Server Analysis Services Tabular
Context triple: [DAX, usedIn, SQL Server Analysis Services Tabular]

A. Power Pivot
Power Pivot is an Excel data modeling and analysis add-in that enables users to create sophisticated data models, relationships, and DAX calculations for business intelligence reporting.
B. Power BI
Power BI is a Microsoft business analytics and data visualization platform used to transform, analyze, and present data through interactive dashboards and reports.
C. SQL Server Reporting Services
SQL Server Reporting Services is a server-based platform from Microsoft for designing, managing, and delivering paginated and interactive reports from relational and multidimensional data sources.
D. SQL Server Integration Services
SQL Server Integration Services is a Microsoft ETL and data integration platform used to extract, transform, and load data between diverse sources within the SQL Server ecosystem.
E. SQL Server Data Tools
SQL Server Data Tools is an integrated development environment within Visual Studio for designing, developing, debugging, and deploying SQL Server and Azure SQL databases and related business intelligence solutions.
F. None of above. chosen
G. Unsure - the case is ambiguous/there is not enough information to decide.

NED2 Entity disambiguation (via description) gpt-5-mini-2025-08-07

Target entity: SQL Server Analysis Services Tabular
Target entity description: 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.

A. Power Pivot
Power Pivot is an Excel data modeling and analysis add-in that enables users to create sophisticated data models, relationships, and DAX calculations for business intelligence reporting.
B. Power BI
Power BI is a Microsoft business analytics and data visualization platform used to transform, analyze, and present data through interactive dashboards and reports.
C. SQL Server Reporting Services
SQL Server Reporting Services is a server-based platform from Microsoft for designing, managing, and delivering paginated and interactive reports from relational and multidimensional data sources.
D. SQL Server Integration Services
SQL Server Integration Services is a Microsoft ETL and data integration platform used to extract, transform, and load data between diverse sources within the SQL Server ecosystem.
E. SQL Server Data Tools
SQL Server Data Tools is an integrated development environment within Visual Studio for designing, developing, debugging, and deploying SQL Server and Azure SQL databases and related business intelligence solutions.
F. None of above. chosen

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 ⓘ

How these facts were elicited

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 ⓘ