PowerPivot charts are also great visualisations, and you can use them alongside pivot tables for those who want to see the numbers. It's also just an Excel (or SharePoint) addon, and business people love getting their Data into Excel anyway. For all the reports I've created that people just end up exporting to Excel!
The Data Warehouse Institute http://tdwi.org does a lot of surverys and research around different vendor products. Take a look at some of their reports if you want to see some other competitors to Tableau & Qlikview