Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My data set is sourced from ~100k users, with a few million records scattered over a dozen tables. Just too big for Excel, but not quite a data warehouse. It's sourced from a web-sites user base and traffic data.

Excel would be nice, with it Pivot tables and charts, but it just chokes approaching 100k records. I am looking for a desktop application for data analysis, in the vein of Business Objects, only less ambitious.

Any suggestions?

Thank you.

share|improve this question

closed as off-topic by fixer1234, DavidPostill, random May 1 at 1:25

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions seeking product, service, or learning material recommendations are off-topic because they become outdated quickly and attract opinion-based answers. Instead, describe your situation and the specific problem you're trying to solve. Share your research. Here are a few suggestions on how to properly ask this type of question." – fixer1234, DavidPostill, random
If this question can be reworded to fit the rules in the help center, please edit the question.

You might want to have a look at Microsoft PowerPivot.

It's a free add-in for Excel 2010 which is able to handle way more data than Excel can out of the box. The main purpose of the add-in is data analysis on a much larger scale than previously possible. With the help of new formula language (see the second link below to dive right into that stuff) and the possibility to connect multiple tables into one pivot table it's possibilities are really much broader than the standard Excel table used to offer.

Download over here: https://www.microsoft.com/bi/en-us/solutions/pages/powerpivot.aspx

A great resource to get started is this: http://www.powerpivotpro.com/ (check out the sections "New Visitor?" and "What is PowerPivot?")

share|improve this answer
    
This is Windows only, but sounds very useful. I'll ask a colleague to try it out. Thanks! – Gabriel R. Dec 21 '11 at 23:18
    
True but definitely worth trying and I'd argue also worth setting up a virtual machine dedicated for this. Let me know what you think about it! – joweiser Dec 22 '11 at 21:28

You can also try xlreport.com. It allows you to real time connect to your database and automatically create a pivot table and chart.

share|improve this answer

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