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 ...

Get Hands-On SQL Server 2019 Analysis Services 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.