O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Developing models in SQL Server Data Tools

The modeling environment in SQL Server Data Tools (SSDT) is almost identical to that of PowerPivot. There is more functionality available; for example, the ability to create partitions and apply security to the model. However, the general approach to modeling in SSDT is identical to PowerPivot. That is, the import of data, its definition (tables and columns), and the creation of relationships and measures are the same.

This recipe demonstrates how models can be developed in SSDT by extending the model imported in the Importing models into SQL Server Data Tools recipe. Here, we add a Geography table to the model to show the sales region that the purchase occurred in. Later on (see the Securing data with ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required