In Progress

Analysis of variation in 3 datasets

Experienced analyst required to undertake detailed analysis and comparison between 3 sources of similar data (each containing 6500-7000 records). All 3 sources are reporting the same data but have slight variation. All 3 sources have up to approx. 10 corresponding fields.

The scope of this work is as follows:

1) In source 1 and source 2 – find duplicates (and possible duplicates where unique records are very similar but may have small variation on one field. Ie: you will need to concatenate or use a similar method to identify close matches)

2) Compare source 1 against source 2 – identify unique records in each (2 way comparison)

3) Compare source 1 and 2 against source 3. Source 3 has been previously ‘cleaned’ but data is out of date.

a. Identify which records in source 1 and 2 are unique compared to source

4) These tasks need to summarised into a clear presentation, summarising the types of data variation. The specific examples of each variation need to easily identified within the data itself or as a separate excel file (or similar)

Excellent communication in English and necessary skills to present findings in a format for executive level presentation is a requirement. The task is not urgent but it would be preferable that the outcomes are delivered in a few days.

There is one additional requirement -
Source 3 contains a field that needs to be assigned to the corresponding records in Source 1 and 2 where there is an exact match

Skills: Data Entry, Data Mining, Data Processing, Excel, SPSS Statistics

See more: Using R and TreePlan, perform software management tasks and answer questions about decision trees for these questions., write a string with at least 3 words check out the examples of strings above, seo expert guide - keyword analysis part 3, analysis of variance, how to compare data sets, compare variation two data sets, comparing two data sets for similarity, anova, statistical comparison of two data sets excel, comparing two sets of data t test, comparing two sets of data for statistical significance, data entry, power point, data processing, excel, data mining, spss statistics, 3 year experienced php developer walkin bangalore, 3 weaknesses for job interview examples, php experienced tasks

About the Employer:
( 0 reviews ) Spain

Project ID: #17246343

Awarded to:


hello i am keen to do this project for you, please share with me the source data, i have done data analysis projects in the past and keen to do this one as well for you. I am well versed with many data analysis and More

€222 EUR in 5 days
(3 Reviews)

11 freelancers are bidding on average €104 for this job

€155 EUR in 3 days
(30 Reviews)

1. Expert in data analysis, and also an expert in English communication , Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many das More

€150 EUR in 3 days
(47 Reviews)
€111 EUR in 2 days
(15 Reviews)
€50 EUR in 1 day
(25 Reviews)

Hi, As per given details Its Excel related data entry task. I have great experience in excel related work. Also, I am good in lead generation, internet research, market research, data entry, data processing and all k More

€60 EUR in 3 days
(35 Reviews)

Dear SIr / Mam, I have gone through your project requirement and willing to do it as i am an excel as well as statistical analyst having hands on expertise on data analysis and management. I will deliver your proje More

€150 EUR in 3 days
(12 Reviews)

Hello, Thank you for your job posting. Your job post has caught my attention because I'm a data entry specialist. I have comprehensive experience in Copy Typing, Data Entry, Data Processing, and Excel. I’m a hard wor More

€100 EUR in 5 days
(1 Review)

Hi, I am Master's in Maths and Statistics, having 7+ years of experience in SPSS, Excel and R- Programme. I have worked as an analyst in Department of statistics in my country for 4 years. Moreover, I provide my servi More

€30 EUR in 3 days
(0 Reviews)
€80 EUR in 5 days
(0 Reviews)
€39 EUR in 3 days
(0 Reviews)