Закрыт

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

Навыки: Excel, Data Analysis

О клиенте:
( 42 отзыв(-а, -ов) ) Tyldesley, Manchester, United Kingdom

ID проекта: #35862969

111 фрилансеров(-а) готовы выполнить эту работу в среднем за $27

daniyal3214

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 Больше

$20 USD за 1 день
(202 отзывов(-а))
7.1
TheScorpion93

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 Больше

$50 USD за 1 день
(97 отзывов(-а))
6.7
professional800

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 Больше

$35 USD за 1 день
(110 отзывов(-а))
5.9
konanhenry1111

⭐⭐⭐⭐⭐⭐ 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 за 2 дней(-я)
(72 отзывов(-а))
5.7
ammar3215

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 за 1 день
(9 отзывов(-а))
4.7
raghibmth

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 Больше

$20 USD за 1 день
(66 отзывов(-а))
4.9
muradeltaher

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 Больше

$30 USD за 1 день
(74 отзывов(-а))
5.0
Peefect

sure , please share the file. thanks

$39 USD за 1 день
(59 отзывов(-а))
4.9
monicawriter99

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 Больше

$33 USD за 2 дней(-я)
(17 отзывов(-а))
4.6
raheelakhurshid

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 Больше

$20 USD за 2 дней(-я)
(9 отзывов(-а))
3.9
Sussywells

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 за 7 дней(-я)
(11 отзывов(-а))
4.0
anowarbss

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 за 1 день
(27 отзывов(-а))
3.9
azizva

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 за 1 день
(21 отзывов(-а))
3.9
umairnoor32

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 Больше

$20 USD за 1 день
(35 отзывов(-а))
3.8
jojimathew571

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 Больше

$30 USD за 3 дней(-я)
(31 отзывов(-а))
4.0
yashikajain28

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 Больше

$30 USD за 2 дней(-я)
(14 отзывов(-а))
3.4
shahzaibyounis77

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 за 1 день
(1 отзыв)
3.5
nawazwasif

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 Больше

$100 USD за 3 дней(-я)
(3 отзывов(-а))
3.3
AhDardear

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 Больше

$20 USD за 2 дней(-я)
(10 отзывов(-а))
3.4
yousrymohamed11

Hi, I will analyze the 3 datasets simultaneously, and create a dashboard for each one, I can do this Job, data analysis, data cleaning, data visualization, building interactive dashboards with slicers and getting ins Больше

$16 USD за 1 день
(5 отзывов(-а))
3.2