Skip to main content

Experian Pandora

Data standardization and transformation

Experian Pandora’s data standardization functionality allows you to standardize data formats, regardless of data type. It can also transform and manipulate data with hundreds of functions that are built into the Experian Pandora platform, or you can build your own transformation rules that are relevant to your business. 

With the ability to instantly prototype data, users are able to confirm that the transformations that they are trying to make are truly what they’d like to apply to their dataset without the need for writing scripts or code. 

The video below is a brief demonstration of Experian Pandora’s standardization and transformation features. 

Hi, I’m Rishi Patel from Experian Data Quality. Today I’m going to take you through the data transformation and standardization capabilities of Experian Pandora.

 

So we’re looking at the interface of the tool, and we’ve already loaded some data that sits in the repository under it. We’re going to briefly show how we can improve the quality of the data by potentially transforming it and standardizing it, and instantly see the results that we get from it.

 

Let’s look at the previous customer table and focus in on the telephone number. Here we can see we have telephone numbers of different formats containing parenthesis and hyphens. We can start by looking at how many formats we have in this column. Right click over here, and instantly format this data. We can see that we have 80 groups or formats for this particular table.

 

In order to standardize this information, I’ll start off by cleaning and removing the noise. I can insert a column over here; select the data cleanse function, and remove the noise. I can see the results in here instantly, and that is part of our prototyping. I can take this a step further and edit this transformation. Go to transformations, edit…and within our expression editor we have a whole host of functions here to transform and manipulate data.

 

The next thing I want to do is add in some dial code information. Within this table we do have the countries, so I can search for any country function and convert that country to a dial code. I’ll take that as an input, I’ve got the country name, and I’ll select the dial code. What I can then do is concatenate the information together. Taking that dial code, add in a hyphen, and our cleansed number. Now if you go ahead and profile that transformation, we can now see that we’re left with 7 groups, the dominant being a +44, most likely in the UK.

 

That was a brief demonstration, but I hope it gives you a good idea of the standardization and transformation capabilities of Experian Pandora. 

Ready to see Experian Pandora in action? Contact us

Copyright ©, 2014-2017. All rights reserved.

125 Summer St Ste 1910, Boston MA 02110-1615, US