Business Intelligence/Distill KPI budgets scorecard

  • Purpose: To develop KPI's, dimensions and budgets for the reports and dashboard
  • Input: Scorecard
  • Activities: Identify and list the KPI's, dimensions and budgets
  • Outputs: List of dimensions, facts and budgets
  • Documentation: Dimensions, facts and budgets


This step begins the transitions from focusing on strategy to focusing on the measures of effective strategy implementation. The assumption going forward is that the causal link map was verified amd the strategy is sound. The next step is to measure leading indicators (KPI's) that indicate success. Again, assuming that X causes Y then we want to determine if the operational activities are achieving Y. This requires extracting the measures objectives, (KPI's), budgets and initiatives from scorecards.

This chapter extracts these items for the reports and dashboard. All these items come from the scorecard. These items become the list of KPI's (measures), budgets and dimensions for the data mart. It is here where we start the transition between focusing on strategy diagrams and building the tools for monitoring operation effectiveness.


Assume that the input for this stage is the following scorecard:

Figure: Transition Scorecard

List of dimensions, facts and budgetsEdit

This is how we extract the dimensions, facts and budgets from the business unit's strategy map. Each business unit leader receives a scorecard, or a slice, from the enterprise strategy map outlining his/her objectives. The leader then determines how to achieve the objectives by creating objectives for his/her subordinates.