My company uses SAS fairly heavily for data analysis and bussiness reporting. It's also our go to tool for ad-hoc querries of production databases (essentialy a SQL gui).

Excel (and other spreadsheet packages like Calc) are good for non technical users it's useful for rapidly prototyping stuff but it is absolutely a pain for automation and any type of statistical heavy lifting. Once a spreadsheet reaches a certain level of complexity it becomes a pain to support and maintain much better to have a real database driving things.

I've heard a lot about R which is kind of an open-source version of SAS (at least the statistical parts) not sure what its automation and reporting support is like my limited understanding is it doesn't have the BI parts.