Integrating KPIs, Cube Analysis, and Reporting

What is Microsoft Business Scorecard Manager?

Business Scorecard Manager is a new, comprehensive scorecard and dashboarding application from the Microsoft Office Group. A valuable component of any business performance management strategy, Business Scorecard Manager delivers the tools needed to communicate the relationships between key performance indicators (KPIs) and strategic business objectives.

Business Scorecard Manager enables organizations to articulate, communicate, and measure business strategy and performance metrics quickly and cost effectively, helping to align action with strategy.

What is Cizer.Net Reporting?

Cizer.Net Reporting is a pure-web application that works with Microsoft SQL Server 2005 to provide Business User Ad Hoc & Production reporting all the way across the enterprise. Behind the scenes, Cizer.Net integrates with Microsoft Business Scorecard Manager to provide a seamless interactive deep dive into the Scorecard data. Permission-based access can be maintained on data, while Cizer.Net’s self-service reporting speeds up the flow of BI throughout your business world.

Cizer.Net Reporting by itself can be used at an enterprise level to provide practical, self-service BI to everyone in your organization. Cizer.Net Reporting combined with Business Scorecard Manager can provide a complete BI Solution – all delivered purely in the browser!

Scorecarding + Analysis + Ad Hoc Reporting

Combining BI Tools in the Portal to give your Business Users real BI powers.

Microsoft’s Business Scorecard Manager can make use of Cizer.Net’s powerful reporting capability. You can now integrate the two products and present them in single Sharepoint portal view for your Business Users.

This interface will allow users to attach Cizer.Net Reports and Queries to Key Performance Indicators (KPIs) in a Scorecard view, displayed through Sharepoint in the form of a webpage.

Joining Scorecarding with Reporting

When the Scorecard is displayed through a Sharepoint website, the Cizer.Net web parts will run as configured in the Builder application.

When a high level objective is clicked the Cizer.Net report is run with the default values.

When a detailed KPI is clicked for the year 2004 and the region Region 04, the year is passed to the report and only the figures for 2004 are returned to the report. This was setup within the Microsoft Scorecard Builder application.

This dynamic implementation will allow users to drill down into each KPI and see a more detailed, more meaningful, integrated report using the Cizer.Net Reporting tool.

Download the full .pdf of the Cizer.Net Reporting - Business Scorecard Manager Solution Sheet here