Hey Rick -
Most of the time issues like this are related to the underlying data source not being correctly tuned/indexed for the queries that Tableau is executing. Tableau asks a question, the data source is slow in answering, so Tableau seems slow.
You might be able to speed things up by using whatever tools are included with the database GP is using (SQL Server?) to add indexes based on the queries you're going to run.
OR, it may be that the GP schema is so complex and "transaction-focused" that you're never going to get good "report-related" performance. If the GP database is built around an Online Transaction Processing model (OTLP) model then it's pretty much the exact opposite of what you need for fast reporting.
Have you tried creating a Tableau extract against this data source? While it would take a little while to generate, your response time would be much, much faster.
I am in processing of creating an extract. i will then perfrom some basic queries and see if it improves response times. Thanks for the insight.
You might benefit by looking at your Tableau Server logs to isolate whether the database query response time is the problem. As Russell stated, if the data source is slow to return the query results then you will want to work with the DBAs to tune the database. Or, you can follow his recommendation and try a Tableau Data Extract.
Follow these steps to create your Tableau Server Log files:
Then download the FREE Tableau Performance Analyzer to help determine where the performance hit is occurring.
Hope this helps you on your way.