Damn, we have been looking for something like this for so long. I even posted an Ask HN question about precisely this a little while ago (http://news.ycombinator.com/item?id=1393159). In the end, we keep stats nightly and export them to excel. Yeah, re-creating the graphs every time is what kills it. So we export a limited version to Roambi.
The issue is that Roambi (strangely) can simulate and such in flash, but only output to iphone/ipad. Granted, it's a gorgeus interface.
Now, I may be a bit old fashioned, but handing our database out is something that makes me very nervous and opens us up for liabilities if something were to happen.
So tempting, though ...
One possible idea would be to somehow derive a cooked version of our DB and use that. Not sure how to do it nicely.
Another option is to somehow license this as a gem or something?
This is exactly what we need for many needs and perhaps all needs if you actually managed to abstract all the needs in a general way.
Glad we can help you out! We take what we do seriously and we're like consultants under tight NDA. We'll connect to your data securely and never share it with anyone.
Large banks, tel cos and credit card companies hire consultants all the time. Plue we'll be so useful!
The issue is that Roambi (strangely) can simulate and such in flash, but only output to iphone/ipad. Granted, it's a gorgeus interface.
Now, I may be a bit old fashioned, but handing our database out is something that makes me very nervous and opens us up for liabilities if something were to happen.
So tempting, though ...
One possible idea would be to somehow derive a cooked version of our DB and use that. Not sure how to do it nicely.
Another option is to somehow license this as a gem or something?
This is exactly what we need for many needs and perhaps all needs if you actually managed to abstract all the needs in a general way.