Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

2 Answers

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! –  masterjo Dec 22 '11 at 21:28
add comment

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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