We have leveraged Marketo and Tableau recently, you can see my reply at the bottom in this post: Integrating with Tableau
There are several ways to do it (there are some caveats and a lot of gotchas) -
- Custom build code to call the REST API
- Tableau connector (I wouldn't recommend this)
- Alteryx - which sort of a halfway house of programmatic benefits as well as ease of use
The gotchas are - if you want historical data from your instance you will really struggle to get the data down easily or in a timely manner - the API does not support (that I can see) a filter to get info Between dates - only data FROM a date - i.e. Jan 1 2015 onward will burn through your API calls in no time. We have several instances which have 2m records plus - so that is 2m x Activity limits - it can easily reach 25m+ rows in now time.