Chapter 3. Tabular Model Development of SQL Server Analysis Services
SQL Server Analysis Services comes with two modeling technologies: multidimensional and tabular. In the previous chapter, you learned how to model a multidimensional OLAP cube. In this chapter, you will learn about tabular modeling.
SSAS Tabular loads data into an In-Memory engine called xVelocity (previously known as Aka Vertipaq). The In-Memory engine provides high-speed access to data, which helps provide very fast reports and dashboards. Tabular modeling allows you to create a table-based model from existing data (that comes from a data warehouse or any other source) and create a relationship between models. Note that the tabular model doesn't require a start schema relation, ...
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.
