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:


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.


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.


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.