CASE HISTORY: A COMPLETE GUIDE

Home Success Stories Finance Solutions Company

A Leading Finance Solutions Company Gets Data Cleansing, Data Verification and Data Mining Services from DataPlusValue

About The Client

The Client headquarter is located in Australia and specializing in offering the database of finance / banking and mortgage service providers. They are involved in the database building service since 2010 and also help in operating the finance, banking and mortgage related companies.

They provide data on funding history, investment activities, and acquisition trends.

About The Project

The client was looking for data cleansing and data mining services to cleanse, verify, append and remove the duplicate records from the existing database. Most of them records were related to Finance, Banking and Mortgage related companies.

They contacted us by explaining that existing database has lack of consistency and information needs to be verified against each company along with filling out the missing information. The datasets are from across the globe majorly from the America, Europe, Australia, Asia etc.

In addition, all the entries were to be standardized to ensure uniformity across the business.

About the Project’s Guideline

The Scope of data cleaning work:-

  • Checking, updating and verifying the existing raw data from internet.
  • Classifying company industries Like Finance, Banking, Mortgage etc.
  • Enriching company information like addresses, websites, phone numbers and email address.
  • Removing the records that are outdated or which fall within the categories provided like Non-profit, Retail & ecommerce, Government Body etc.

The Scope of Data Standardize and De-Duplicate:-

  • Expending abbreviations when required.
  • Checking for proper capitalization in Company Name e.g Hcl = HCL, Exxonmobil = ExxonMobil
  • Initials should have a proper format e.g. (John W. Mannion)
  • Suffix the proper salutation e.g. Male (Mr.), Female (Ms.)
  • Removing duplicate items from the database and merging the two identical records into single one.

About The Challenges We Faced

The big challenge we encountered during the deliverance of data was to carry out extensive online search to find, verify and update the correct details of each records in the provided database. The details were not in their respective columns that needed to be corrected.

How DataPlusValue Executed The Project

We discussed the project requirement on the conference call with the client. The client provided us a the list of the companies in the CSV file format with little information of the companies and the final verified updated information was to be filled in same CSV format so that it can be imported in CRM directly.

Our data cleansing specialists did a wonderful job and processed the data effectively and accurately by doing the following steps:-

  • Removed or extracted those companies in separate worksheet which were no longer active.
  • For those companies that were redirected to a different website, our data cleansing professionals marked those records in excel for the client’ review.
  • For the rest of the lists, our data cleansing specialists verified that the companies are still in business and we updated the information like phone, address, website, contact, contact title and contact email address, etc.
  • We marked the information of the companies which our data cleansing professionals were not able to verify.
  • We converted the abbreviated form in full form such as:-
    • State Names – NY – New York, OH – Ohio etc.
    • Address – Ave. – Avenue, Rd – Road, Hwy - Highway etc.

We also helped client get rid of several duplicate entries that were available in the database and thus reduced the cost of data management.

What Were The Results?

At the end of the project, we delivered exceptionally efficient and 100% accurate data cleansing and data mining services comprising over 2,50,000 records focusing on accuracy, uniformity, comprehensiveness, and consistency.

The client saved 70% in overhead costs by choosing DataPlusValue as an outsourcing data cleansing partner. In addition, delegating this important task allowed them to keep their in-house teams focused on growth-oriented tasks. DataPlusValue also got the benefit of gaining experience in Database Building of Finance & Banking related industry.

The client was happy with our services and has chosen to keep us on-board to continuing insuring the integrity of their database. At the end, our uncompromised service deliverance made the client realize that the decision of outsourcing data cleansing services to us was nice one.

If you are looking for the best data cleansing company that could offer reliable and timely data cleansing and data mining services, contact us.