I frequently come across this kind of situation where i have a timeseries based data with lots of categories.
What i'd like is some tool that can scan my data and tell me which categories are interesting. Say the measure is a response time for example. If I have 100's of categories, I want to know which ones have the biggest movement in the response time measure.
Now I could do this reasonably easily with Pentaho Data Integration - a tool i'm already a big fan of - but it would be pretty basic. And I can't help but think i'm missing something, and there must be a better tool for the job?
In theory we would then like to do some further advanced analysis with perhaps rstats or weka on the interesting categories - but from my understanding it seems you must identify the interesting categories before using those tools, is that correct?