I don't know about built in statistical tools beyond the basic aggregates available in SQL, but we (Fullscreen) have been using Chartio and are really enjoying

I don't know about built in statistical tools beyond the basic aggregates available in SQL, but we (Fullscreen) have been using Chartio and are really enjoying it. I'd say it does great for 95% of the dashboards and visualizations we need (custom d3.js for the rest) and it plays well with our data sources. Particularly coming from Redshift data I found Chartio a lot snappier than equivalent charts in Tableau, especially for large data sets. You can either use their UI to make charts, or write pure SQL, or my preferred method of making most of the functionality in the UI and tweaking the SQL for the last few details if you need something bespoke.