Earlier quoted context omitted.
Another vote for Metabase. I used it every day in my last role and would do so again although I don't think it's quite Tableau-level in terms of its analysis and reporting capabilities.
Anything seriously missing, or more bells and whistles?
Off the top of my head, I couldn't tell you. I am sure there's a reason the data guys stuck with it but Metabase did absolutely everything I needed and a little more.