Take a look at SQL Server Reporting Services.
It's a charting and reporting tool over SQL Server (and I thinkg any other ODBC/OLEDB source), it works over large datasets, has both Web UI and desktop UI, and comes in the box with SQL Server itself.
FD: I work in SQL Server, athough not on Reporting Services. FWIW, Reporting is a huge success with our customers.
It is also available as a free download for developers to try it out and learn / test.
I have used SQL Reporting Services as well as Business Objects tools and I am pretty impressed with the latest releases from MS.
(that's the maximum number of rows in Excel before 2007). I'd like something similar to SPSS, which is more convenient for tables with lots of rows and separates the data from the formulae.
A tool for working with streaming data.
Also, charting that works for large amounts data. Try having Excel chart 65,000 rows and you'll have time to make coffee while you wait. There are no ways to zoom or analyze Excel charts, either.
In fact, charting for data analysis alone is a big enough problem that needs solving (and you won't have to do all that catching up with Excel). Short of using HTML/Flash or .NET/Java components, there is nothing an enterprise worker can use. Get access to a Bloomberg terminal from somewhere and play with its charts to see what I mean.