Jump to content

Predicting abnormal trends in timeseries data


duki

Recommended Posts

I'm looking for an algorithm that can help identify abnormal trends in time-series metrics. The best I've been able to find so far is ARIMA (a completely new concept for me).

We offer several services which we monitor active usage against, for any given time of day (typically updated once a minute). Here's a example of one of our services:
jehrd.png

What I'm interested in is gradual degradation that doesn't get noticed until ... well, it gets noticed. For example, if we zoom in to 12/6 we see:
tJHC0.png

So what I'm specifically interested in here is the trend downward `@17:30~`. Likewise another good example would be:
e6Rfa.png

Here we can see the abnormalities on 12/1 and 12/4 during peak.

Are there any formal methods of detecting this sort of trend (or rather, abnormality to a historical trend)? Specifically interested in the _trend_ here, not the raw numbers. These services have a historical decreasing usage as time goes on - eventually, these numbers will drop from say 60k peaks to 15k peaks.

Is ARIMA the best bet here? e.g., predicting the future curve based on yesterday's curve, setting some threshold, and alerting if that threshold is breached? Or is there a more straightforward way to go about this? Am I fundamentally misunderstanding ARIMA?

 

Here's kind of what I had in mind for what I'd like to accomplish:

(i.e., taking the curve of one dataset and seeing if another dataset fits within that curve)

U5Sgg2N.png

Edited by duki
Link to comment
Share on other sites

I did a whole module on ARIMA but still don't understand it. Have you tried de-trending and eliminating seasonality from your data? What package are you using to analyse the data?

 

There are many other methods for analysing time series, but apparently ARIMA is the simplest so probably the best to start with.

Link to comment
Share on other sites

  • 2 weeks later...

Looks like an ATR indicator to me. If its curved then use Fourier, but i have no idea what the data relates to in your image, looks more like quantity than price and volume has its own indicators with similar results.

 

My apologies my minds on other things, what exactly do you actively monitor? I wont hazard a guess.

 

An easy solution would be simple regression where the two line would meet at right angles, codes simple

Edited by DevilSolution
Link to comment
Share on other sites

12/2, 12/3, 12/4, etc. looks like date December 2,3,4,...

So one whole sinusoid half is one whole day.

And Y axis is quantity of people that used service. Right?

 

I would simply took newspaper, or tv program, and check in it what exactly happened 6 December and started around 18.

 

Could be football or other sport.

FIFA eliminations, EURO eliminations, local country league matches, etc.

French league had 3 matches 6 December.

 

Premier League, Everton vs Crystal Palace, match started 21:00, 7 December.

Primera Division, Barcelona vs Levante, started 20:30.

(We could be in different time zone, so you need to adjust to local time zone)

 

Are there any formal methods of detecting this sort of trend

 

Get newspaper, tv program, and check when there will be matches the next time...

 

Do you have access to per-country data?

If yes, check which country customers disappeared in this event at 6 Dec.

 

Do you have access to per-sex data? Most likely male users disappeared, if they were watching matches.

Edited by Sensei
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.