02 Jun 2012 --- Analyst drawing out strategy on glass wall. --- Image by © Hero/CorbisNo doubt you have thoroughly thought out your business intelligence (BI) strategy and have it available …. on ONE slide! Your strategy to execution, business needs, governance model, BI objectives and needs, information categories, components and architecture, sponsorships, measurement, training, support, and metadata management … they all fit on your magical one-slide. Let me smile.

BI Strategy to Execution

This blog is not an argument about the importance of a solid BI Strategy; there has been plenty written about that. Its about how you can create one in a few clearly outlined steps that can guide you to a rock solid base for your BI Strategy with limited investment in time and effort. I am speaking of days; not weeks or months!

Let’s start your BI Strategy Foundation here, based on four simple steps I have applied many times with customers.

  1. Current BI Needs Baseline AnalysisBI Strategy Foundation
  2. BI Strategy and Execution Baseline
  3. Gap Analysis
  4. Compose BI Strategy Foundation


1.    Current BI Needs Baseline Analysis

The objective of step one is to create high-level insight of the business intelligence needs by line of business (LOB), and the expected impact on the company’s performance management. To gather the required information, I interview representative decision takers by LOB (i.e. HR, finance, sales, purchasing) discussing what they need to optimize their LOB’s performance. After the interviews, I create an overview with:

  • Business challenge and degree of priority/pain (scale of 0-10)
  • Business impact and degree of impact (scale of 0-10)

Example sales LOB:


There are typically 10-20 business challenges and business impact statements per LoB. I use a simple spreadsheet to log the challenges and impacts together with their individual scores. Visualization tools, like SAP Lumira, easily allow me to share detailed insights with my customers on their BI needs baseline. If you, for example, use a scatter-chart with degree of pain versus degree of impact, one can easily spot the key domains that require focus.

2.    BI Strategy and Execution Baseline

Next I assess the customer’s existing business intelligence strategy, components definition, completeness of execution, and business impact. The BI Strategy and Execution Baseline includes five strategy components, each of which is examined for three areas —existence, execution and impact:

a) Objectives: Describes the extent to which the history, key reasons, and objectives for the BI Strategy have been documented and to what extent the objectives have been executed. Degree of documentation definition is rated on a scale of 0-10.

b) BI Needs: Describes the extent to which the business needs and the future state have been defined and executed, in terms of the business requirements and corresponding KPIs. Degree of KPI definitions rated on a scale of 0-10.

c) Business Case: Describes the extent to which the benefits of implement­ing the BI strategy have been articulated and quantified. Degree of articulation is rated on a scale of 0-10.

d) Information and Technology: Addresses the types of information that has been, and/or will be captured, and the technology that is or will be put in place to meet the BI needs. One of the methods I use is the BI Component selection tool.

e) Organization and Implementation: Describes to what extent the organization is ready to implement the BI Strategy and is on track to execute. Degree of execution readiness is rated on a scale of 0-10.

Step two requires a bit more effort than step one. My experience is to allocate 2-3 days to get a fair insight. Again, I log everything using a spreadsheet with the above mentioned domains each rated.

BI Strategy execution baseRemember that we are creating a foundation for a BI strategy, and not a detailed strategy execution plan. Detailed strategy plans require steps 2b, 2d and 2e to be further explored. Our foundation is the perfect framework to do so.

Note that I keep the registration of the above steps simple and with a single rating degree of 0-10 for each existence, execution and impact. If properly done, one can very easily generate a visualized insight of the execution baseline like a radar chart with the three metrics.


3.    Gap Analysis

You’ve probably already guessed that the gap analysis in this third step is basically the delta between the two first steps. The objective is to prioritize the gaps, and document the benefits of addressing them. The gap analysis prioritizes the insights giving the customer a clear understanding of where to focus their BI efforts. It also provides an understanding of the value of addressing unmet business needs, which is crucial input to the custom­er’s investment decisions. Here are additional questions the gap analysis answers for my customer:

  • Which gaps will drive the biggest benefit for our enterprise?
  • What BI needs are causing the most disruption – and the highest business pain for decision makers?
  • How can or should identified gaps be prioritized for the maximum enterprise impact?

Again I use a very simple spreadsheet to document the individual gaps and their scores. For the score I reuse the degrees from the previous steps. Below is a version of the outputs with a bit more detail.

BI Stratgey Gap

4.    Compose Your BI Strategy Foundation

For the last step I create a recommended capabilities map to resolve the business pains from step one. I use the outcome of the previous three steps and visualize them in clearly digestible overviews and infographics. Basically I leverage them to for:

  • Strategy recommendations
  • Descriptions of the solution and value of closing the gaps caused by the pains/needs.
  • BI category and solution description – what are the business intelligence solutions required for addressing this pain?

If you have rated your degrees consistently, radar and scatter maps will clearly indicate where the most important needs are, what the current and future capabilities to address those needs are, and – as a result – what the prioritized gaps are.

The above approach works very well for me, and especially my customers. Having used it now for several occasions here are some key take-aways:

  • Easy to use, especially a consistent use of rating the degrees helps to visualize the customer’s situation
  • Results in actionable insights immediately with the prioritized gap analysis
  • Takes reasonable time efforts – most of the time I completed the full exercise in less than five days
  • Can be used iteratively: one can easily apply this approach at the departmental level and later enlarge the scope to cross-department or corporate level

If you need to take your BI strategy one step further, SAP is well suited to help using our strategy management assistance. All detail can be found via this link.

Follow me on Twitter – @IvervandeZand