Business Intelligence

Tips for a cheap, profitable and effective BI deployment
By: Eric Lai - Computerworld (US)(NA) (18 Sep 2009)

For all the benefits they bring, a business intelligence system rollout can be pretty expensive for most organizations. Four IT leaders share their secrets on how they panhandled for a BI budget and came out with a cheap, profitable and effective deployment

When Raghu Bala, CTO of Automotive.com, joined the company in 2006 to help it build out its business intelligence infrastructure, he put up on his office wall a picture of a cup stuffed with dollar bills and change, with a caption underneath that said, "Panhandling for BI budget."
"I actually got some money out of that," Bala mused during his talk Wednesday at Computerworld's Business Intelligence Perspectives conference. He and other IT leaders shared their tips on how to deploy BI cheaply, profitably and effectively.

Bala also saved money other ways by using the free Excel-based BI tools that Microsoft Corp. bundles with its SQL Server database , sharing database administrators with the engineering team, and building cubes for reports only after watching what reports the power users at Automotive.com built for themselves.

This saved IT the labor of having to create and e-mail dozens or hundreds of canned reports, and instead trained the users to "generate their own reports and generally think for themselves," he said.
Know your profitable and unprofitable customers
For companies with long-term customer relationships, one of the best things BI can do is help figure out which are the profitable ones and which are the money-losers.
According to Basil W. Blume, chief analytics officer of Colorado Capital Bank, the average ratio of profitable:unprofitable customers in the retail banking industry is 70:30.
"It's just not profitable when all they have is a $1,000 checking account," he said. "But the other 30 per cent of customers make it up."

If not directed by management to solve this problem, Blume suggests that BI managers step in and draft a plan of how to figure this out.
But which of the many definitions of profitability should they use? Blume suggests using the "contribution margin." That's a relatively simple figure to derive, he said, especially compared to net income, which requires users to divide gross income by fully loaded costs.

Getting adoption in a non-techie workplace
Anthony Marano Company is a 50-year-old fruit and vegetable wholesaler in Chicago. Operating out of a single 400,000 square-foot warehouse, the $200-million-a-year family-owned company remains close to its heritage as an Italian American-owned grocer.
"There's a lot of guys named Joey, Nicky and Tony here," joked Chris Nowak, the chief technology officer.
Until 2003, none of Marano's buyers and sellers used computers. Orders were handwritten and vendor and customer information was stored on Rolodexes. All of the expertise resided inside the brains of Marano's buyers and sellers.
This seemed treacherous, considering the real-time nature of Marano's business. The company specializes in supplying produce at the last minute. "We are the 24-hour Walgreen's of fruits and veggies. People buy from us when they are short," Nowak said.
Also, Marano's huge size and customer base means that it could supply vital pricing information back to farmers that could influence their decision whether to go to the trouble of trying to recover a damaged crop, such as strawberries at risk from a freeze. That wasn't easy without a BI system, much less PCs for the buyers and sellers to use.

Nowak was brought in to deploy the company's first computer-based BI system. Knowing that overcoming resistance from the users -- the sales staff -- would be key, Nowak made sure to select an easy-to-use and powerful tool for them.
He licensed the Inxight software owned by SAP AG, which offers a visualization tool called StarTrees. These are circular expandable charts that Nowak purposely chose for their resemblance to old-fashioned Rolodexes.
These charts quickly and conveniently let the sellers get price and stock information on all 1,400 types of produce carried by Marano.
The charts were so useful that soon all 28 buyers and sellers were trained and using the StarTrees, Nowak said. It allows them to offer more fine-tuned pricing to buyers and farmers and move product more efficiently with less spoilage, ultimately boosting profits, he said.