NetSuite Analytics Templateslink
Use our analytics templates to get insights quickly from your NetSuite data. NetSuite has limited in-tool reporting and its API is notoriously complicated. After you’ve loaded NetSuite data into your destination using Fivetran connectors, our plug-and-play template removes those obstacles to analyzing NetSuite data.
Our analytics template is compatible with BigQuery and Snowflake. If you use a different destination, you can use these queries as a starting point and update the syntax. This template includes the following components:
Prerequisiteslink
To use our NetSuite SuiteAnalytics analytic templates, you need:
-
A Fivetran NetSuite SuiteAnalytics connector
-
To have synced at least the following tables:
ACCOUNTS
ACCOUNTING_PERIODS
ACCOUNTING_BOOKS
CONSOLIDATED_EXCHANGE_RATES
CURRENCIES
CUSTOMERS
DEPARTMENTS
EXPENSE_ACCOUNTS
INCOME_ACCOUNTS
ITEMS
LOCATIONS
PARTNERS
TRANSACTION_LINES
TRANSACTIONS
SUBSIDIARIES
VENDORS
VENDOR_TYPES
Note: If you have just set up your NetSuite SuiteAnalytics connector, you must start the initial sync and wait for the sync to complete. Depending on the size of your NetSuite data, it may take from a few minutes to a few hours.
SQL query setup guidelink
To use our SQL queries in your destination, follow these steps.
- Go to the SQL queries in our public GitHub repository.
- Navigate to the folder that corresponds to your destination.
- Copy and paste the queries from GitHub to your destination.
- Run the queries and start exploring your transformed data.
Tableau workbook setup guidelink
To connect Tableau to your NetSuite data, follow these steps.
All warehouseslink
- Go to the Tableau workbook in our public GitHub repository.
- Navigate to the folder that corresponds to your destination.
- Save the workbook to your computer. The file format should be All Files.
- To finish your Tableau workbook setup, follow the instructions below for your destination.
For Snowflakelink
If you use Snowflake as your destination, follow these steps to finish your Tableau workbook setup.
-
Open the Tableau workbook using your favorite text editor.
-
Update the named-connection node with your Snowflake credential details on the following lines:
- Line 24: update
caption
. - Line 25: update
dbname
,schema
,server
,service (role)
,username
, andwarehouse
. - Line 1075: update
caption
. - Line 1076: update
dbname
,schema
,server
,service (role)
,username
, andwarehouse
. - Line 1387: update
caption
. - Line 1388: update
dbname
,schema
,server
,service (role)
,username
, andwarehouse
.
- Line 24: update
-
Save and close the file.
-
Open the workbook with Tableau.
-
Enter your Snowflake username and password to sign in.
-
The dashboards will populate with your NetSuite data. You can now start analyzing your data.
For BigQuerylink
If you use BigQuery as your destination, follow these steps to finish your Tableau workbook setup.
- Open the workbook with Tableau.
- When Tableau prompts you to sign in with your Google account, select your Google account and grant Tableau access to it. Tableau will open.
- In Tableau’s Data Source tab, update your BigQuery Connection details by selecting the appropriate Billing Project, Project, and Dataset.
- Do steps 2 through 3 for all three data sources for this workbook: Transaction Details, Income Statement, and Balance Sheet.
- The dashboards will populate with your NetSuite data. You can now start analyzing your data.
Looker block setup guidelink
To connect Looker to your NetSuite data, follow these steps.
-
Go to the [Looker block in our public GitHub repository] (https://github.com/fivetran/analytics-templates/tree/master/Netsuite/Netsuite_Looker).
-
Navigate to the folder that corresponds to your destination.
-
Implement the Looker source block in one of two ways. You can either
- copy and paste the LookML code directly from our repo to Looker, or
- download the zip file and upload it to your Looker model in GitHub and then
[follow Looker’s instructions to convert LookML dashboards to user-defined dashboards] (https://docs.looker.com/dashboards/lookml-to-user-dashboard).
- The dashboards will populate with your NetSuite data. You can now start visualizing and analyzing your data.