Category: Projects

Database Cleaning

Project Title: Data Cleaning of Multiple Spreadsheets Project Description: I have multiple spreadsheets containing about 20,000 items or entries each with about 20-50 attributes. There’s no consistency with format or anything. I need this cleaned up into one concise sheet, completely organized easy filter / query / search. The spreadsheet need to look professional and not be cumbersome in addition to the data being completely…

Project Title: Event Planners Database Cleansing & Matching Project Description: Hello!! I have two databases containing data of Event Planners. One of it is the master database which contains data from whole country while other database contain the data from 10 states. The issue is that the smaller database is incomplete and unclean and so, I need you to clean the database by matching it…

Project Title: Data Cleansing for Insurance Company Project Description: Our company database holds details on over 3 million insurance customers. The project entails cleansing data errors, ensuring that the database is correct, complete and issues related with legacy data are fixed to make sure that it provides a unified view of each customer. The details of each customer needs to be cleansed, standardized, verified and…

Project Title: CRM Data Cleaning & Merging Project Description: Through various acquisitions, we found ourselves with multiple CRM-like platforms and other integrated data systems. Each division of our organization has their own data-set and their own processes which results in a lot of company-wide data duplication and outdated or incomplete information. Our goal is to push all the disparate data over to single CRM, making…

Project Title: Customer Database Cleansing Project Description: We are a multiple-event, specialty trade show organizer need to refine and update customer information in our database. Over multiple years, we built a large database of customers and need to add demographic information and update old information. We need to call retail locations and capture primary business categories, store buyer name, email address, and update any incorrect…