Find Jobs
Hire Freelancers

Analyze Order Information

$10-30 USD

Terminado
Publicado hace casi 9 años

$10-30 USD

Pagado a la entrega
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.
ID del proyecto: 7526709

Información sobre el proyecto

14 propuestas
Proyecto remoto
Activo hace 9 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
5,0 (1 comentario)
0,0
0,0
14 freelancers están ofertando un promedio de $26 USD por este trabajo
Avatar del usuario
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 en 1 día
5,0 (277 comentarios)
7,7
7,7
Avatar del usuario
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 en 2 días
4,9 (341 comentarios)
6,9
6,9
Avatar del usuario
I am interested. can we discuss? .
$50 USD en 1 día
5,0 (36 comentarios)
4,9
4,9
Avatar del usuario
Hello Sir , I am looking forward to do this job.. will you elaborate little more what exactly your out put. thank you
$30 USD en 1 día
5,0 (6 comentarios)
2,2
2,2
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
2,0
2,0
Avatar del usuario
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 en 1 día
5,0 (6 comentarios)
2,1
2,1
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$10 USD en 1 día
4,9 (2 comentarios)
0,1
0,1
Avatar del usuario
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 en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
somerville, United States
4,9
251
Forma de pago verificada
Miembro desde nov 5, 2003

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.