Trends in BI:  Baseline Survey 2007

QuickRead:  Exploring Four Survey Questions with Fernando Martinez-Campos

Baseline Consulting conducted a written survey of its audience at a TDWI (The Data Warehouse Institute) event in May 2007.  The Q&A below highlights some interesting responses about the maturity of business intelligence (BI) today.   To view the entire survey results and an executive summary comparing year-over-year BI Trends, you can read our Executive Summary.

Fernando

 

Q.

Only 22% of survey respondents grade their company’s BI program as mature or established.  That means 78% of us could use some improvement!  What does Baseline consider to be the top three attributes of a mature BI program?

 

A.

Several factors determine BI maturity, but ultimate success boils down to the degree of sophistication with which a company is able to leverage analytics to effectively make decisions and take action to run the business.  While BI maturity varies from industry to industry, and even department to department within a company, Baseline calls out three key attributes of a mature BI program:

  • The data warehouse contains all relevant data—as determined through bona fide business requirements gathering—to meet users’ metrics for timeliness, usefulness, quality, and relevance to the business question at hand.  However, it’s not just about replicating volumes of detailed data.  In a mature BI environment, the data is modeled, managed, and integrated.  Users do not have to spend lots of time searching for the data or validating its meaning, lineage, or accuracy.
  • End-users are self-sufficient.  They have data access “on demand.”  This means that business users can access metadata, understand the meaning and differences of the data, and launch reports, run queries, and perform complex analysis without involving technical staff.  The focus is on the end users and how to support their vastly different analytic needs, skills, toolsets, and data access rights. 
  • Management understands the value of data and has established a culture of “fact-based” decision making.  The data is readily accessible to answer emerging business questions and fulfill new business needs in short order.  BI is considered fundamental to strategic business initiatives, and it is budgeted and staffed accordingly.

 

Q.

Only 4% of survey respondents indicate that they have a BI prioritization process.  What are the risks of not having a prioritization process? How does Baseline's BI Application PortfolioSM service offering help companies implement this BI best practice?

 

A.

Without a defined and sanctioned prioritization process, BI programs fall prey to many maturity inhibitors—business and IT never get on the same page, conflicting interests abound, and ultimately user adoption suffers. 

Without a prioritization process, “squeaky wheels” get most of IT’s attention and development projects enter never-ending cycles.  Single-purpose data get loaded to the data warehouse—of interest to one department and designed for one specific need.  Business and IT ask:  Who decides what to work on next?  Are we spending money on the right things?  Should we “pull the plug”?  How do we get executive level support?  How do we anticipate changing needs and the impact to the BI development schedule?

By imposing rigor in project selection and accountability in project delivery, prioritization raises the overall business value of BI to the enterprise.  It provides program and project visibility across the company, and increases data sharing across many different users.  Prioritization brings order to the way development projects are sequenced based on dependencies, achievability, cross-functional impact, and business value.

Baseline’s BI Application PortfolioSM service sets the industry best practice standard as one technique for driving BI maturity.  It serves as the de-facto development pipeline for the company’s BI program.  The BI Application PortfolioSM prepares a development roadmap and leaves you with the methods to sustain ongoing prioritization.  It provides a foundation to scope each project deliverable in 90-day increments, calculate ROI, and gather business requirements.  Each application in the portfolio contains core business questions and success metrics around the underlying business problems and data needed for a solution. 

 

Q.

According to the survey, the top-of-mind BI trend is “real-time BI”, closely followed by master data management (MDM) and service oriented architecture (SOA).  In layman's terms, what does “real-time BI” mean to BI users?  To BI developers?

 

A.

For BI users, real-time BI enables moment by moment business analysis. It involves using incoming transactional data to analyze the whole picture, detect unusual patterns, and take immediate action.  Real time BI is also known as “right time” BI, since the degree of data latency is informed by business need.

For example: A computer manufacturer may run multiple assembly lines using identical components on each line, but from different suppliers.  One supplier may have provided a bad component lot. While each assembly line builds the product, no errors are detected. But, as products come off the assembly lines, they are tested and yield a major spike in failures. With real-time BI, the component lot for that one supplier can be isolated out of all the work in progress to prevent potential failures in future products.

In another example: Credit card issuers continuously monitor card usage to detect unusual purchasing patterns across cities. Fraud usually occurs in a short period of time across many merchants in multiple cities. By analyzing real-time purchasing patterns as they occur, credit card companies can identify fraudulent use and greatly reduce losses.

For BI developers, real-time BI changes the data loading process.  Traditional BI development involves loading data at a specific point in time, usually overnight. While this approach simplifies the development and operations processes, it becomes inflexible to support real-time data needs. The real-time approach of loading data becomes more of a trickle feed, allowing transactions to be inserted into the data warehouse immediately as they occur. Because this is transaction based loading, it’s important to ensure that the DBMS locking capabilities don’t impede on-line reporting access.

 

Q.

According to the survey, respondents want to shift the business users' and executives' view of BI from "a set of tools" to "a business solution". How does Baseline recommend doing this? Why is this shift in perception important?

 

A.

Baseline recommends both pre-facto and post-facto mechanisms for proselytizing the business value of BI. A rigorous and regular requirements gathering process helps to engage business stakeholders in a sustained and meaningful way. And establishing regular “pushed” communications of BI progress—whether through a monthly newsletter that features application release schedules and upcoming training courses, or an internal portal that monitors progress of in-process applications, offers newly-implemented metadata definitions, and allows business people to register for userids—is a great tool for “keeping it warm” with the business. At the end of the day, business people will rally around BI when it gives them the reports they need to do their jobs, help the company serve its customers, and drive operational efficiencies through the smarter use of information.

 

» Return to Home Page

 

To request more information, contact us via e-mail or call us at 1-818-906-7638.
 

June 12, 2008. SAS Data Governance Workshop, Montreal Canada. Deconstructing Data Governance with Jill Dyché.

August 18, 2008. TDWI Conference, San Diego. BI from Both Sides with Jill Dyché.

» See our full schedule
 

Governance: A BI Best Practice. Use a very practical framework as a tool to design and communicate the BI program governance. Establish BI guiding principles, align decision-making bodies with decision areas, and define oversight mechanisms.
» Read the article

Data Warehouse Best Practices—An Implementation Framework. Data warehousing implementation projects can end up being highly complex and costly if you’re not careful.
» Read the article

» Browse our Articles &
   White Papers
 

© 2008 Baseline Consulting Group, Inc. All Rights Reserved.