Project Title: Data Cleaning for Multiple Database Sources
We have purchased a CRM system to manage our sales and marketing functions.
However we have in excess of 100 different data files containing client and prospect information. This data needs to be amalgamated, cleaned and consolidated before assessment and finally uploading into the CRM.
Firstly you will have to merge all the Excel spreadsheets which may give you in excess about 200,000 lines of data.
Once this is complete you have to apply the following methods:-
– Identifying incomplete information – auto replacing and highlighting anomalies
– Remove duplicate records
– Fixing inaccurate data – using predefined rules
– Removing redundant information as defined by the business
Will you be able to handle the cleaning for the large amount of data?
For similar work requirements feel free to email us on firstname.lastname@example.org.