Find Jobs
Hire Freelancers

Analyze Order Information

$10-30 USD

Completed
Posted about 9 years ago

$10-30 USD

Paid on delivery
You are provided a set of orders Convert orders to tables "orders" and "order details" Delete all shipping costs from "order details" Remove all orders from the data with order total>$100 Create a list of all of the skus (items) ordered by the number of orders the skus appears in. (in SQL this is count() and groupby() or use whatever other method you like) Create a column in the spreadsheet (or use a db table) for each of the top 100 sku. See line 6 in the sample spreadsheet. Create a row for each order (see column B in spreadsheet). If a sku in the order is among the "most common", place the quantity in the correct column (example G7 in spreadsheet). If a sku in the order is not in the "most common", then simply put "true" in the last column "additional skus". Then rerun the script using the top 50 skus only and the top 200 skus only. Your work product is three spreadsheets or tables that look like the sample with 50, 100, and 200 skus as columns.
Project ID: 7526709

About the project

14 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I have been working as an IT Executive since 2013 and experiences in analyzing order information using MYSQL. I would like to get opportunity for this project. Please kindly select me.
$10 USD in 1 day
5.0 (1 review)
0.0
0.0
14 freelancers are bidding on average $26 USD for this job
User Avatar
Hello, I have read and understood the project. I am ready to start the work from anytime. I assure you the work accuracy and timely delivery of project. About Me: I have vast experience of data entry, Research, web scraping & copy/paste projects as I am working from past 10 years in data processing field. I will be very happy if you give us an opportunity work on your project. Please contact. Thanks, Swapnil
$35 USD in 1 day
5.0 (277 reviews)
7.7
7.7
User Avatar
Dear Sir I can accomplish the job for you. Kindly contact me for further details. I have previously carried out a number of excel related projects. Thanks Tonmoy Roy
$30 USD in 2 days
4.9 (341 reviews)
6.9
6.9
User Avatar
I am interested. can we discuss? .
$50 USD in 1 day
5.0 (36 reviews)
4.9
4.9
User Avatar
Hello Sir , I am looking forward to do this job.. will you elaborate little more what exactly your out put. thank you
$30 USD in 1 day
5.0 (6 reviews)
2.2
2.2
User Avatar
Hi! I have 3 good reasons to help you decide on choosing me: A= ACTIVE FREELANCER. I have the right motivation and the right intention to do this task. I am an energetic and positive-minded person. So, I think I could really help you in your most convenient time. C= CREDIBLE FREELANCER. I've been here at Freelancer for three years. I can give you my other credentials like my facebook and email to verify that I am really a 100% real person. You can also check the different reviews I have at freelancer. I have made quality projects. E=EFFICIENT FREELANCER. I'm AN AB PHILOSOPHY GRADUATE with minor in English. I speak fluent English. It is very easy to communicate with me. I had also several experiences doing web searching tasks, being a partime virtual assistant, copywriting, blog writing, SEO writing, Academic writing, DATA ENTRY, content writing, TRANSCRIBING, Website design and developing, Software solutions, English Tutor, Translator and “YOU NAME IT TASKS”. With these good reasons plus my good character, I think you already found that right freelancer for you. Please send me a message as soon as you read this. I hope to work with you soon. Best regards, JURRY
$30 USD in 1 day
5.0 (2 reviews)
2.0
2.0
User Avatar
Hi, I can do this job efficiently. I have more than 10 years of experience in this filed. I am flexible about working time and money. I believe work speaks better than words. Hope to have a positive response. Good day,
$30 USD in 1 day
5.0 (6 reviews)
2.1
2.1
User Avatar
I can most certainly help you create a spreadsheet for all your orders. My purpose for applying is to fulfill your needs to complete this project
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$10 USD in 1 day
4.9 (2 reviews)
0.1
0.1
User Avatar
Dear sir I am a professional data entry operator. I am able to do this if you instruction me . I am a heard worker and honest . If you award me this project I will deliver you before deadline . Regards TASLIMA
$25 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am experienced with this kind of work. 3- years professional experience in providing all kind of reports, very similar to the one requested here. Using vlookups and hlookups and conversion tools in excel, I can easily sort out your data exactly the way you want. I can finish this in 4 hours max. Additionally: In example spreadsheet shipping is counted together in "Order total", and below is stated "delete/ignore shipping". Should shipping be counted in order total or not? Either way there won't be any problem. [If a sku in the order is not in the "most common", then simply put "true" in the last column "additional skus".] - simply speaking, if order have more skus than showed in the table, last column shows "true" When counting "top skus", we don't look at the quantity ordered, just amount of orders sku is showing on, correct? That would be all. With fast reaction I can still provide all data today. With best regards, Adam Jankowski
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am expert in excel and SQL and have worked on various data sets. I am ready to be hired . I will deliver this work with 100% accuracy.
$28 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Client, Good Evening! I kindly request you to consider me for this opportunity.I will deliver the results on time without any errors. Thanks Uma Swaminathan
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I've got 8 years of experience in working with SQL and I'm confident I can do this for you quickly. I'm new to freelancer.com so don't take my experience. I'm keen on wining a project so I can gain experience so please contact me on char if you'd like to discuss further. :)
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
somerville, United States
4.9
251
Payment method verified
Member since Nov 5, 2003

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.