You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to develop a report that will use data obtained from a SQL Server 2008 Analysis Services (SSAS) instance. The solution has many key performance indicators (KPIs). You need to ensure that users can perform the following tasks in the minimum amount of time and by using the minimum amount of development effort:
-Browse through the report offline.
-View the KPIs that they want to see.
Which tool should you use?
A.
Report Builder
B.
Microsoft Excel 2007
C.
SQL Server 2008 Reporting Services (SSRS)
D.
a custom Microsoft ASP.NET application that has the ReportViewer control
Explanation:
Tip: "amount of time … development effort" = "Excel"Could be chieved by other means, but only answer B – Microsoft Excel 2007 satisfies condition "minimum amount of development effort".