Case Study: Idaho Transportation Department achieves major duplicate-record reduction and improved data quality with Experian

The Idaho Transportation Department reduces duplicate records and takes a proactive approach to data quality

The Idaho Transportation Department, which manages aeronautics, highways, the DMV and other services for Idaho’s 1.6 million residents, faced fragmented, transactional data across siloed systems and a non‑relational mainframe that produced massive duplicate records. A legislative mandate to maintain one DMV record per customer exposed the need for better matching, long‑term storage, reporting and an ongoing deduplication process after the agency discovered millions of redundant records.

By adopting Experian Data Quality and Experian Pandora for matching, address verification, visualization and rule-based cleaning, the department simplified deduplication (allowing two‑identifier matches where appropriate), standardized data elements, and built preventative controls into its new systems. The tools improved transparency with dashboards for stakeholders, empowered developers to act on data issues, and put the agency on track to reduce records from millions toward its sub‑3 million target while remaining cost‑neutral.

Idaho Transportation Department

Randi Bristol-Hogue

DMV Transformation Program Manager