Business Intelligence and Microsoft Office: Market Trends and Integration Practices -- Participate in this survey designed for end users of BI and data integration software! The first 50 qualified participants will receive a $5.00 Starbuck’s gift certificate. All qualified participants will receive a $125.00 membership to the Ventana Research Performance Management Community. WebCast: Enterprise Portal Business Impact -- Learn how to best identify, measure and document the business impact portals can have on key business processes with our roundtable discussion, sponsored by SAP. Register today to access this event on-demand.
News Community Events Browse Resources Subscribe
Industry News  |  Playbooks  |  White Papers  |  Bookstore
   | Advanced
CUSTOMER INTELLIGENCE
PERFORMANCE MANAGEMENT ENTERPRISE APPLICATIONS
INFORMATION MANAGEMENT APPLICATION MANAGEMENT
APPLICATION INTEGRATION BUSINESS INTELLIGENCE
ENTERPRISE DEVELOPMENT
ANALYTIC APPLICATIONS STORAGE
DATABASE SUPPLY CHAIN
DATA WAREHOUSING


Buy A Link Now
Products and services from our sponsors.
Intuit Help Desk & Network Management Software
Intuit provides Track-It! and Network Monitor - the leading help desk and network management solutions for call tracking, problem resolution, IT asset management, electronic software distribution, and network performance monitoring. Free demo & trial

DataMirror Delivers Real-Time Data Integration
Get the real-time advantage by improving the reliability of your information with DataMirror Integration Suite, an end-to-end solution that combines DataMirror's real-time data integration software and global professional services. Learn More.

Researching Microsoft/Linux Managed Servers?
Rackspace offers award-winning Microsoft and Linux Managed Servers that are custom configured to your specifications. See why thousands of companies choose the Microsoft Hosting Provider of the Year.Tier 1 data centers-Zero Downtime Network Guarantee

Software License control, Windows XP/2000 Upgrades
Use your Intranet to manage Software Licenses, plan for Windows XP/2000 upgrades, do Security Audits and more. Click to try and ask for our white paper - PC Management for the Internet Age.

Telecom Expense Management - Avema
Reduce data, wireless, and voice costs by automating invoice and expense management. The Avema Global Alliance provides telecom cost management services and software to streamline invoice processing, monitoring costs, and auditing expenses.

 
Last Name

Email


 
Locate an article from our print magazine. Just enter your Locator ID Number below (please use lower case).
ID#



March 1, 2005  /   Issue TOC

Email article Write to editor Print article

Intelligence In The Here And Now

To deliver a decisive competitive advantage with CRM, use analytics to predict present -- and future -- customer behavior


Page 3

Predictive analytics, or the application of data mining algorithms to discover patterns in data is already a competitive advantage for large organizations on the cutting edge (see the accompanying Field Report on Churchill Downs). IDC predicts that the software, offered by Computer Associates, KXEN, SAS, SPSS and others, will steadily attract customers in 2005. What makes predictive analytics different from traditional BI analysis is that you're letting the data do the talking. As opposed to BI queries that specify desired results, predictive analytics software leads a discovery process. The algorithms tap carefully managed data warehouses and other resources to uncover patterns and data relationships that help companies predict their most profitable customers, how pricing and product packaging might affect buying decisions and much more.

Of course, for customers, the future is right now. Predictive analytics, operational CRM and other methods are at their best when they enable companies to deliver a richer customer experience tailored to their immediate interests. With customer loyalty assured, the future will always be bright.

DOSSIER

Actionable Intelligence for CRM

The Brief
»CRM applications hit a wall if businesses don't leverage data resources to reveal customer behavior. IT must design and implement high-performance, integrated customer intelligence and deliver it to the right person, in the right form, at the right time. "Right time" is critical to marketing process automation, which depends on accurate, event-driven intelligence. Give predictive analytics careful consideration; they may offer a data-driven strategic edge, helping you identify your best customers and take action to keep them loyal.

Options
»Go with enterprise BI over simple reporting offered by CRM packages. If customer data volume and query demands outgrow what's offered within your CRM system, replace it with a scalable BI infrastructure.
»Develop "operational" data warehousing. CRM reaches its full potential when employees have actionable intelligence to address ongoing customer interaction. Data streaming and trickle feeds can complement batch loading; enterprise business integration and message-oriented middleware support streaming.
»Employ customer data hub, CDI or enterprise information integration (EII) software. As operational sources proliferate, federated query access may deliver the single customer view faster and with fewer integration headaches than traditional ETL and data warehousing. Customer data hubs, CDI and EII generally focus on metadata integration, which may prove useful for global business integration.
»Dive into predictive analytics. If you have diverse, quality data to work with, you could be ready to exploit advanced analytics-and to let data shape how you enhance the customer experience.

