Skip to main content
Get in touch
BLOG

What is NetSuite SuiteAnalytics Workbook? A practical guide

What is NetSuite SuiteAnalytics Workbook? A practical guide
Published on 11th February 2025

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.

NetSuite SuiteAnalytics Workbook pivot table and chart

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.

REQUEST PRICING

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.

Summarise with AI

Stay updated with Annexa