Suoritettu

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

Taidot: Big Data Sales, MySQL, tietojärjestelmäarkkitehtuuri

Näytä lisää: 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

Tietoa työnantajasta:
( 40 arvostelua ) Mount Waverley, Australia

Projektin tunnus: #14916693

Myönnetty käyttäjälle:

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 Lisää

$155 AUD 3 päivässä
(6 Arvostelua)
0.0

29 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

$100 AUD 3 päivässä
(0 arvostelua)
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 Lisää

$147 AUD 3 päivässä
(41 arvostelua)
0.0
$111 AUD 3 päivässä
(5 arvostelua)
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 Lisää

$150 AUD 1 päivässä
(37 arvostelua)
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 Lisää

$130 AUD 3 päivässä
(7 arvostelua)
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 0 päivässä
(11 arvostelua)
0.0
$155 AUD 3 päivässä
(0 arvostelua)
0.0
caigentao

Proposed Milestones $155 AUD - hi。

$155 AUD 3 päivässä
(0 arvostelua)
0.0
tuanthanhle

A proposal has not yet been provided

$132 AUD 2 päivässä
(7 arvostelua)
0.0
bhawin91

A proposal has not yet been provided

$222 AUD 3 päivässä
(18 arvostelua)
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 Lisää

$180 AUD 3 päivässä
(12 arvostelua)
0.0
triplemmm

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

$50 AUD 1 päivässä
(0 arvostelua)
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 Lisää

$80 AUD 3 päivässä
(1 arvostelu)
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 Lisää

$144 AUD 40 päivässä
(0 arvostelua)
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 3 päivässä
(6 arvostelua)
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 Lisää

$40 AUD 3 päivässä
(2 arvostelua)
0.0
$147 AUD 3 päivässä
(682 arvostelua)
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 Lisää

$133 AUD 3 päivässä
(5 arvostelua)
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 3 päivässä
(8 arvostelua)
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 3 päivässä
(1 arvostelu)
0.0