Dataset analysis in excel

Job Description:

I have an excel workbook that contains 3 datasets (1 per sheet)

1) an extract from finance system

2) an extract from online system

3) an extract from reporting system

The datasets include things like order number, line number, qty, SKU etc and cover a period from may 2022 to Jan 2023. There's about 5000 rows of data in each sheet

I need help analysing the differences between the order values of each dataset. In theory, the order values should be the same across all three eg order number 174 = £203. But that's not always the case.

I would like the order qty and values compared across all three datasets. Where there is a difference in qty or value then I need to know which line / SKU those differences are on.

I would also like a summary provided. Something explaining how many orders there are, how many match across all three, how many match on Two etc. Like a high level summary of the findings

Skills: Excel, Data Analysis

About the Client:
( 42 reviews ) Tyldesley, Manchester, United Kingdom

Project ID: #35862969

112 freelancers are bidding on average $27 for this job


Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Auto More

$20 USD in 1 day
(199 Reviews)

Hi there, I’ve read your brief and I’m pretty confident that I'll be able to help you to analyze the data on those three sheets and visualize them on Excel/Tableau if you want. I've +7 years of experience in web scrap More

$50 USD in 1 day
(96 Reviews)

Greetings Thanks for checking my proposal. I worked as Manager Accounts and I have done same task many times to Reconcile my reports. I can start your project immediately. I have more than decade of experience as Manag More

$35 USD in 1 day
(107 Reviews)

⭐⭐⭐⭐⭐⭐ I can start doing it right now ⭐⭐⭐⭐⭐⭐ if u check my reviws u will find me did the same project before also I have all these skills Exceland Data Analysis trust me ✌️ I can do it very well

$20 USD in 2 days
(58 Reviews)

I will calculate difference between the order value and will analyze your data, I am expert in Advanced Excel Formulas and VBA. Please ping me to discuss in detail Portfolio: Regards, More

$20 USD in 1 day
(120 Reviews)

I am expert in excel and data analysis with 10+ years of experience , I can help you out in analysing the difference between order values of each dataset and I can also provide the summary of it , kindly message me

$30 USD in 1 day
(9 Reviews)

Sir, Understand work well... Ready to start work now.. I have Clearly read description number of times and understand the work better... I have clearly read and understood the description of this project. I'm confi More

$20 USD in 1 day
(59 Reviews)

Hi My Name Is Murad and I’d like to be considered for your position. I Provide certain services : 1. MS Office 2. Web Research 3. Data Entry 4. CorelDraw ,Photoshop And Illustrator 5. eCommerce , Amazon , ebay , Sho More

$30 USD in 1 day
(74 Reviews)

sure , please share the file. thanks

$39 USD in 1 day
(57 Reviews)

Hello employer, I hold a Master's degree in Economics and statistics making me a suitable person for your project " Dataset analysis in excel ". I have more than 3 years of professional experience in statistical analy More

$33 USD in 2 days
(17 Reviews)

I CAN DO THE DATA ANALYSIS FOR YOU! In terms of Analysis task, I provide highest quality services in the following areas of Statistics and E-commerce. So get your job done here! I can do: Survey data analysis, Analysis More

$20 USD in 2 days
(9 Reviews)

Hello there, I qualify for your project since it is among my field of expertise, please consider my bid as we come to terms in a chat. Thanks

$20 USD in 7 days
(11 Reviews)

Hi, There I will compare your 3 files within 1 hour using advance Formulas and give you better summary can you share me file please I am ready to start now Thanks Anowar

$10 USD in 1 day
(27 Reviews)

Hello sir I am data analyst. I have strong command on Excel, python, R programming, SPSS, power BI and tableau. I have experience of 3 years. I can handle your all 3 data sets. Please inbox for discussion

$30 USD in 1 day
(19 Reviews)

Hi, I am proficient with MS Excel formulas, functions and VBA development. I have read the description and found the job really interesting to work on. I feel very confident about being able to complete the work in l More

$30 USD in 3 days
(31 Reviews)

Hello Sir, I have read your instructions and I can do it efficiently according to your requirements. Please give me this project and get 100% extra ordinary work with unlimited revisions even after completion of the w More

$20 USD in 1 day
(29 Reviews)

Hi sir, I am an audit associate and perfectly suited for this task. I can perform the analysis as required and will ensure your 100% satisfaction. Feel free to contact me anytime.

$25 USD in 1 day
(1 Review)

HELLO, I can start working on your project right now. I have read all your requirements carefully. I can provide a high level summary of the data analysis, compare the data values and highlight the differences. I have More

$30 USD in 2 days
(13 Reviews)

Hi there, I am an experienced freelancer and assure you a quality work. I am not sure about number of columns in each row so my bid is estimated. But if there is less data in each row, I will finish it in reasonable ti More

$100 USD in 3 days
(3 Reviews)

Dear, I have reviewed your Excel data analysis requirements carfully. I believe I am your perfect candidate and it's my pleasure to apply and offer my services. I am a certified data analyst with 10 years of experie More

$20 USD in 2 days
(10 Reviews)