Summary

SSAS Tabular provides another analytical modeling tool that has a high performance using the xVelocity In-Memory column store engine. This tool is very easy to use rather than multidimensional. However, tabular is in its early stages in comparison with multidimensional that was released in 2000 for the first time. This tool still has room for improvement, but it is good for real-world projects; it will provide higher performance and faster development in BI projects. To be a professional with this tool, your first step is to be a professional in DAX, which is the query language for tabular modeling.

Chapter 2, SQL Server Analysis Services Multidimensional Cube Development and this chapter was about data modeling. The next chapter will ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.