MySQL weekly moving average query on sales data

$30-250 AUD

Dalam Kemajuan

Disiarkan

lebih dari 6 tahun yang lalu

$30-250 AUD

Dibayar semasa penghantaran

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

ID Projek: 14916693

Tentang projek

23 cadangan

Projek jarak jauh

Aktif 7 tahun yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

23 pekerja bebas membida secara purata $146 AUD untuk pekerjaan ini

@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 dalam 3 hari

5.0

(12 ulasan)

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 dalam 3 hari

5.0

(5 ulasan)

4.0

@bhawin91

A proposal has not yet been provided

$222 AUD dalam 3 hari

4.9

(18 ulasan)

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 dalam 3 hari

5.0

(7 ulasan)

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 dalam 3 hari

4.8

(10 ulasan)

3.9

@tuanthanhle

A proposal has not yet been provided

$132 AUD dalam 2 hari

5.0

(10 ulasan)

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 dalam 0 hari

4.8

(11 ulasan)

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 dalam 3 hari

5.0

(2 ulasan)

2.2

@cw52

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

$211 AUD dalam 1 hari

0.0

(0 ulasan)

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 dalam 3 hari

0.0

(1 ulasan)

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 dalam 40 hari

0.0

(0 ulasan)

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 dalam 3 hari