By Louis Balla, Chief Revenue Officer, Nuage. Updated October 2026.
NetSuite analytics works in layers. Saved searches and reports answer list and statement questions, dashboards keep the answers in view, and SuiteAnalytics Workbook adds pivot tables and charts on NetSuite data. When you need other sources, longer history or heavy volume, SuiteAnalytics Connect, NetSuite Analytics Warehouse or a BI tool takes over.
This guide matches each kind of question to a tool, explains which tools connect directly to NetSuite, and lists seven finance reports to check first. For building workbooks and saved searches, see our SuiteAnalytics guide. For the Connect drivers, see our SuiteAnalytics Connect guide.
What is NetSuite analytics?
NetSuite analytics is the set of reporting and analysis tools inside NetSuite, which Oracle groups under SuiteAnalytics: saved searches, reports, dashboards, Workbook, Connect and NetSuite Analytics Warehouse. All of them read the same NetSuite records, and they differ in how much they can combine, summarize and send elsewhere.
Which NetSuite analytics tool fits which question?
| The question | Tool | Why |
|---|---|---|
| What is open or overdue right now? | Saved search, shown on a dashboard | A saved search returns a filtered list and can include joins to other records |
| What are our financial statements? | Reports | Standard reports can be modified, and Report Builder defines custom ones |
| How is a metric trending against its target? | Dashboard with KPIs and trend graphs | Dashboards display KPIs, scorecards, trend graphs and report snapshots in portlets |
| How does one measure break down across record types? | SuiteAnalytics Workbook | Datasets join records, including custom records, and present tables, pivot tables and charts |
| Can an outside BI tool read NetSuite data? | SuiteAnalytics Connect | A read-only service with ODBC, JDBC and ADO.NET drivers |
| How do NetSuite figures compare with other systems or with history? | NetSuite Analytics Warehouse, or a warehouse of your own | Oracle describes the Analytics Warehouse as blending NetSuite data with data from other sources |
Our reporting guide compares saved searches, reports and add-ons in more detail.
Which analytics tool connects directly to NetSuite?
SuiteAnalytics Connect is NetSuite’s own direct connection for outside tools. Oracle describes it as a read-only way for a third-party reporting tool or a custom application to obtain NetSuite data through ODBC, JDBC or ADO.NET drivers. Tools that read ODBC or JDBC sources, such as Tableau and Power BI, can use those drivers. Connect is an add-on that must be purchased and enabled.
There are other routes when you do not buy Connect. A saved search can be served by a RESTlet to a tool such as Power Query, and SuiteQL queries can run through NetSuite’s REST web services. Our guide to reporting across NetSuite and Salesforce shows these routes side by side.
How do you choose an analytics approach for NetSuite?
Follow these steps in order.
- List the decisions and who makes them. A controller closing the month and a sales manager checking orders need different tools.
- Mark how fresh each answer has to be. A dashboard portlet shows current NetSuite data. An outside warehouse is as fresh as its last load.
- Count the sources. If the answer needs only NetSuite data, start with NetSuite’s own tools. If it needs another system, plan for Connect, an integration or the Analytics Warehouse.
- Decide who builds and who maintains. A saved search an admin can edit costs less to keep than an extraction process that a developer owns.
- Pilot one question end to end. Build it, then compare the totals with a report or ledger balance you already trust.
We classified 3,241 client support tickets Nuage handled between February 2023 and July 2026, and 296 of them (9.1%) were about reports, saved searches and dashboards. In 200 of those 296, the fix was a change to settings or to a search or report definition, with no new code. Of the 296, 139 had closed when we measured, and half of those closed within 21 calendar days. That pattern argues for trying configuration in NetSuite before buying a new tool.
What are seven core finance reports to check first?
These reports are standard in NetSuite. The point of the list is to confirm that each one ties to the others before you build anything on top of it.
| Report | The question it answers | What to check |
|---|---|---|
| Income statement | Did we make money this period? | The period range and the accounting book match your close |
| Balance sheet | What do we own and owe at period end? | The as-of date matches the last closed period |
| Cash flow statement | Where did cash come from and go? | Beginning cash equals the prior period’s ending cash |
| Trial balance | Do the accounts net to zero? | The same period as the statements above |
| Accounts receivable aging | Who owes us, and for how long? | The aging total equals the receivables balance on the balance sheet |
| Accounts payable aging | What do we owe, and when? | The aging total equals the payables balance on the balance sheet |
| Budget against actual | How are we doing against plan? | The budget version and the dimensions match the actuals |
An AP manager at a healthcare services organization reported: “Something has changed on my AP Aging Summary that is now not balancing to the Balance Sheet for May end of month totals.” We updated the report and showed that the as-of date and the aging options have to match the trial balance date, and after retesting the aging balanced. The ticket closed 14 days after it opened.
When one of these checks fails, look first at the report’s settings, such as the as-of date and the aging options, before changing its layout.
Reviewing a revenue report we were rebuilding by location during his month-end close, a finance lead at a behavioral health provider said: “if I could do my revenue report that way as opposed to the way I’ve been doing it, that would save me a lot of time.” In the same call he said he could put items on his home page but could not work out how to add the report there, so our consultant showed him how to add it as a shortcut.
When do you need more than NetSuite’s built-in tools?
Three situations call for more:
- Other systems in the answer. A report that joins NetSuite with a CRM or an operations system needs an integration, a BI tool or a warehouse.
- History and volume. Oracle’s NetSuite Analytics Warehouse is built to analyze historical data from several sources.
- A standard BI platform. A company that reports in Tableau or Power BI across the business can read NetSuite through Connect.
How Nuage approaches NetSuite analytics
In recent client requests, our team has taken these steps. The order changes with each account.
- Start from the question and the user’s workaround. A report exported to a spreadsheet, or a home page with no shortcut, shows what the user needs the report to do.
- Try configuration first. A change to a search, a report definition or a setting resolves most reporting requests we see.
- Check that the reports tie. We compare aging reports with the balance sheet and test the dates and options before touching the layout.
- Move to a workbook when the answer needs a summary or a chart. The build is covered in our SuiteAnalytics guide.
- Add an outside tool when the question needs one. Connect, a RESTlet or an integration serves the cases where other data or a BI platform is involved.
Nuage’s NetSuite experts do this work as part of ongoing NetSuite optimization and managed services.
NetSuite analytics FAQ
What is NetSuite Analytics?
It is the group of reporting and analysis tools in NetSuite that Oracle calls SuiteAnalytics: saved searches, reports, dashboards, SuiteAnalytics Workbook, SuiteAnalytics Connect and NetSuite Analytics Warehouse. The first four run inside NetSuite, Connect serves outside tools and the Analytics Warehouse combines NetSuite data with other sources.
Which analytics tool connects directly to NetSuite?
SuiteAnalytics Connect, with ODBC, JDBC and ADO.NET drivers, is the direct, read-only connection for outside tools. It must be purchased and enabled. Without it, a RESTlet can serve a saved search to a tool, and SuiteQL queries can run through REST web services.
Can I use Tableau or Power BI with NetSuite?
Yes. Both read sources through ODBC or JDBC drivers, which is how Connect works, and Power BI can also read a saved search served by a RESTlet. Check that the tool’s connection points at the NetSuite2.com data source, because Connect serves only that source as of NetSuite 2026.1.
Does NetSuite have a data warehouse?
Oracle offers NetSuite Analytics Warehouse, which it describes as a way to analyze historical NetSuite data and to blend it with data from other sources. Oracle’s documentation describes subscription tiers and user packs for it, so ask your account team what it costs and what your contract includes.
How do I give users access to NetSuite analytics?
Saved searches, reports and dashboards follow each role’s permissions. SuiteAnalytics Workbook is on by default, and a custom role needs the SuiteAnalytics Workbook permission. Connect needs its own permission and a role ID on every connection. Add only what each role needs.
About the author
Louis Balla is Chief Revenue Officer at Nuage, a NetSuite optimization partner that has served 250+ clients since 2011 and holds a 4.9 out of 5 rating on Clutch. The client work in this article is our team’s.
