Reading Time: 5 minutes

How to avoid being associated with a project that turns into a quagmire

Yogi SchulzThe novelty has worn off Business Intelligence (BI) as it expanded over the years into many organizations. BI is no longer some Skunk Works adventure that runs independently of the formal organization with little or no oversight beyond nominal executive-level sponsorship.

BI projects are now subject to more traditional governance processes, including formal approval of a credible business case and ongoing supervision by the Project Management Office.

Background

Interest in BI has grown, even exploded in some organizations, and matured almost everywhere because:

  1. BI has produced irrefutable business value.
  2. BI opportunities have grown sharply as more and more organizations have become increasingly digital, often through a digital business strategy.
  3. Organizations now recognize BI as the critical technology for creating business value from big data.
  4. The cost to develop BI applications has decreased significantly as:
    1. Software development tools have become more powerful, cheaper, and easier to use.
    2. Data integration processes have become much more straightforward.
    3. The cost of computing resources has decreased.
  5. Data is recognized as a strategic asset, with BI revealing that value.
  6. Organizations are paying more attention to improving data quality, a prerequisite to BI success.
Business-intelligence-data-analytics
Related Stories
Tech startup changing the way we enjoy sporting events


How to avoid Enterprise Resource Planning implementation gotchas


How to get ready for the Internet of Things

Avoid a losing Business Intelligence business case

What are the consequences of loser BI business cases, and how do we avoid them? How do you avoid becoming:

  1. Tangled up by uninformed challenges to the business case?
  2. Pushed to accept enormous scope that can only lead to failure?
  3. Consumed by low-value internal hoop-jumping review and approval processes?
  4. Obligated to create mushy estimates for unknowable tasks?
  5. Frustrated when the business value you want to deliver is being hindered?
  6. Challenged to estimate business benefits with more accuracy than is feasible?

I’ll describe a series of loser business case strategies you must avoid at all costs because your BI project will crash and burn. For each dysfunctional approach, I describe a more successful alternative approach that can win approval for your BI project and help you move forward in delivering business benefits.

Avoid an intense Business Intelligence business case

Because you really don’t know the project scope and issues you are likely to face at this early stage, avoid an extreme BI business case that is many pages long and contains:

  1. A detailed BI project plan with a considerable number of tasks that also claims to estimate effort and schedule for that plan in even more detail.
  2. Detailed BI project costs to a narrow range between upper and lower estimated costs.
  3. Tangible benefits estimated in considerable detail.
  4. A lengthy list of assumptions.
  5. A comprehensive list of risks with mitigations.

Not only does all this planning and BI business case writing consume a lot of effort, but these early numbers will also be wildly different from the eventual project reality. Worse, this detail is not likely to increase your success in achieving funding approval because stakeholders will challenge, or at least pick at, the benefits and the estimates.

Instead, develop a modest project description. By modest, I mean a two-page project description for a BI prototype that consists of the following:

  1. A brief description of an innovative BI application idea.
  2. A business case consisting of:
    1. A conservative tangible benefit estimate of three to five lines with a lower and higher range.
    2. A reasonable, but not high, cost estimate of five to eight lines with a lower and higher range.
  3. A reasonable intangible benefit list of two to three lines.
  4. A list of BI prototypes and data warehouse

For example, department managers keep expressing their frustrations about poorly completed orders that are difficult to fill accurately and are triggering a high return rate. You recognize that multiple improvements are likely required. You want to start by creating a series of BI queries to better understand the scope and magnitude of the problems. You draft a modest business case to pitch to the department managers.

A modest project description is often a successful approach for selling your departmental BI project because:

  1. The cost is within a manager’s approval limit.
  2. Success will provide valuable insights into describing a larger follow-on project.
  3. There are no consequences associated with failure.
  4. Failure can often be spun as a helpful

Avoid an implausible Business Intelligence business case

Avoid the temptation to develop an astounding business case, even if you believe it, because stakeholders will receive that as an implausible BI business case.

Worse, an implausible BI business case ratchets the organization’s expectations so high that your BI project risks being judged a failure even if you deliver substantial business benefits.

Instead, a winning strategy is developing a project charter with a business case. A simple project charter consists of the following:

  1. The description of the business opportunity that you see.
  2. An outline of your proposed approach to executing the BI project.
  3. A rough project plan.
  4. A summary business case.
  5. An initial project budget.
  6. The project organization, including the members of a steering committee.
  7. An initial risk list with some proposed mitigation strategies.

For example, a vice president sees an opportunity to dramatically expand the territory in which the company sells and services construction equipment. However, it isn’t easy to model what the opportunity might produce in terms of sales and net income. Similarly, it will be challenging to forecast capital investment and operating expenses. You realize that creating a reasonable expansion plan will require significant amounts of external data that your company has never gathered and integrated before. You draft a project charter to describe to the vice president what will be required to model the expansion idea in more detail.

Socializing a project charter is often a successful strategy for achieving a consensus on the direction to take when proposing a more significant BI application that spans the data sources of multiple departments. In this situation, a stakeholder consensus is often a prerequisite to funding approval.

Avoid a hefty enterprise-wide Business Intelligence business case

In all cases, avoid a strategy that calls for a BI mega-project and lays out a hefty supporting enterprise-wide BI business case. BI is better implemented or enhanced through a series of modest, focused projects that successively deliver additional tangible business benefits.

For example, a senior executive sees a significant opportunity to dramatically expand the use of BI across the continent to:

  1. Improve many aspects of business performance.
  2. Make performance measures easily accessible to most employees.
  3. Encourage a significant increase in the adoption of BI technology for informal self-serve applications.
  4. Upgrade data quality and integration significantly to support performance measures and data accessibility.

The contemplated BI project will address a wide range of BI topics, including:

  1. A better understanding of sales patterns.
  2. Sources of quality lapses.
  3. Trends in customer service engagement.
  4. Causes of product returns.
  5. Analysis of product defect and scrap rates.
  6. Financial performance variances.
  7. Competitor market share and performance comparisons.

Such a major enterprise-wide BI project faces enormous people change management hurdles, complex data integration challenges and too many inter-departmental non-co-operation issues to succeed.

Even if an executive is prepared to fund and sponsor such a major enterprise-wide BI rollout, this ambitious moon-shot project is more likely to turn into a quagmire you don’t want to be associated with.

Instead, channel this executive enthusiasm toward a more modest Business Intelligence project focused on the most promising part of the enterprise-wide aspirations that apply to a single department that a supportive executive also leads. With executive backing, you can develop a project charter with a winning BI business case.

Yogi Schulz has over 40 years of information technology experience in various industries. Yogi works extensively in the petroleum industry. He manages projects that arise from changes in business requirements, the need to leverage technology opportunities, and mergers. His specialties include IT strategy, web strategy and project management.

For interview requests, click here.


The opinions expressed by our columnists and contributors are theirs alone and do not inherently or expressly reflect the views of our publication.

© Troy Media
Troy Media is an editorial content provider to media outlets and its own hosted community news outlets across Canada.