Services, Engines and models in an Analysis Service context … how is all that related? Terms are often used generally, inconsistently, interchanged or mixed up, which quickly makes the whole subject opaque and confusing. Therefore it’s worth to start at the top of the pyramid, drill down and discover Analysis Service & Tabular.
To realize the full potential of Analysis Services and its backbone, the Tabular Engine, it is important to understand the intricacies. This article serves as an introduction to the world of tabular modeling within Microsoft Analysis Service.
First look at the big picture
What is Analysis Service? From a technical standpoint, Microsoft Analysis Services is a analytical engine that facilitates the creation and management of OLAP (Online Analytical Processing) and data mining models. It supports both multidimensional and tabular models, allowing developers to design complex structures for data analysis. With capabilities such as data aggregation, calculation engines, and support for MDX (Multidimensional Expressions) and DAX (Data Analysis Expressions) languages, it provides a robust platform for building scalable and efficient business intelligence solutions within the Microsoft ecosystem.
What is the „Tabular Engine“? The term „Tabular Engine“ in the context of Microsoft Analysis Services refers to the underlying processing engine responsible for managing and executing queries against Tabular models. While the Tabular model itself represents the structure and relationships of the data organized in tables, the Tabular Engine is the component responsible for processing and optimizing these models to deliver fast and efficient analytical queries.
The name „Tabular Engine“ emphasizes its role as the powerhouse that handles data retrieval, aggregations, and calculations within the Tabular model. This engine employs sophisticated algorithms for compression and storage, and it excels in handling large datasets in-memory, resulting in quicker response times for analytical queries. Essentially, the Tabular Engine is the runtime environment that brings the Tabular model to life, making it a fitting name that reflects its core function in the broader Microsoft Analysis Services architecture.
In contrast, the Multidimensional Engine handles queries against Multidimensional models.
Conclusion
If you’re creating a Tabular Model in Analysis Service, you’re using the Tabular Engine within Analysis Service.
