Software // Information Management
08:36 PM

Primer: BI Modeling And Optimization

An examination of BI-based Modeling and Optimization, the modeling of BI data to arrive at the optimal course of action for business challenges.

At the apex of Business Intelligence is BI-based Modeling and Optimization (BIMO), a set of technologies for delivering better decision-making options to executives and managers. BI-based Modeling and Optimization combines the rich processed information provided from BI tools and data marts and feeds them into modeling and optimization tools to arrive at the best possible options or courses of action in a problem situation. These decision situations can be operational -- determining the best way to run a refinery given record breaking oil prices, for example. Or the problem can be strategic -- determining the best portfolio of capital projects given BI-based market projections and costing estimates.

The key attractions of BIMO are that it can deliver outstanding return on investment both in day-to-day operations as well as one-time decisions. In addition, BIMO methods really help to refine and discipline the thinking and processes around decision making. In fact, BIMO tends to produce better returns in high-flux, high-change periods both operationally and strategically. Unfortunately, many BIMO systems are quietly hidden away, as corporate executives do not want to reveal their competitive advantage-producing systems. Think of the optimizers in supply chain and production scheduling packages: In some cases the optimizing tools are so elegantly embedded that staff do not know the power of the tool harnessed for their benefit. Rightfully, users view the tool as a total BI-based optimizing system.

Traditionally, there have been three major risks associated with delivering consistent, high-quality BIMO results. First, the underlying disciplines of linear programming, network modeling and non-linear optimization are not only difficult and complex but also different in methodology among themselves. Second, getting expertise can be expensive because, as often as not, linear programming experts cannot help with non-linear math optimization problems. Sometimes the data and algorithms can be shared; but the underlying models and solution methods are distinct, even disjointed. (Methods used for linear programming are very different among themselves as well as from those used for non-linear optimization.)

But the most challenging problem for BIMO is marshaling together all the data sources necessary to support the models. What can make BIMO data-handling even more demanding is the fact that BIMO inputs frequently have to go through several stages of processing as they filter up the BI stack: ETL, consolidation, analysis and forecasting. Fortunately, the quiet revolution in BI -- over the past 10 years BI tools have become easier to use, better integrated, and broadly available -- has provided improved data warehousing, ETL, and analytics at lower cost and with greater ease of use. In addition, new technologies such as XML, business process management and Web services further ease the data-marshaling burden. The result is that BIMO weathered the dot-com-induced IT slump with a solid 3-9% annual growth rate and diversified new offerings. So let's take a look at the BIMO vendors.

1 of 3
Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
The Agile Archive
The Agile Archive
When it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
Register for InformationWeek Newsletters
White Papers
Current Issue
Top IT Trends to Watch in Financial Services
IT pros at banks, investment houses, insurance companies, and other financial services organizations are focused on a range of issues, from peer-to-peer lending to cybersecurity to performance, agility, and compliance. It all matters.
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on for the week of July 24, 2016. We'll be talking with the editors and correspondents who brought you the top stories of the week to get the "story behind the story."
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.