My company uses some simple MySQL queries to generate a CSV report of a bunch of stats (about 20 columns, rows in the low thousands). We then use Microsoft Excel to create pivot tables to explore and drill down into the data.
I’ve tried using LibreOffice Calc but the pivot tables don’t support calculated fields, which we use extensively.
Interactivity is key, but it doesn’t need to be spreadsheet-like.
Charts/graphs are nice, but we mostly need tabular data.
There are lots of products that seem "enterprisey" and use OLAP. I’m not against that but their websites tend to be geared towards executives and it’s hard to see what they actually do.