BI Helping Retailers Control Inventory, Manage Finances

Computerworld -
New York

Retail Companies could improve financial and supply chain planning, and thus increase profits, by using business intelligence systems, according to speakers and some attendees at the National Retail Federation 2007 conference held here last week.

Though IT officials from some retailers said BI systems remain too expensive and too hard to implement for their operations, others maintained that the benefits would likely outweigh the costs.

Specialty apparel retailer Tween Brands Inc. is in the process of replacing an analytics system that used Microsoft Excel spreadsheets and mainframe applications with an integrated system made up of products from multiple vendors, said Roy Deegan, vice president of IT solutions delivery and process engineering at the New Albany, Ohio-based retailer.

The new analytics system includes an Oracle 10g database, application server and portal; Oracle Retail Price Management software; and merchandising intelligence applications from SAS Institute Inc., all running on IBM p595 Unix servers, he said.

Announcements

NRF Show •  Microsoft Corp. and Teradata jointly unveiled a link that will let users of Microsofts Excel spreadsheet access the Teradata Enterprise Data Warehouse. The link will be available in the first quarter. •  i2 Technologies Inc. unveiled Customer Order Management for Retail, which can be used to manage transactions over multiple channels. It will be available in the first quarter; pricing wasnt disclosed. •  Lawson Software Inc. introduced QuickStep Fashion, an ERP application for apparel and footwear companies. The product is available now.

The project began in 2004 when the retailer launched a plan to upgrade its BI capabilities as part of an effort to boost efficiency, cut costs and create a better buying experience for customers, Deegan explained. The plan called for Tween to improve inventory planning and create “one version of the truth” for the company’s financial and inventory analysts.

“When it came to the technology, we started with a clean sheet of paper,” said Deegan.

The Oracle Retail Price application went live last August. The company began rolling out the SAS software last spring, and that project is ongoing, he said.

Deegan said its too early to project a specific return on investment, but Tween does expect that the rollout will lead to improved profit margins.

Kevin Stack, vice president and CIO at Jo-Ann Stores Inc., a retailer of crafting, decorating and sewing products, said his firm is holding off implementing a BI system because of the high costs and the need for extensive manpower to implement it.

The Hudson, Ohio-based company is interested in evaluating new decision-support software from SAP AG, the supplier of its ERP software. However, any implementation of the software is at least three years away, he said.

“Before we can do it and provide business value, we must make sure that the business will have [the analytical methods] infused into their processes,” Stack said. “The people in the business need to understand what to do with the data and how the data impacts other parts of the organization.”

Keen Footwear, a Portland, Ore.-based footwear designer and distributor, announced at the conference that it plans to roll out ERP software and a BI application and dashboard from Lawson Software Inc.

The $1 million project, slated to go live in June, will help Keen better share data and collaborate with retailers that sell its products to ensure that their stores have the right mix of footwear, said Joe Zitomer, Keen’s director of operations.

The company has been growing rapidly, and its legacy system and processes couldn’t handle new, more sophisticated planning requirements, he said.

The old system was a heavily customized application from LogOn Business Systems, a New York-based maker of apparel software. Managing inventory, Zitomer said, was becoming “guesswork.”

Read more about business intelligence in Computerworld's Business Intelligence Knowledge Center.