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.

fixer1234
  • 28,064
Mahmoud Al-Qudsi
  • 3,993

2 Answers2

1

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

Traveling Tech Guy
  • 10,100
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.

edallme
  • 216