As one of my tasks at my previous job I investigated a bunch of data analysis/reporting solutions for our use. None of them provided that combination with any finesse. We ended up writing our own solution as a thin wrapper over SQL that output data either to the browser or to Excel. It served our purposes, but it was a compromise.
This new feature from Chartio, if the video and post are to be believed, would have been perfect. Now if only they offered an appliance so companies could use it without shipping data out.