In a typical
organization, most databases are built with data keyed in by different
people. For example, a CRM database will be updated by several sales
reps and each of these reps will have his/her own way of entering
data. It can be ‘Road’ for some, while others may prefer ‘Rd’.
Similarly, it can be Drive or Dr, and CA or California. Such variations slowly corrupt the sanity of
the data and can make it unsuitable for reliable analysis & reporting.
The situation is made all the more worse if the data is aggregated
from multiple data sources where each system follows its own
conventions and processes. To make such data uniform and
credible, periodic data cleansing becomes necessary. Only clean,
sanitized data can provide you reliable inferences when analyzed.
Zoho
Reports now supports a Find & Replace function which makes data
cleansing easy and which results in keeping your data clean. For using
this function, right-click on a column name and choose the Find and Replace option. (you can also invoke the Find and Replace option under the More Options menu too).
Enter the relevant data for Find what and Replace with fields.
All the matching data in the column will get replaced.
Other than with text values as shown above, the Find and Replace also works with date & numerical values. Say a sales rep mistakenly entered data with the year as 2007 instead of 2008 (a pretty common data entry error, especially when a new year arrives), you can easily cleanse such data too.
Hope you like the Find and Replace function useful for your data cleansing job. Try it now in Zoho Reports & let us know your feedback.
