Creating a Tabular Model

In this recipe, we will walk through creating a Tabular Model database project using SSDT. As you begin working with Tabular Models, you will see that some of the complexities in setting up a good multidimensional model do not apply. While working with multidimensional models, you typically need all of the data organized and ready for consumption by Analysis Services. However, Tabular Models are much more forgiving. The key design requirement to take into consideration is: What data does the business need? As a result, we will create a model database here and work through model modifications in the following recipes.

Getting ready

Before you create your first Tabular Model database, you must have an installation of Analysis Services with a Tabular Model instance available to you. This can be a local installation or a network installation. This is required because a Tabular Model database is developed in real time using the xVelocity In-Memory Analytics Engine and RAM...