When an Excel user creates a PowerPivot model, they have the luxury of managing all the data from within PowerPivot. They can update table data when needed in an ad hoc manner as they see fit.
However, the same situation is not true for enterprise models—tabular models that are deployed to an SQL Server Analysis Server (SSAS) server. Here, there is an expectation from all users that data is updated and refreshed according to an agreed schedule. Further, there are often restrictions on developers that limit the activity they can perform on production servers.
This chapter examines how models are managed against SSAS servers and includes deployment methods, management, and processing.