KPI Data Integrity Depends on 5 Rs

You depend on the quality of data and informationyou only what the "squeaky wheels" have to say,
to provide a stable foundation for your decisiondrowning out the valid and important and balancing
making. Decision making often involves respondingviews of the "well oiled wheels". Squeaky wheels,
to something, so you need your data to validlyvolunteer surveys and easiest-ones-to-measure
describe what you are responding to so that youare examples of data sources unlikely to give you
choose the right responses.accurate enough data.
Whether your data is quantitative (based on--> Define your population carefully, and select
numbers) or qualitative (based on perceptions), it'srandom samples to avoid bias.
integrity depends on 5 widely recognised qualities.Readable
RelevantUnless the data you collect is clearly defined,
Make sure the data you have selected is directlylegibly presented, easy to organise for analysis,
appropriate to the purpose of the performancemakes sense to its users and can be easily
measure you selected it for. Be careful of datainterpreted and understood by them, it won't
that seems interesting: it doesn't mean it ismatter how relevant, representative or reliable it
relevant. Trying to gather more data than youis. It just won't be usable. The numbers need to
really need, especially in surveys, can negativelybe in a format you can use.
impact on the other dimensions of data integrity--> Design your data collection forms and
(below).questionnaires carefully to give you the data in
--> Be ruthless and collect only the data you havethe format your analysis needs.
a use for in monitoring and diagnosingRealistic
performance.Trade off the degree to which your data is
Reliablerelevant, representative, reliable and readable with
Collect enough data and collect it carefully tothe level of resources you will need to invest to
ensure that it is precise enough (especially if it ismake it so. Make sure the value you get from
an estimate based on a sample) and continues tousing your data is greater than the effort you
be precise enough as you collect it over time.invested in getting it. Beware of the temptation to
Would you rely on one day's rainfall to drawinvest in sophisticated automatic data capture
conclusions about annual rainfall? What about fivesystems (such as bar-coding and voice recognition
days' rainfall? How many days rainfall would yousoftware) - if you haven't got a simple manual
need to get a precise enough estimate of annualsystem working well first, then these systems
rainfall? And what would this depend on?are likely to cost you much, much more than the
--> Design your sample sizes to give the reliabilitysavings they appear to promise.
you need. Don't guess.--> Pilot test your data collection processes to be
Representativesure they will deliver cost-effective data.
It is important that the data you collect areTAKING ACTION:
observable events or characteristics that describeIf you have a performance measure or KPI that
the full scope of what your performancetriggers more debate about data quality than it
measure is supposed to be measuring. Thisdoes about performance levels, then use the 5 Rs
means that it is unbiased, or accurate enough.of data integrity to work out where the data
The last thing you need is for your data to tellcollection process can be improved.