Chapter 2: Choosing the SQL Server 2019 Analytic Model for Your BI Needs
Before we jump into detailed hands-on work with both types of models in SQL Server Analysis Services (SSAS) 2019, we'll look at some of the key differences in the products. This chapter will refer to specific examples later in the book to point to more specific details. The goal of this chapter is to help you understand that the models are different, but both – multidimensional and tabular – are still valuable and can have a place in the solutions you create.
In this chapter, we will walk through a short recap of how we got to two models in SSAS. Then, we will dig into the key strengths and weaknesses of the models. Besides the strengths and weaknesses, there are other ...
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.
