Exam 70-467 topic 1 question 22 discussion

DRAG DROP -
You are designing a self-service business intelligence and reporting environment.
Business analysts will create and publish PowerPivot for Microsoft Excel workbooks and create reports by using SQL Server Reporting Services (SSRS) and
Power View. When the data models become more complex and the data volume increases, the data models will be replaced by IT-hosted server-based models.
You have the following requirements:
✑ Maintain the self-service nature of the reporting environment.
✑ Reuse existing reports.
✑ Add calculated columns to the data models.
You need to create a strategy for implementing this process.
What should you do?
To answer, drag the appropriate term or terms to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)
Select and Place:

Suggested Answer:
Box 1: Import -

Box 2: tabular -

Box 3: Deploy -

Box 4: Modify -
You can see that the audiences for these two approaches are different: Tabular models are for IT professionals, while PowerPivot models are for business users.
And keep in mind you can import a PowerPivot workbook to create a new tabular product. For example, a business user might create a solution using
PowerPivot. By restoring the workbook, IT can add features that are not supported in PowerPivot, such as roles to grant read permission to different groups of users. Additionally, recognition by IT that the model is important to the organization may prompt them to import the workbook into a tabular project and take ongoing responsibility for developing the model.