[smithian]

I've done some minor stuff in MS PowerBI and PowerQuery/PowerPivot that I think meets your need. It's pretty nifty.

https://powerbi.microsoft.com/ http://www.powerpivotpro.com/what-is-power-pivot/