This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

for those of you with SuiteAnalytics Connect, are you using any specific BI tools that you prefer?

I couldn't get SuiteAnalytics Connect to run reliably. It timed out on long queries. That being said, Tableau was kind of nice, but it's problematic with reproducibility, because it's not transparent how you built something, and it's not as fine-controlled as real SQL.

Ultimately, we ended up using suite analytics connect to simply clone the netsuite database into a local PostgreSQL database,  and we have Metabase interfacing with that, our legacy database and our website database

Metabase can handle really complicated queries and also has a nice UI for simple stuff. Recently, I started pulling data into R with DBI and dplyr and doing my analysis right in there, because I can version the code which is really nice.. eventually I'll build out a shiny dashboard or something

I did something similar, cloned the netsuite database into a mysql db and built any required indexes for bigger queries