Shiny Server is a great solution for BI/analytics reporting. It leverages the power of the R language to create interactive reports/dashboards.
May be you have tried it but are reclutant to use it in production because it lacks any authentication on it’s open source version. I’ve written a post on Auth0’s blog that explains how you can use Auth0 to create a nice login page protecting your reports, which can hook up users from other systems (Google? Linkedin? LDAP? AD? Your custom MySQL Database? An Auth0 hosted DB? All apply!).
Disclaimer: I’m working as a Data Engineer in Auth0