One of the primary areas of focus here at Qbase is data, specifically on what is known as "data hygiene" — literally turning dirty data into clean data. When we receive data from clients requesting data hygiene either as a standalone process or as just one step in a larger project (such as a data migration or integration project), the first thing we always do is examine the data (typically this involves using our organic software, such as Qbase Data Discovery™). We then process the data files, which almost always results in a significant improvement to the data. Some of the standard processes we perform to enrich and improve our clients' data include:
- De-duping records to remove or correct duplicate records
- Distinguishing an individual record (a person) from a business
- Parsing person names into standard fields; in other words, identifying and breaking out the title (Adm.), first name, last name, suffix (Jr.), and so on
- Identifying invalid or undeliverable addresses and correcting or updating these addresses where possible
- Parsing address components into standard fields; again, breaking out the house number, the pre-directional if used (East), street name, the suffix (NW), and all of that
If you have dirty data, Qbase has an unmatched data hygiene system to clean your data, which is the first, best step for any data-related project.
No comments:
Post a Comment