I have found XLCubed to be well suited to most organisation sizes. While we implement against Microsoft Dynamics we have also successfully used XLCubed against all types of data. This includes hospitals, manufactures, distributors and financial services providers. I also like that its authored in MS Excel. This is a tool most users are already familiar with. Often they have used Pivot Tables so the BI concepts are somewhat understood. Review collected by and hosted on G2.com.
Is not well suited to "live" reports, but it doesn't pretend that it does. Setting up security can be a bit confusing due to multiple options. Review collected by and hosted on G2.com.