DS0409_REPORT_p15_CS Dataflux:Layout 1 1/4/09 17:13 Page 15
CASE STUDY
CUSTOMER DATA QUALITY
PITT OHIO EXPRESS Delivers Results with Improved Customer Data
The Business
PITT OHIO EXPRESS is a Pittsburgh, Pa.-based
transportation company that handles less-than-
truckload shipping throughout the mid-Atlantic and
Great Lakes states. With 21 terminals in its service area, No
“
Before implementing DataFlux, PITT OHIO’s customer
data management had been consuming significant
amounts of time from the IT department and of
multiple business users. After using dfPower Studio to
w, with increase the quality of customer data, PITT OHIO was
PITT OHIO makes over 9,500 daily deliveries to more able to manage this information with only a single
than 14,000 unique locations.
the new,
business user.
consolidated
The Challenge PITT OHIO was able to turn its improved database into
On any given day, PITT OHIO processes 9,000 – 11,000
view of its
a competitive advantage. By refining its address
new invoices. Each invoice is entered manually, in a
customer data,
information, the company was able to offer its
process that has historically given greater precedence to customers more efficient shipping times and more
entry speed than to data quality. While understandable PITT OHIO advanced logistics than its competitors. Now, with the
from an operational perspective, this rapid-fire data new, consolidated view of its customer data, PITT
entry approach eventually created a significant
has been able
OHIO has been able to provide more targeted service,
duplicate data problem for the company. Each variation
to provide
to identify and change its most valuable customers and
in customer name or address information would create deliver competitive value in return.
an entirely new customer record, meaning that a single
more targeted
entity could be represented by dozens of records in the
service, identify
Quick Facts
database system. a71 Routinely handled 9,000 – 11,000 invoices per day
its most a71 Reduced 650,000 unique database entries into an
With this duplicate data, accurately managing customer accurate master repository of 10,000 records
information was a critical concern. In an industry where
valuable
a71 Maintained an ongoing 99% data consolidation rate
swift turnaround time was crucial, the requirement to
customers
dedicate valuable resources to the time-consuming
administrative task of managing these customer records
and deliver
had a very real impact on the company’s efficiency.
competitive
The Dataflux Solution value in return.
PITT OHIO selected DataFlux dfPower® Studio to
complete its customer data integration initiative.
Justine Russo,
dfPower Studio’s intuitive interface allowed PITT
Manager of
OHIO’s business users (those employees whose job
performance was tied to the integrity of information) to Market
take responsibility for managing customer data.
dfPower Studio allowed PITT OHIO to discover and
Research &
address problematic data, and to verify and merge
Business
customer records. Business users built data
improvement workflows quickly and logically with the
Intelligence,
innovative job flow builder.
PITT OHIO
With dfPower Studio’s fuzzy logic matching capabilities, EXPRESS
PITT OHIO was able to reconcile customer records,
identify duplicates, and reduce these multiple instances
into a single master record.
The Results
PITT OHIO began the project with a goal of a nine-
month implementation schedule. With DataFlux’s
flexibility and intuitive interface, deployment and
learning time were significantly shorter than scheduled.
This project, scheduled for nine months, was completed
in just five.
Furthermore, PITT OHIO began the deployment with
an expectation of an ongoing 95% data consolidation
rate. dfPower Studio surpassed this goal, giving PITT
OHIO a consistent 99% consolidation rate.
DATA STRATEGY | REPORT | APRIL 2009 15
Page 1  |  Page 2  |  Page 3  |  Page 4  |  Page 5  |  Page 6  |  Page 7  |  Page 8  |  Page 9  |  Page 10  |  Page 11  |  Page 12  |  Page 13  |  Page 14  |  Page 15  |  Page 16  |  Page 17  |  Page 18  |  Page 19  |  Page 20  |  Page 21