PITT OHIO delivers better results with improved customer data
Transportation company uses SAS® DataFlux® Data Management to power customer data integration, turning its improved database into a competitive advantage.
- Routinely handled 9,000 – 11,000 invoices per day.
- Reduced 650,000 unique database entries into an accurate master repository of 10,000 records.
- Maintained an ongoing 99-percent data consolidation rate.
PITT OHIO is a Pittsburgh-based transportation company that handles less-than-truckload shipping throughout the Mid-Atlantic and Great Lakes states. With 22 terminals in its service area, PITT OHIO makes over 9,500 daily deliveries to more than 14,000 unique locations.
On any given day, PITT OHIO processes 9,000 to 11,000 new invoices. Each invoice is entered manually, in a process that has historically given greater precedence to entry speed than to data quality.
While understandable from an operational perspective, this rapid-fire data entry approach eventually created a significant duplicate data problem for the company.
Each variation in customer name or address information would create an entirely new customer record, meaning that a single entity could be represented by dozens of records in the database system.
PITT OHIO selected SAS DataFlux to complete its customer data integration initiative. The intuitive interface allowed PITT OHIO's business users (those employees whose job performance was tied to the integrity of information) to take responsibility for managing customer data.
SAS DataFlux technology allowed PITT OHIO to discover and address problematic data, and to verify and merge customer records. Business users built data improvement workflows quickly and logically with the innovative job flow builder.
With SAS DataFlux's fuzzy logic matching capabilities, PITT OHIO was able to reconcile customer records, identify duplicates, and reduce these multiple instances into a single master record.
PITT OHIO began the project with a goal of a nine-month implementation schedule. With SAS 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.
PITT OHIO began the deployment with an expectation of an ongoing 95-percent data consolidation rate. SAS DataFlux allowed the company to surpass this goal, giving PITT OHIO a consistent 99-percent consolidation rate.
Before implementing SAS 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 SAS DataFlux technology to increase the quality of customer data, PITT OHIO was able to manage this information with only a single business user.
PITT OHIO was able to turn its improved database into a competitive advantage. By refining its address information, the company was able to offer its customers more efficient shipping times and more advanced logistics than its competitors.
Now, with the new, consolidated view of its customer data, PITT OHIO has been able to provide more targeted service, identify its most valuable customers and deliver competitive value in return.
The results illustrated in this article are specific to the particular situations, business models, data input, and computing environments described herein. Each SAS customer’s experience is unique based on business and technical variables and all statements must be considered non-typical. Actual savings, results, and performance characteristics will vary depending on individual customer configurations and conditions. SAS does not guarantee or represent that every customer will achieve similar results. The only warranties for SAS products and services are those that are set forth in the express warranty statements in the written agreement for such products and services. Nothing herein should be construed as constituting an additional warranty. Customers have shared their successes with SAS as part of an agreed-upon contractual exchange or project success summarization following a successful implementation of SAS software. Brand and product names are trademarks of their respective companies.
Copyright © SAS Institute Inc. All Rights Reserved.