Creating a tabular model

In order to create tabular data models, you need a SQL Server Analysis Services server installed to support Tabular Data Model (TDM) because a default installation can only work with multidimensional models (which work with much larger datasets).

For the purposes of this book, the SQL Server 2012 server NJ—a named instance—has been installed to support TDM. In this section, we are only describing what steps are needed to create the model and deploy it to an analysis server suitable for creating Power View reports.

In the following exercise we create a tabular model using SQL Server Analysis Services with SQL Server Data Tools.

Hands-on exercise 6.1 – creating a tabular model

This can be created using SQL Server Data Tools(SSDT). ...

Get Learning SQL Server Reporting Services 2012 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.