Last Updated on 18 November 2026
SuiteAnalytics Workbook is NetSuite’s built-in analytics tool for building tables, pivot tables and charts from real-time NetSuite data using a drag-and-drop interface, with no coding or exports to Excel needed. It is enabled by default in every NetSuite account, sits under the Analytics tab and suits finance, sales and operations users who have outgrown saved searches and standard reports.
This guide explains what SuiteAnalytics Workbook is, how datasets and workbooks fit together, how it compares with saved searches and when to move up to NetSuite Analytics Warehouse.
TL;DR
- SuiteAnalytics Workbook lets users build tables, pivot tables and charts in NetSuite with drag and drop, using real-time data from multiple record types.
- Every workbook is built on a dataset, a reusable query that joins records and applies filters, and one dataset can feed many workbooks.
- For advanced visualisation or data from outside NetSuite, the next step is NetSuite Analytics Warehouse, which connects to tools such as Power BI and Tableau.
What is SuiteAnalytics Workbook in NetSuite?
According to Oracle’s SuiteAnalytics Workbook overview, Workbook is NetSuite’s analytics tool for creating custom workbooks that combine datasets, tables, pivot tables and charts in one place. It supports multilevel joins across record types, including custom records, custom formula fields and linked datasets that let you compare metrics from two datasets in one visualisation.
Workbook was built to remove the limits of saved searches and standard reports, which often meant exporting data to Excel for deeper analysis. With Workbook, that analysis happens inside NetSuite on live data.
How do SuiteAnalytics datasets and workbooks work?
| Component | What it does |
|---|---|
| Dataset | The foundation of every workbook. A dataset combines fields and criteria filters across one or more record types into a query, and one dataset can feed many workbooks. |
| Workbook | Where you analyse dataset results through table, pivot and chart visualisations. |
| Linked datasets | Two datasets joined by common keys so you can compare their metrics in one pivot table or chart. |
| Templates | Predefined workbooks and datasets for common analysis that you can copy and adapt. |
Workbook runs on NetSuite’s analytics data source, the same real-time data that powers the rest of your ERP. As you filter, sort and group records, results update instantly with no export or batch process.
What are the key features of SuiteAnalytics Workbook?
| Feature | What it means for users |
|---|---|
| Multilevel joins | Pull data from related records, such as invoices and inventory, in one report without SQL |
| Drag-and-drop interface | Non-technical users can add fields, filters and visualisations in a few clicks |
| Dynamic filtering | Apply filters at runtime to view specific subsets of data |
| Custom formula fields | Add calculated fields such as year-on-year growth or margin |
| Prebuilt templates | Start from ready-made workbooks for finance, sales and inventory analysis |
| Sharing and export | Share workbooks across your organisation and export to CSV when needed |
What is the difference between SuiteAnalytics Workbook and saved searches?
| Saved searches | SuiteAnalytics Workbook | |
|---|---|---|
| Best for | Lists, alerts and operational lookups | Multi-dimensional analysis and visual reporting |
| Joins | Limited joins between related records | Multilevel joins across record types, including custom records |
| Visualisation | Results lists and basic summaries | Tables, pivot tables and charts |
| Data source | Saved search data source | Analytics data source, where some record and field labels differ |
| Skill level | Familiar to most administrators | Drag and drop, suited to business users |
Many businesses use both: saved searches for operational lists and reminders, and Workbook for analysis. Our guide to SuiteAnalytics vs NetSuite Analytics Warehouse compares NetSuite’s wider analytics options.
How do you open SuiteAnalytics Workbook?
Click the Analytics tab in NetSuite to open the Analytics Home page, where you can view workbooks and datasets you have access to, open the Dataset Builder and create table, pivot and chart visualisations. Oracle’s using SuiteAnalytics Workbook guide notes the feature is enabled by default, so if you cannot see the Analytics tab, ask your NetSuite administrator. The record types and fields you see depend on your role permissions and the features enabled in your account.
What can you do with SuiteAnalytics Workbook?
| Use case | How Workbook helps |
|---|---|
| Sales performance | Track sales by region, product category or customer segment, with calculated fields for year-on-year growth or top performers |
| Inventory optimisation | Combine inventory and sales data to spot shortages and focus on priority items or locations |
| Financial reconciliation | Cross-reference GL data with bank transactions to find discrepancies in one view |
| Customer lifetime value | Combine transaction history, customer details and service interactions to calculate CLV |
For finance-specific reporting, see how NetSuite helps turn numbers into narratives and our NetSuite dashboard tips.
What are common SuiteAnalytics Workbook challenges?
| Challenge | How to solve it |
|---|---|
| Understanding data relationships | Map how NetSuite records relate with your administrator or partner before building complex joins, since some joins can duplicate data |
| Performance with large datasets | Apply filters and summarised fields to narrow the data before visualising it |
| Advanced visualisation needs | Export to Power BI or Tableau, or move to NetSuite Analytics Warehouse for advanced analytics |
Get a personalised NetSuite pricing estimate
Receive a tailored NetSuite quote based on your business requirements, users, modules and implementation needs.
When should you move to NetSuite Analytics Warehouse?
Workbook covers most reporting inside NetSuite. Businesses that want to combine NetSuite data with other systems, analyse long histories or use AI-driven analytics and advanced visualisation usually move up to NetSuite Analytics Warehouse. Read from dashboards to data lakes, watch our NetSuite Analytics Warehouse video demo or see how NSAW consolidates your data.
How can Annexa help with SuiteAnalytics Workbook?
SuiteAnalytics Workbook is already in your NetSuite account. Annexa helps customers design datasets, build workbooks for specific use cases and decide when analytics needs to go further. Existing customers can contact us for a walkthrough through Annexa support.
Frequently asked questions
What is SuiteAnalytics Workbook?
SuiteAnalytics Workbook is NetSuite’s built-in analytics tool for creating tables, pivot tables and charts from real-time NetSuite data with drag and drop. Every workbook is built on a dataset that joins records and applies filters.
Is SuiteAnalytics Workbook free in NetSuite?
Yes. SuiteAnalytics Workbook is enabled by default in all NetSuite accounts with no additional licence. What you can see depends on your role permissions and enabled features.
Where is SuiteAnalytics Workbook in NetSuite?
Click the Analytics tab in the NetSuite navigation menu to open the Analytics Home page, where you can open workbooks and datasets or create new ones.
What is the difference between a dataset and a workbook in NetSuite?
A dataset is a query that combines record type fields and criteria filters. A workbook uses one or more datasets to show results as tables, pivot tables or charts.
Should I use saved searches or SuiteAnalytics Workbook?
Use saved searches for operational lists, alerts and lookups. Use SuiteAnalytics Workbook for multi-dimensional analysis, pivot tables and charts across related records.
What is the difference between SuiteAnalytics and NetSuite Analytics Warehouse?
SuiteAnalytics, including Workbook, analyses data inside NetSuite. NetSuite Analytics Warehouse is a separate data warehouse that combines NetSuite with other data sources for advanced and AI-driven analytics.