You design a Business Intelligence (BI) solution by using SQL Server 2008. You have a SQL Server 2008 Analysis Services (SSAS) cube. Some users only use Microsoft Excel 2007.
Some users only use Microsoft ProClarity.
You plan to add new key performance indicators (KPIs). You need to ensure that the KPIs meet the following requirements:
-Provide all users access to the new KPIs.
-Minimize future maintenance.
What should you do?
A.
Create the KPIs in ProClarity.
B.
Create the KPIs in the Excel spreadsheets.
C.
Create the KPIs in the SSAS cube.
D.
Create SQL Server 2008 Reporting Services (SSRS) reports that contain the expected KPIs.
Explanation:
Tip: "all users access … Minimize future maintenance" = "SSAS"Microsoft PerformancePoint Server
PerformancePoint Server allows you to quickly create a centralized Web site with all of your companys performance metrics. The environment is designed to allow business analysts to create sophisticated dashboards that are hosted in a SharePoint environment. These dashboards can contain SSRS reports and visualizations of data from OLAP cubes as well as other data sources. It also has a strong set of products that support business forecasting. PerformancePoint Server includes the functionality of the Business Scorecard Manager
and ProClarity Analytics Server. Its purpose is to facilitate the design and hosting of enterprise-level scorecards via rich data-visualization options such as charts and reports available in Reporting Services, Excel, and Visio. PerformancePoint Server also includes some custom visualizers, such as the Strategy Map.
Note We are sometimes asked what happened to ProClarity, a company that had provided a specialized client for OLAP cubes. Its target customer was the business analyst. Microsoft acquired ProClarity in 2006 and has folded features of its products into PerformancePoint Server
(Smart Business Intelligence Solutions with Microsoft SQL Server 2008, Copyright 2009 by Kevin Goff and Lynn Langit)