Kelley Blue Book taps data analytics tools to improve car valuation

From updating car values once in five months, Kelley now does it once a week

By Jaikumar Vijayan, Computerworld |  Software, analytics Add a new comment

Car buyers looking to purchase new or used vehicles have relied on the Kelley Blue Book to give them an estimate of how much a vehicle is really worth.

Until recently, the numbers were largely educated conjectures that Kelley analysts arrived at by running a handful of car sales and other metrics through a rudimentary pricing algorithm.

Not anymore. Kelley has begun using sophisticated data analytics tools to sift through volumes of historical and current data to arrive at what company executives say are far better car valuations.

"We went from using megabytes of data to using terabytes of data" for estimating car values, said Dan Ingle, vice president of analytic insights technology at Kelley Blue Book. "We moved from simply averaging data to running sophisticated models," based on transaction and regional data, he said.

KBB is an example of how a growing number of small and medium-size businesses (SMBs) are successfully applying data analytics to improve the way they do business. Driving the trend is the growing availability of relatively low cost, specialized tools for analyzing large sets of structured and unstructured data, according to an upcoming study by The Data Warehousing Institute .

Kelley is an early adopter in the SMB space. The company started embracing analytics technologies about three years ago in a bid to make better use of its historical data as well as the new data it had begun capturing from website users and social media, Ingle said.

The company found its Microsoft SQL-based business intelligence and data warehousing infrastructure was not scalable enough to handle Kelley's growing data analytics requirements.

About two years ago, the company moved over to a new IBM Netezza Twinfin data warehousing appliance which it supplemented with a second similar system last December. The two systems together, with software from Information Builders and MicroStrategy, form the core of Kelley's new data warehousing and business intelligence capabilities.

Kelley is also using a variety of predictive analytics, data mining and text analytics tools from SAS Institute to help analyze the data it collects. Much of the analytics used to deliver new and used-car values, targeted advertisements, customized offers and reviews on the company's website kbb.com are powered by SAS' software.

From being a legacy book-publishing company, Kelley has transformed into a completely analytics-driven company, said Shawn Hushman, Kelley's vice president of enterprise analytics. Analytics powers almost every facet of the company's business, including its car valuation processes, market research, customer analytics, financial forecasting and demand planning, he said. Kelley's analytics group has grown from one person to 23 in just just three years.

The effort has begun to pay off in several areas. One of the most dramatic improvements has been in Kelley's car valuations, which are based on a far richer data set than before, Hushman said. From updating car values once every five months, Kelley now updates values every week for more than 20,000 vehicles. "We could do it on a daily basis if we wanted to," he said.

Kelley's efforts to mine social media and web data such as weblogs and clickstream data has also greatly improved the company's ability to forecast ad inventory, gauge customer sentiment and predict user behavior.

"If you look at where we have focused our analytics efforts, it has been around two disparate data sets," Ingle said. One of them is about providing better vehicle valuation data, while the other is about the company's Web presence.

One of the more interesting aspects of Kelley's data analytics effort is its focus on social media and text analytics, said Tapan Patel, global marketing manager for SAS' predictive analytics and data mining group. It's rare for companies, especially of Kelley's size, to get started on social media and text analytics so early in their analytics life-cycles, he said.

Even many larger companies that have been doing data analytics for years are only now beginning to explore how to take advantage of social media and text-mining tools to boost their analytics capabilities, he said.


Originally published on Computerworld |  Click here to read the original story.

ITworld LIVE

SoftwareWhite Papers & Webcasts

White Paper

Activities Streams Base An Integrated Social Layer

The enterprise social software market is exploding thanks to converging trends of consumerization, cloud, and mobile. In this must-read report, "The Forrester Wave: Activities Streams, Q2 2012", Forrester Research Inc. evaluated five social software vendors with core strengths in the stream based on the overall strength of vendors' current offerings, a clear product strategy, and vendor market presence. In a detailed look at the space, Forrester named Yammer as a leader.

White Paper

ESG Lab Review: HP 3PAR Peer Motion Software

This ESG Lab review sponsored by HP + Intel documents hands-on testing of HP 3PAR Peer Motion Software's distributed volume.Intel and the Intel logo are trademarks of Intel Corporation in the U.S. and/or other countries.

White Paper

ESG Lab Review: HP 3PAR Peer Motion Software

This ESG Lab review documents hands-on testing of HP 3PAR Peer Motion Software's distributed volume management with a focus on federated workload balancing, asset management, and thin provisioning.Intel and the Intel logo are trademarks of Intel Corporation in the U.S. and/or other countries.

White Paper

Deliver Cost-Effective Business Continuity with Extreme Capacity

IBM DB2 provides application cluster transparency technology that equips organizations running OLTP applications with the ability to deliver high availability and continuous uptime for transactional data, plus the flexibility and capacity they need to remain competitive.

White Paper

What Developers Want: The End of Application Redeploys

Eliminate application restarts in Java with JRebel! JRebel is a JVM plugin that eliminates application redeploys from the Java development cycle, a process that takes over 10 minutes of coding time away from developers each working hour, according to a recent survey. Just code, refresh and see everything instantly.

See more White Papers | Webcasts

Ask a question

Ask a Question