Home > Manufacturing ERP/SCM/IT News > How to find the ROI of business intelligence projects in manufacturing
Manufacturing ERP/SCM/IT News:
EMAIL THIS

How to find the ROI of business intelligence projects in manufacturing

By Beth Stackpole, Contributor
06 Oct 2009 | SearchManufacturingERP.com

News and tips for using manufacturing ERP software
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

Over the years, John Thielman has managed dozens of data warehouse and business intelligence projects for a variety of companies, from manufacturers to major retail chains. While he's measured plenty of soft benefits around the various business intelligence (BI) projects he's been involved in, he's been hard-pressed to pull together a formal return on investment (ROI) calculation.
More on business intelligence in manufacturing
Discover how one manufacturer improved data management with BI software

Learn how SaaS BI reduces costs and maintenance

Find out what questions to ask when evaluating BI tools

His situation is no aberration. "I challenge anyone who talks about a hard and fast ROI on anything to do with business intelligence," said Thielman, currently an independent data warehouse project manager in the Dallas area.

"ROI from BI doesn't come from producing the reports quicker or producing the information quicker," he continued. "The real value of BI in manufacturing is arrived at with the common proactive decision-making based on information that is uniformly defined and calculated across the organization. It's an intangible value that you can't always estimate."

Struggle to calculate BI ROI metrics

According to experts in the data warehouse arena, Thielman has lots of company in his struggle to build a formal ROI case for BI projects. BI, which refers to a broad category of tools to help enterprise users make better business decisions, encompasses everything from traditional query and reporting, forecasting, decision support and data mining applications to newer offerings such as dashboards and portals.

Typically used as part of a data warehouse initiative or in conjunction with operational enterprise platforms like ERP or CRM, these BI tools organize and present data about the business, often in real time, to users who can apply it in their day-to-day decision-making.

Since BI is typically deployed for long-range strategy and competitive trends and planning, nailing down formal ROI metrics has proved elusive. Despite that lack of financial validation, companies continued to eagerly fund BI implementations because they realized there was intrinsic value in the solution.

"How do you put a monetary value on better decision-making?" asked Claudia Imhoff, president and founder of Intelligent Solutions, a data warehouse consultancy. "It's so intuitively obvious that you need this capability, [companies] forget about ROI."

However, with BI tools increasingly being tapped for more tactical applications and with the recession putting pressure on companies to reduce IT expenditures, companies can no longer afford the luxury of intuitively knowing they need BI.

In its report 2009 State of the Market: Mid-Year Insights, market research firm Aberdeen Group found that more companies are now actively measuring the ROI on BI investments. The report refers to a survey in which 42% of respondents selected sales performance metrics as their top target, followed by cost savings metrics, customer performance metrics and process efficiency metrics.

Identify business goals before implementing BI in manufacturing

But before putting those targets in sight, there is work to do to ensure that the ROI exercise is fruitful. According to Imhoff, the first steps are to define the business goals of a BI implementation and to have some measure of the current state prior to deployment so there is a benchmark for comparison.

It also may make sense, she adds, to tie the BI rollout to a corporate-wide initiative -- for example, reducing customer churn -- so that there is a clear connection between the use of BI and any progress the company makes toward its goals.

Tallying up BI costs is relatively simple -- the usual expenses around hardware, software licenses, dedicated personnel resources, training, etc. It's much harder to pinpoint the benefits. Hence the need to start with small, targeted BI projects that can show clear results.

"To get funded, look for things that can get you over the hurdle of minimal ROI," said William McKnight, president of McKnight Consulting Group, which specializes in data warehousing. BI projects that can prove out some sort of expense reduction for the organization -- reducing fraud, cutting back shipping or printing costs, or decreasing the number of customer returns -- are a good place to start, he said, rather than trying to establish value on a massive BI deployment.

"Identify something of high importance and keep your affinity to that outcome throughout the duration of the project," McKnight said. "Otherwise, BI can get lost in the shuffle."

User surveys aid in calculating ROI of business intelligence

Opportunity cost is typically the most problematic ROI metric, but it is often the area where BI has the most impact. Access to previously unavailable or hard-to-interpret data can be the linchpin for giving a company a competitive edge in seeking out new markets or reaching customers in a different way.

To identify these and other hard-to-prove BI ROI benefits, it's critical to connect with the operational areas of the business and ask users -- through surveys or one-on-one interviews -- about their problems and where data can help, said Mark Madsen, president of Third Nature, a data warehouse and BI consulting company.

"Find out what problems could have been prevented if they had information or what could have been done differently," Madsen said. "Those things are key elements to getting at the underlying ROI of BI."

About the author: Beth Stackpole is a freelance writer who has covered manufacturing techniques and manufacturing technology extensively.

Tags: Manufacturing ERP and business intelligenceVIEW ALL TAGS

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Manufacturing ERP and business intelligence
Selecting BI for ERP environment presents challenges, opportunities for manufacturer
Business intelligence and manufacturing case studies
Guide to systems integration with ERP
ERP and BI integration provides business insight to decision-makers
BI training best practices should account for supply chain, operational efficiencies
IT, executive collaboration central to BI best practices
Open source BI software gains traction with manufacturers
Saint-Gobain improves data network management with MicroStrategy BI
SaaS BI for manufacturing makes inroads by reducing cost, maintenance
Guide to business intelligence for manufacturing

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
Computer-aided process planning (CAPP)  (SearchManufacturingERP.com)
manufacturing intelligence software  (SearchManufacturingERP.com)
product information management (PIM)  (SearchManufacturingERP.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary

HomeNewsTopicsITKnowledge ExchangeAsk the ExpertsMultimediaWhite Papers
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2008 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts