Wednesday, 13 February 2013

Scalable Platform | MSBI Tutorial pdf

Scalable Platform

Tight integration with other Microsoft programs makes Business Scorecard Manager both extendable and customizable. End user resources such as Office SharePoint Server 2007 and Excel Services enable browser-based access for loading, calculating, rendering, and interacting with Excel spreadsheets on servers. A complete and fully integrated BI platform including integrated reporting, analysis, and database services in SQL Server 2005 supports all facets of decision-making.

Web-Based Development and Administration
Business Scorecard Manager comes with Web-enabled capabilities that provide you with authorized access to scorecards through the Internet, giving you quick access to analysis functionality for filtering, sorting, and ranking. Microsoft provides two Web Parts for Business Scorecard Manager: Office Scorecard View Web Part and Office Report View Web Part. Both components can be added to a page on a SharePoint site. You can also create your own Web Parts that integrate with Business Scorecard Manager. This functionality can be used to incorporate your own charting controls or a third-party analysis tool.

Integration with SQL Server 2005 Analysis Services
Business Scorecard Manager integrates with SQL Server 2005 Analysis Services (SSAS), enabling you to use an Analysis Services OLAP database as the source for your scorecard KPIs and benchmark data. Data source modules help you map scorecard definitions to the SSAS cube that you’re using as your source. The server uses the metadata to link to data sources, as well as to determine how scorecards are to be rendered on a SharePoint site.

Integration with Office SharePoint Server 2007
By integrating Business Scorecard Manager with an Office SharePoint Server 2007–based Web site, scorecard KPIs can be displayed in SharePoint sites using specific scorecard Web Parts. While scorecards tend to be highly summarized, the SharePoint Scorecard Web Parts are interactive so you can filter the views or drill down to see different levels of scorecard detail. Advanced collaboration features in Office SharePoint Server 2007 such as document sharing, live chat, and links to subject matter expert sites help make it easier for managers to establish chains of responsibility based on their strategy map.
To maintain security, organizations can provide authorized access to scorecard projects through the Internet.

No comments: