Chapter 15. Optimizing tabular models

A tabular data model can be optimized in different ways, depending on its characteristics and its main goal. In this chapter, you will see a checklist and numerous good practices that are common to any data model. It is important that you understand the concepts explained in Chapter 12, “Inside VertiPaq,” before reading this chapter. After that, there are sections specific to Analysis Services, related to large databases and near–real-time solutions. You will find numerous considerations and suggestions for those particular scenarios. The goal of this chapter is to provide specific information for optimizing data models for Analysis Services. We will consider scenarios that are unlikely to happen by using ...

Get Tabular Modeling in Microsoft SQL Server Analysis Services, Second Edition now with the O’Reilly learning platform.

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