So how do you create a score? In this example we use 11 rules that are applied to a record. Each rule is weighted according to importance (this is specific to your needs). It does not matter whether this is B2B or B2C data, product data, supply chain data or financial data; the principle is the same.
You can create whatever rules are important to you. It may be something simple as missing emails or a valid address; or something more complex as checking the sum of order items equalling the total order value.
There are many uses for this score; one is to create a distribution chart of the scores. It could look something like this:
The graph will depend on the quality of your data, but in most cases it will be bumpy with a bias towards the right reflecting the quality of the data. After you clean the data, it may look like this:
Now there is a definitive bias towards the right (100%) as the quality has improved.
Using record scoring can be very beneficial. Once your rules have been programmed, reports can be created to constantly keep track of the quality. You can drill down on the chart and see the data quality for different teams, functions, products, territories - the possibilities are endless. Just having the score opens up the ability to perform a wide range of analysis.
If you would like further information on Record Scoring then contact Acuate:
|Telephone:||+44 (0) 20 8799 0360|