Influencers
»How good is your data? You can't go far without high-quality data. Address problems at the source or plan to cleanse data later in the process.
»How broad is the user base for customer intelligence? Match CDI and analytics to the business areas that need it. Your CRM package may provide everything you need.
»Does business success depend on customer loyalty and better return on customer? If so, predictive analytics may help you gain a competitive edge.

Action Items
»Address CDI needs. Define how you will integrate data resources to deliver a single view of the customer. Remember to look at all channels, including self-service.
»Move to "right time" information delivery. Enable sales, marketing and service to engage in richer, more knowledgeable customer interaction.
»Use data to reshape customer experiences. Predictive analytics can uncover buying and behavior patterns that will help you respond to customer interests before your competitors do.

FIELD REPORT    Churchill Downs, Louisville, Ky
In less than one year, this fabled wagering powerhouse developed advanced CRM and predictive analytics for deeper customer insight

"This is a triple crown race," says Atique Shah, vice president of CRM and technology solutions at Churchill Downs. Shah is the jockey, so to speak, of a significant implementation of predictive analytics and advanced CRM. The setting for such cutting-edge customer intelligence is fairly surprising; Churchill Downs is most famous for the Kentucky Derby, since 1875 the great annual festival of thoroughbred horse racing held in Louisville, Ky.

It would be hard to imagine anything more tradition-bound than the Kentucky Derby. However, the company has expanded aggressively over the past 10 years to include several other tracks, a casino and a network of off-track betting, simulcast racing operations. Churchill Downs claims a market share of 20 percent of all thoroughbred wagering in the United States.

Shah arrived in Louisville in December 2003 after an award-winning stint at GSI Commerce, where he led a multichannel CRM initiative that included database marketing and data mining. His mission was to employ CRM analytics to extend the influence of Churchill Downs' core values of strong customer service and develop one-to-one relationships that would be integral to its brand across all channels and properties.

One of his first moves was to bring in E.piphany's CRM suite to create a software platform from which he could upgrade the company's marketing effectiveness. Then, to build customer intelligence, Shah turned to the data universe in front of him: more than 100 different data sources, all of which were critical to reaching the lofty goal of a 360-degree view of the customer. Sources included relational databases, Microsoft Access and Excel, flat files and more. Shah's team consolidated data into a primary operational data store and an enterprise data warehouse running on Oracle 9i.

Dismissing prognostications from a prominent systems integrator that it would take three to five years, Shah hired a crack team of 18 CRM experts and worked with Ascential, E.piphany and SPSS services to finish development in November 2004. "We loaded seven data sources into our CRM system initially, choosing the most valuable from transaction, lifestyle and demographic perspectives."

Continuously adding data sources would prove important because Shah's real target was a platform for predictive analytics — "the foundation of everything we believe in." Employing SPSS's Clementine 9.0 data mining workbench, Churchill Downs built models that can, with increasing accuracy, predict the future potential of a customer based on one day's worth of transactions. Then came the confrontation with tradition. Churchill Downs has a longstanding loyalty rewards program backed by a database of some 200 million transactions by hundreds of thousands of customers. The company had long ago decided on four customer tiers, but Shah felt it was time for the data to tell how many tiers, or segments, really made sense. "Without imposing anything on the data, Clementine said there were nine segments."

Rolling out the system to the businesspeople, Shah's team had to explain why nine segments based on multiple attributes should be "the foundation for every program we put in place — all the direct mail, call center, ticket sales and everything." There was resistance, but compromise was reached. "Now, we think in the segment, but we act in the tier. We don't go to the customer and say, 'Hey, you're a Smarty Steve'-one of our top customer segments. We still use the tiers."

Smarty Steves win 80 percent of the time, Shah says. "In horse racing, data is God. The more information you have about the jockey, horse, track conditions and so on, the better your chances of winning. And I want customers to win: In horse racing, you're not betting against the house; you're betting against everybody else betting in that race. I'd rather they win because then they come back and play more."

Predictive analytics have had a pervasive effect beyond strictly CRM. "Because of our data knowledge, we're implementing a brand-new ticketing system, Web site and content management system," says Shah. "Without casting out tradition, we're doing things that we've never done before."

— D.S.


Email article Write to editor Print article




Rate This Article

Comments:

Optional e-mail address:




business intelligence

Industry News  |  Playbooks  |  White Papers  |  WebBlog  |  Career Center  |  Bookstore  |  Intelligent Enterprise Conference  |  TechWebCasts  |  RealWare Awards  |  Issue Archives  |  Authors  |  Story Types  |  Channels  |  Info Centers  |  RSS  |  Site Map  |  About us  |  Edit Cal  |  PR Info  |  Contacts  |  Advertise  |  Feedback  |  Weekly Newsletter  |  Managing Content Newsletter  |  Subscribe to Intelligent Enterprise Magazine