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	SQL Server Analysis Services Multidimensional ⓘ linked to: 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 ⓘ linked to: SQL Server 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 ⓘ linked to: xVelocity in-memory analytics engine
supports	DAX ⓘ DirectQuery mode ⓘ KPIs ⓘ MDX (limited) ⓘ VertiPaq storage engine ⓘ linked to: xVelocity in-memory analytics 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 ⓘ linked to: Power BI Desktop (Report Server optimized) 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 models ⓘ