MySQL weekly moving average query on sales data

$30-250 AUD

Pågår

Lagt ut

over 6 år siden

$30-250 AUD

Betalt ved levering

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

Big Data Sales

MySQL

Software Architecture

Prosjekt-ID: 14916693

Om prosjektet

23 forslag

Eksternt prosjekt

Aktiv 7 år siden

Ønsker du å tjene penger?

E-postadresse

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen

Få betalt for arbeidet ditt

Skisser forslaget ditt

Det er gratis å registrere seg og by på jobber

23 frilansere byr i gjennomsnitt $146 AUD for denne jobben

@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 pick. Proposed Milestones $180 AUD - deliver How would you like this to be outputted? Calculated?

$180 AUD om 3 dager

5,0

(12 omtaler)

5,5

@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 AUD - milestone

$133 AUD om 3 dager

5,0

(5 omtaler)

4,0

@bhawin91

A proposal has not yet been provided

$222 AUD om 3 dager

4,9

(18 omtaler)

4,2

@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 developer with mysql experience. Proposed Milestones $50 AUD - Signup $80 AUD - On completion

$130 AUD om 3 dager

5,0

(7 omtaler)

4,2

@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 om 3 dager

4,8

(10 omtaler)

3,9

@tuanthanhle

A proposal has not yet been provided

$132 AUD om 2 dager

5,0

(10 omtaler)

3,8

@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 om 0 dag

4,8

(11 omtaler)

4,1

@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 have details over the task.

$40 AUD om 3 dager

5,0

(2 omtaler)

2,2

@cw52

Will create a query that can take in a number of weeks and will return the moving average.

$211 AUD om 1 dag

0,0

(0 omtaler)

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 om 3 dager

0,0

(1 omtale)

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 in mysql database developing and optimization. Proposed Milestones $144 AUD - Completed query I will need the table schema and some random data to test it.

$144 AUD om 40 dager

0,0

(0 omtaler)

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 question, you need a moving average of products sales or earnings?

$80 AUD om 3 dager