Primer: BI Modeling And Optimization - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

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.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
1 of 3
Comment  | 
Print  | 
More Insights
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

10 Things Your Artificial Intelligence Initiative Needs to Succeed
Lisa Morgan, Freelance Writer,  4/20/2021
Tech Spending Climbs as Digital Business Initiatives Grow
Jessica Davis, Senior Editor, Enterprise Apps,  4/22/2021
Optimizing the CIO and CFO Relationship
Mary E. Shacklett, Technology commentator and President of Transworld Data,  4/13/2021
White Papers
Register for InformationWeek Newsletters
Current Issue
Planning Your Digital Transformation Roadmap
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
Flash Poll