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 thisprocess.
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.)
Answer:
This answer is not correct.
Correct answer is:
1. Import
2. UDM
3. Deploy
4. Modify
Import PowerPivot workbooks to create
SQL Server Analysis Services (SSAS) tabular Projects
Deploy the new SSAS Projects to the Server.
Modify reports to Change data source references
to the new databases.
+1