>What tools are you recommanding or used for the visualization aspect in your business intelligence infrastructure?
Michel, I've been using a combination of SSRS and Power BI.
They are not perfect, but Power BI in particular has come a long way in the last few years.
I've worked "some" with Qlik - it's quite robust, though I think Power BI's offerings are visually a bit more attractive (my opinion)