>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)