Choosing the model type for business-specific reasons
Now that we have reviewed many of the technical differences between the models, let's look at how specific business needs may influence your decision. This section of the chapter is a blend of business needs and technical fit. We will wrap this section up with a combined matrix to help you determine the best fit for your business and technical leads.
Rapid development and change
Businesses change often and quickly. As they change, reporting and analytic needs change as well. The amount and the frequency of the change directly impact which solution is a better fit. Tabular models are by far the better option to support frequent changes. They are simpler to construct and more flexible to supporting change.
The primary factors for this recommendation include the ability to retrieve and shape data using Power Query. This allows developers to change and include data from more sources in the model. Multidimensional models...