Find Jobs
Hire Freelancers

Analyze Order Information

$10-30 USD

Concluído
Publicado há quase 9 anos

$10-30 USD

Pago na 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 do Projeto: 7526709

Sobre o projeto

14 propostas
Projeto remoto
Ativo há 9 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
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 em 1 dia
5,0 (1 avaliação)
0,0
0,0
14 freelancers estão ofertando em média $26 USD for esse trabalho
Avatar do Usuário
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 em 1 dia
5,0 (277 avaliações)
7,7
7,7
Avatar do Usuário
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 em 2 dias
4,9 (341 avaliações)
6,9
6,9
Avatar do Usuário
I am interested. can we discuss? .
$50 USD em 1 dia
5,0 (36 avaliações)
4,9
4,9
Avatar do Usuário
Hello Sir , I am looking forward to do this job.. will you elaborate little more what exactly your out put. thank you
$30 USD em 1 dia
5,0 (6 avaliações)
2,2
2,2
Avatar do Usuário
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 em 1 dia
5,0 (2 avaliações)
2,0
2,0
Avatar do Usuário
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 em 1 dia
5,0 (6 avaliações)
2,1
2,1
Avatar do Usuário
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 em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
A proposal has not yet been provided
$10 USD em 1 dia
4,9 (2 avaliações)
0,1
0,1
Avatar do Usuário
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 em 7 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
somerville, United States
4,9
251
Método de pagamento verificado
Membro desde nov. 5, 2003

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.