Take the 2-minute tour ×
User Experience Stack Exchange is a question and answer site for user experience researchers and experts. It's 100% free, no registration required.

I have a lot of time-series data. I would like to visualize this data, so that I could spot patterns like the following:

"About five days after event X, event Y is very likely to happen"

or

"A short burst in the frequency of event Z, makes it likely that also event Y will happen with an extra high magnitude"

I specifically do not want to describe what my data is about, as I am looking for a general solution to a general question.

Edit: The simplified table structure is like the following:

thetime datetime
eventid int
magnitude double
intensity double
share|improve this question
    
Sounds more like a need for a statistic if there is a lot of data. –  JeffO Mar 16 '11 at 12:57
1  
@Jeff O. The advantage of statistics is when I know what I am looking for, I can get an accurate statistic. Visualizing is superiour when I need to spot a pattern. Especially the second example cannot easily be spotted using statistics, unless you know what you are looking for. –  David Mar 16 '11 at 13:08
add comment

5 Answers

up vote 9 down vote accepted

Try using a spiral heat map to visualise your data - these are excellent at helping you to spot temporal patterns. Your time dimension becomes a spiral, one rotation per year or month, and your other variables shown as a heat map.

enter image description here

TDWI has an interview with Biz2 founder Andrew Cardno where he talks about this approach.

Disclosure: Several years ago, I used to work for one of Andrew's earlier businesses.

share|improve this answer
    
This certainly looks impressive, and I have inquired about the cost of this. Thanks! –  David Mar 21 '11 at 9:19
add comment

I like the google finance charts, I think it's a great solution, especially how they connected it to the large overview chart at the bottom:

enter image description here

And make sure to explore the little interactions inside - for example, how on mouseover both graphs show an indication at once (instead of drawing a vertical guide connecting them).

share|improve this answer
    
I agree that graphs can be used, but my data is multidimensional so I do not think it would be easy to map to graphs. I have updated my question with the data structure. –  David Mar 16 '11 at 15:12
    
@David In that case, I think you could use the same technique, and use line width to show intensity. It's basically the same principle as suggested by @Nathanvda, but with a chart it's easier to see patterns than with a static collection of bubbles. –  Vitaly Mijiritsky Mar 16 '11 at 19:16
    
Indeed, line width is very similar to what i proposed, and maybe even clearer. Normally I would presume if the chart-data is dense, using the bubbles you would get close to the same effect. If it is not, using the lines will be much clearer. –  nathanvda Mar 18 '11 at 14:53
add comment

Sounds like a job for motion charts. You should watch Hans Rosling's TED talk. It's amazing.

animated gif demonstrating a motion chart

(Image from iwaterpolo on Wikipedia.)

Google has an implementation that you can try out.

share|improve this answer
add comment

Google finance chart approach could work too - just plot magnitude and intensity as two separate lines. If there is a correlation between the two measurements, you will see them go up and down at the same time. If two measurements are negatively correlated (you can test this hypothesis statistically), you can plot f(x) of one measurement and -g(x) of another. Simpler charts get the point across to a wider audience:)

share|improve this answer
add comment

I think this will work best using graphs. The multidimension aspect could be handled drawing just dots (or circles). If you then use the following :

  • X is time
  • Y is magnitude
  • each event gets its own color
  • and each dot is larger based on intensity

I think visual patterns hopefully could emerge.

Hope this helps.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.