Skip to main content

Predictive data quality analytics for Experian Pandora

EXPERIAN PANDORA V4.0 RELEASE

Derek Munro 3 minute read Data quality

As well as usability and performance enhancements, the latest version of Experian Pandora brings significant new capabilities such as the user-configurable outliers report, which automatically highlights “unusual” data, and reference table functionality which enables the licensed re-use of data for cleansing and enrichment.

Predictive data quality analytics

Experian Pandora predicts what could be wrong with your data and provides hints to analysts when it finds data values which are unusual with respect to nearby/related data.

Experian Pandora has always been able to derive implicit rules in data and highlight the inconsistencies. Now, the outliers report compares the profile of the data in each column with a normal distribution curve and highlights any values which are statistically unusual, saving the analyst time and often predicting the problems before anyone knew they were there.

 

Experian Pandora Outliers Report Experian Pandora Outliers Report

 

Characteristics analysed include frequency, format, length and data type. Analysts can interactively browse through all associated data regardless of data volumes.

In this example, Experian Pandora has found an integer in the forename column, some non-numeric characters in the price column, and a missing record by virtue of the fact that there is a missing “order id” in what would otherwise be a generated sequential key.

The outliers report highlights when records are missing by analysing patterns in the records that are present.

It’s relatively easy to validate the values in a table or to find when values in a column are missing, but how do you spot an entire missing record? We believe this ground-breaking capability will allow our customers to uncover broken processes as well as cases of internal fraud.

Experian Pandora V4.0 release summary

Analysis

  • User-configurable outliers report with instant drill to unusual records
  • Identification of un-displayable (invisible) characters

Transformation

  • Consolidated “super functions”
  • Revised and new sample domains (e.g. UK & US towns)

Load

  • Faster loads, executed in parallel
  • Choose which columns and records to load
  • File-system triggers and auto-delete of files

Quality

  • Enhanced data quality dashboard has more navigation options
  • Reference table packaging and usage (cleansing & enrichment)

Usability

  • More ergonomic (like Win 8/IOS 7)
  • Less menus & simpler dialogues
  • Web access to pages/reports

Administration

  • Database storage reduced by 10% for new Experian Pandora repositories
  • Server settings configurable from the GUI

Comments

Copyright ©, 2014-2017. All rights reserved.

Experian Ltd is authorised and regulated by the Financial Conduct Authority. Experian Ltd is registered in England and Wales under company registration number 653331.
Registered office address: The Sir John Peace Building, Experian Way, NG2 Business Park, Nottingham NG80 1ZZ.