You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to design a report that uses data obtained from a SQL Server 2008 Analysis Services (SSAS) instance.
The SSAS cube contains five parentchild key performance indicators (KPIs). Each KPI has nine children.
You need to create an executive dashboard in Microsoft Office SharePoint Server (MOSS) that displays the KPIs and depicts the parentchild relationship.
Which technology should you use?
A.
Microsoft Office Excel
B.
MOSS KPI Library
C.
MOSS Business Data Catalog
D.
Microsoft Office PerformancePoint Server
Explanation:
Tip: "dashboard in Microsoft Office SharePoint Server" = "PerformancePoint"http://office.microsoft.com/en-us/performancepoint-server/
PerformancePoint Server 2007
A complete business intelligence and performance management solution. Use PerformancePoint Server to plan, report, monitor, and analyze your organizations performance.http://office.microsoft.com/en-us/dashboard-designer-help/getting-started-performancepoint-dashboard-designer-HA100800792.aspx
PerformancePoint Dashboard Designer is a tool that you can use to create dashboards, scorecards, and reports and publish them to a SharePoint site.
Dashboard Designer helps you build a dashboard that contains a single, consistent, and visible view of your business. You can use this tool to provide business intelligence (BI) to the people in your organization so that they can make informed business decisions. By using Dashboard Designer, you can create reports and scorecards that display important metrics and key performance indicators (KPIs) that will help you measure and track performance in your organization.