Chapter 7: Building a Tabular Model in SSAS 2019
In the previous chapter, we looked at the various ways in which data can be prepped and used with tabular models. This chapter focuses on using that data to build out tabular models that we can use for analysis. When you have completed the work in this chapter, you will be able to build tabular models from various types of data sources.
In this chapter, we will build out four tabular models to demonstrate building from the data warehouse and also from the transactional database source. We will also create a DirectQuery version of the data warehouse model. We will wrap up model creation by importing the Power Pivot model we created in the previous chapter.
Apart from this, we will create a solution that supports multiple models or projects. Like with the multidimensional model build, we will pull in the data, create tables, set relationships, and add some custom columns and hierarchies. This will result in the completion of basic...
