Is something like this on the roadmap or is a capability today?
Best answer by ashok_dugaputi
But alternatively, though this is not 'real time' solution, following may be an option for you to take the power of Excel for your reporting beyond what is available from Gainsight Reporting option.
With Winter release (Feb-2017), we are going to provide two features.
1) Bionic Rules : Allowing to query SFDC + MDA data together and process the data. This opens up the gates to query any object, join / filter as per your business need and prepare a data set that would provide better analytics option. It is almost like preparing a materialized data space or a OLAP cube with dimensions and facts.
2) Export to S3 : Once the data set is available, export the larger data sets to Export to S3. Earlier we had a limit of 100K rows only export.
So if you can connect to S3 via Excel (though I did not try hands-on, seems to be a possibility) or download the file from S3 to your disk and connect to Excel, you will be able to get the reporting & visualization from the file.
I repeat - Though this is not a live connection to address 'Refresh' requirement but it is closer solution to take the power of 3rd party reporting including Excel or Excel pivot or Excel's Power Pivot or Power view.