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

Kemahiran: Excel, Data Analysis

Tentang Klien:
( 42 ulasan ) Tyldesley, Manchester, United Kingdom

ID Projek: #35862969

111 pekerja bebas membida secara purata $27 untuk pekerjaan ini


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 Lagi

$20 USD dalam sehari
(202 Ulasan)

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 Lagi

$50 USD dalam sehari
(97 Ulasan)

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 Lagi

$35 USD dalam sehari
(110 Ulasan)

⭐⭐⭐⭐⭐⭐ 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 dalam 2 hari
(72 Ulasan)

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 dalam sehari
(9 Ulasan)

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 Lagi

$20 USD dalam sehari
(66 Ulasan)

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 Lagi

$30 USD dalam sehari
(74 Ulasan)

sure , please share the file. thanks

$39 USD dalam sehari
(59 Ulasan)

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 Lagi

$33 USD dalam 2 hari
(17 Ulasan)

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 Lagi

$20 USD dalam 2 hari
(9 Ulasan)

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 dalam 7 hari
(11 Ulasan)

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 dalam sehari
(27 Ulasan)

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 dalam sehari
(21 Ulasan)

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 Lagi

$20 USD dalam sehari
(35 Ulasan)

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 Lagi

$30 USD dalam 3 hari
(31 Ulasan)

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 Lagi

$30 USD dalam 2 hari
(14 Ulasan)

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 dalam sehari
(1 Ulasan)

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 Lagi

$100 USD dalam 3 hari
(3 Ulasan)

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 Lagi

$20 USD dalam 2 hari
(10 Ulasan)

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 Lagi

$16 USD dalam sehari
(5 Ulasan)