Consumers may be duking it out for Nintendo Wiis in\n shopping aisles this year, but overall the battle for holiday\n spending dollars will be between the retailers. With\n consumers\u2019 awareness of a softening economy, retailers\n will be forced to into stiff competition for consumer dollars,\n according to the National Retail Federation.\n MORE On CIO.com\n \n Retailers Want BI Benefits, but Struggle With Challenges\n \n E-Commerce and Supply Chain Systems Gird for Black Friday\n \n The High-Stakes Search for Supply Chain Excellence During the Holiday Rush\n \n Online Shopping: How to Get the Impulse Purchase\n \n How IT Failures Wreck Holidays for Many Companies\n Sahir Anand, an analyst at the research consultancy\n Aberdeen Group, says this competitive\n landscape makes business intelligence critical. It\n represents the work of turning the massive customer and\n transaction data warehouses into useful guidance on\n everything from how to attract and deliver a great customer\n experience to what merchandise to stock and in what\n balance.Anand talked to Associate Online Editor Diann Daniel\n about what retailers should be doing with their business\n intelligence tools for this essential business season.CIO: First off, do you think business intelligence\n is a must for today's retail companies?Sahir Anand: I think if you want to improve\n customer retention and sales, in all channels\u2014store, Web,\n catalogue\u2014at some stage you'll have to adopt business\n intelligence tools because the transactions and data are so\n complex nowadays. Without business intelligence tools, it's\n going to be a lot of gut-feel decisions in terms of how you\n plan your merchandising strategy to fulfill customer demand.\n And that just doesn't work well.Take the example of the holiday season. Business\n intelligence is important for any seasonal sales, but it's\n crucial for the high traffic, high-volume Christmas holiday\n season. Business intelligence combines data and shows patterns\n and trends to give customer insight, which can then be used to\n guide sales, marketing and other key areas. Most importantly,\n BI delivery tools provide the reports and dashboards that are\n required for retail performance management.The important thing for any retail segment, especially for\n the specialty retail segments as they drive a bulk of the\n holiday sales, is to systematically identify the products your\n consumers want, and especially to identify new products they\n may want and make sure that you deliver those new products. In\n order to make sure you have no gaps between what you offer and\n what consumers want, you need to identify and forecast trends,\n and look at the demand pattern over time. Business intelligence\n integrates the complicated customer, location and product\n information and enables you to see what patterns are \n\nformed.\n This more effectively helps you plan for the holiday\n season.Using business intelligence to establish a merchandise\n strategy must begin well in advance, at least a year. You need\n to start planning the best merchandise fit for customers during\n the key season by looking at comparative trends, internal\n transaction data and syndicated data, such as consumer\n demographics from companies such as Nielsen.Avoiding Overstock Sales Starts at the Supply ChainCIO: Last year, many stores ended the\n holiday season with leftover stock and were forced to mark down\n a lot of merchandise. Why is getting that merchandising\n strategy right so difficult?Anand: Retailers tend to focus on the front\n end at the expense of the back end. They effectively plan for\n how their stores, website and catalogue are going to look. But\n the back-end that involves reviewing and analyzing customer\n data for taking effective merchandising decisions is always an\n issue. It's a race against time in the case of several\n retailers as their data intelligence strategy is not in place\n or the response to BI is too slow (non-real-time).Back-end focus is the key towards a successful sales season.\n Retailers must focus on the entire retail supply\n chain\u2014product sourcing, procurement, the order-to-time\n cycle. They must identify which products will actually sell,\n and create an entire lifecycle management strategy right from\n product development to delivery nine to 12 months before a key\n selling season. And business intelligence plays a huge role in\n it, because it identifies the problem spots for the company in\n that entire lifecycle management. It also identifies\n opportunities to improve, in terms of the sourcing of the\n products, and actually mapping that sourcing with consumer\n trends.Problem: Dirty, Distributed DataCIO: What is the current state of the retail\n industry\u2019s use of business intelligence and what are some\n of the challenges? Anand: Aberdeen research shows that 71\n percent of retail companies are using business intelligence,\n primarily to manage customers, plan business strategy, and for\n merchandising. Still, only about half of companies are using BI\n for merchandising, so I think that trend has to improve. The\n enormous volumes that retailers have to plan and execute can be\n challenging.The main challenge that companies face using business\n intelligence is that their data is not clean enough for\n analysis. Forty-nine percent of our survey respondents listed\n dirty data as a top challenge when initiating or implementing\n business intelligence or predictive analytics. Another\n associated challenge is that the data is scattered throughout\n the organization; it's not centralized. Coming up with good\n sales analysis, space planning analysis, assortment planning\n analysis, market basket analysis\u2014all of which can help a\n company create a good merchandise stack for holiday\n season\u2014requires integrated data. This is isn't possible\n without \n\na centralized data strategy, and it isn't valuable if\n the data is dirty.Data issues are a problem for a number of companies\n throughout manufacturing, hospitality, and the other service\n industries. It's not just retail companies that have this\n issue: Data at many companies is decentralized, it's fragmented\n in different locations.CIO: How can organizations fix this\n problem?Anand: First off, the mandate has to come\n from the top-level management, it must have top-level executive\n support. Top-level executives in companies that are doing\n business intelligence well\u2014Walmart, Best Buy, Staples,\n Target and other top retailers\u2014make clean data a\n priority.Once a data centralization strategy is in place,\n organizations can start with data cleansing projects to improve\n the data quality. It's a slow process but it's a crucial one.\n So for example, you eradicate duplicate data for location,\n products and customer data such as having one person's name in\n the system in different ways, such as Robert C. Parker and Bob\n Parker.Customer information duplication is a especially a problem\n since the consumer is interacting with different faces of the\n organization\u2014Web, store and so on\u2014so information in\n captured in different ways.The other thing is to limit the fields that you typically\n look at when you're analyzing customer data and product\n location data. There are so many fields that organizations\n have. Some of them are totally redundant. So you should have\n some core fields where you have the basic demographics and then\n you have customer transaction size and market basket size. You\n can then apply algorithms for cross-relational data analysis\n and do constructive business intelligence.Take Best Buy, which does business intelligence very well.\n They used to have immense disparity of sources and fragmented\n reports. There was no centralized data repository for them, no\n clear path for clean information to be correlated for analysis\n and ad hoc reporting of department or business process\n performance were the norm. But they cleaned their data,\n integrated those disparate data sources, and built an excellent\n national scorecard that measures enterprise performance across\n different retail processes. They've seen effective results come\n out of it.And the scorecard is just one example of successful BI usage\n by Best Buy. Another area where they've succeeded is looking at\n the marketing and overall company intelligence to guide how and\n what to sell to the various segments of their customer\n base.Making Predictions with Business Intelligence\n ToolsCIO: Much of business intelligence looks at\n historic data. How do you predict the new items customers will\n want?Anand: Forecasting the new items your\n customer will want is crucial for most retailers, especially\n for the holiday season.The key is looking at the research on key new product adoption trends, and using predictive analytics to determine just what your customers will want. I can't overstress how important this is. When the iPod wave started, the companies that embraced it immediately saw success and had continued success because the customer got accustomed to seeing that particular merchandise at that particular store.Companies that did not embrace it were the followers and they\n lost out. If those followers had looked at the\n competitive landscape and identified that in advance, they\n would've been able to fulfill customer need. Now customers will\n simply go elsewhere.