3

Are there any products that can take a CSV of info, and quickly generate commonly-asked for info? I'm wondering if there's any way easier than pulling this into Excel or Matlab and manually doing all the different analyses.

I have a CSV with info like this:

TIMESTAMP SALEID PRODUCT PRICE

And I'd be looking for some tool out there that would automatically create all the relevant charts for analysis such as sales/day, revenue/day, avg revenue/day, most popular product, product by day, etc.

As I mentioned, I know the individual math behind this is relatively easy and both Matlab and Excel could both pull it off, but I'm looking for an easy way out.

0

Spotfire and Tableau are commercial applications for this, and Spotfire especially is incredibly easy to use to explore lots of visualizations side-by-side. Both have a desktop version and an online web player (Spotfire demo gallery, Tableau demo gallery). They are both highly scalable, into the millions of rows. Both are expensive, but have free trials.

1

Take a look at Google Chart Tools, specifically, the dynamic data features

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