Optimizing and managing a model's design
As the designer of a Tabular Model, your experience is affected by different factors than those of the consumers of the solution you deploy.
Managing memory usage
A common issue that users encounter with the Power Pivot add-in for Excel occurs when a large volume of data is imported that uses all the available memory resources on the local computer. This is especially true when running a 32-bit operating system or Office edition with restricted memory resources. The logical path for many of these solutions is to migrate the desktop Power Pivot model to a Tabular Model that runs on a well-equipped server.
The xVelocity In-Memory Analytics Engine is designed to utilize memory, rather than disk I/O, to provide improved performance when compared to more conventional technologies. Since models reside entirely in memory, the way we think about providing and managing resources must be fundamentally different than it would be for managing relational databases...
