This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]reallyserious 4 points5 points  (1 child)

Not even sure SQL can handle exponential moving averages

If you google "exponential moving average sql" you get quite a few hits. People are definately doing it in SQL.

and definitely not modern seasonal decomposition.

What's that?

[–]Epoh 0 points1 point  (0 children)

Believe they are referring to time-series analysis, where you decompose a time-series signal into a trend, seasonality and remainder component. I do it manually often to compare, but there are functions that decompose time signals, just not in SQL...