Also worth checking out is http://redash.io for this kind of stuff - fairly new but developing quickly and very easy to hack on/add stuff. Good docs, easy to deploy and has some nice auto-update reports bits. We use that quite heavily. Its open source/free to use but also comes with paid cloudy plans.