Completado

MySQL weekly moving average query on sales data

From a mysql table orders_history, calculate the weekly moving average. I would also like be able to calculate a 4 week and a 12 week moving average.

Use mysql to calculate.

I have simple table called orders_hjstory that contains sales transactional data.

Want previous experience in similar project.

Will provide sample table schema and data on request.

The current data i have contains over 1million rows so the query needs to be optimised.

I have successfully written a query to give me the weekly average, now I would like the moving average

Habilidades: Big Data Sales, MySQL, Arquitectura de software

Ver más: sql moving average query, postgresql moving average, sql server 2012 rolling average, mysql moving average, moving average sql oracle, sql 30-day moving average, redshift rolling average, 7 day moving average in sql, Build web page showing rainfall data from mysql db, written test of data entry operator of idea project will be held on 6 feb 16 in tejgaon college dhaka download admit card from e, java i want a write a desktop application that requests data from a website, mysql exponential moving average, write search query using data structures java, mysql function moving average, magento mysql query sales

Información del empleador:
( 40 comentarios ) Mount Waverley, Australia

Nº del proyecto: #14916693

Adjudicado a:

hlozada

Currently working with Forex (Metatrader 4) and able to perform the query you require (Moving average) and other calculations like this. I have experience with data mining and automation. Stay tuned, I'm still workin Más

$155 AUD en 3 días
(6 comentarios)
0.0

29 freelancers están ofertando el promedio de $143 para este trabajo

Webzone12

I am SOFTWARE ENGINEER and running a SOFTWARE HOUSE we have skills in ur demand languages,our rates r less It will better for us for good start I am waiting for your response Thankyou Stay tuned, I'm still working o Más

$100 AUD en 3 días
(0 comentarios)
0.0
androidc

Hi, I can calculate Average weekly, monthly and yearly also. I have 7 year experience in MySQL. Relevant Skills and Experience [login to view URL] [login to view URL] [login to view URL] http://socialterminal Más

$147 AUD en 3 días
(41 comentarios)
0.0
$111 AUD en 3 días
(5 comentarios)
0.0
mahmoudgamal008

I have more than 5 years of professional and practical experience in MySQL, and database development. Relevant Skills and Experience I wrote hundreds and hundreds of SQL queries. I have more than 1800 answers in Stack Más

$150 AUD en 1 día
(37 comentarios)
0.0
partsgr12

Hi, I am database developer with mysql experience. I propose to work with you. You have any queries or specific requirements, Please let me know. Regards Sankar Relevant Skills and Experience I am database develo Más

$130 AUD en 3 días
(7 comentarios)
0.0
shennz

hi, Ready to start right now. I can provide quality and standard work. Experienced in MySQL and using aggregate functions. Please PM me for more details. Thank you

$35 AUD en 0 días
(11 comentarios)
0.0
$155 AUD en 3 días
(0 comentarios)
0.0
caigentao

Proposed Milestones $155 AUD - hi。

$155 AUD en 3 días
(0 comentarios)
0.0
tuanthanhle

A proposal has not yet been provided

$132 AUD en 2 días
(7 comentarios)
0.0
bhawin91

A proposal has not yet been provided

$222 AUD en 3 días
(18 comentarios)
0.0
vicboyvera

I have applied WMA in stocks for another client. I am skilled in PHP, JavaScript, MySQL. I am quite keen in making optimizations as well. I can do the job, mate. Relevant Skills and Experience PHP, MySQL, node.js, you Más

$180 AUD en 3 días
(12 comentarios)
0.0
triplemmm

I would like to work to your project and I will complate your most valuable time. Thank you.

$50 AUD en 1 día
(0 comentarios)
0.0
danielherrerac

I have experience working with data analysis, so I can this job for you. You probably need a function instead of a query because moving average is more complex than average and requires a range parameter. I have a q Más

$80 AUD en 3 días
(1 comentario)
0.0
gsguglielmo2

I will create the requested query in the most optimized way. The query will be created with generalized parameters so it can be adapted to any time interval. Relevant Skills and Experience I have years of experience i Más

$144 AUD en 40 días
(0 comentarios)
0.0
MaryumAkhter1

i can do this for you Relevant Skills and Experience i have an experience of 1.5-2 years in this field Proposed Milestones $150 AUD - 1

$150 AUD en 3 días
(6 comentarios)
0.0
JulianHQ

Write an optimized SQL query to calculate the desired data. Relevant Skills and Experience SQL, Code optimizing. Proposed Milestones $40 AUD - Write SQL query I'd like to take a more in-depth look on the data and ha Más

$40 AUD en 3 días
(2 comentarios)
0.0
$147 AUD en 3 días
(682 comentarios)
0.0
djcarras

hi, i can help you with your project. send me more information about via freelancer.com chat. regards Habilidades y experiencia relevante linux php html5 boostrap jquery mysql mariadb sql server Htos propuestos $133 Más

$133 AUD en 3 días
(5 comentarios)
0.0
poojamishra13

Hi, i am expert developer, i would like to make this query. Thanks Relevant Skills and Experience Big Data, MySQL, Software Architecture Proposed Milestones $222 AUD - Default

$222 AUD en 3 días
(8 comentarios)
0.0
steve26larson

Give the weekly, 4 week, and 12 week moving averages Relevant Skills and Experience Am quite experienced with MySQL Proposed Milestones $30 AUD - Get averages needed

$30 AUD en 3 días
(1 comentario)
0.0