My advice for best use of SuiteAnalytics Connect: replicate data separately from individual record types and lists into local tables, then perform joins and any other complex logic in your local database. Just because it is possible to run functions and multiple joins on the NetSuite side, does not always mean that it is a good option. It is useful to experiment with different options to find out what works best. I personally haven't used Tactical Connect, so I can't really compare the performance of both.