NetSuite Data Intelligence (NSAW) Data Modeling Guide
The NetSuite Data Intelligence (NSAW) prebuilt data model gets you started. Here is what NetSuite administrators need to know to extend and govern it.
Stay Connected
Sign up to hear about Snapshot's latest news and projects!
5 min read
Michael Rueda
:
Nov 16, 2026, 8:30:00 AM
A NetSuite Analytics Warehouse executive dashboard is a leadership view, built from key metrics in NetSuite Analytics Warehouse (NSAW), that presents the measures leadership reviews. At SuiteWorld 2026, Oracle announced that NetSuite Analytics Warehouse is now called NetSuite Data Intelligence; at the time of writing, Oracle's help documentation still uses the NSAW name, so this article does too. Oracle's prebuilt Overview Dashboards typically center on one business topic. Because key metrics are reusable across content, an executive dashboard can give leadership one shared definition of each key metric. An executive dashboard can help leaders review measures such as sales orders and inventory.
Snapshot has worked as a NetSuite Alliance Partner for more than 12 years helping manufacturers and distributors build reporting on NetSuite.
Departments can report from their own saved searches and workbooks, with someone assembling the leadership view by hand from several sources. Metric definitions drift between sources: sales may count revenue at order booking while finance counts it at invoicing, and one report may measure on-time delivery against the requested date while another uses promised date.
NetSuite reports and saved searches retrieve real-time data from your account. NSAW lets you transfer NetSuite data to a warehouse and combine it with historical data and data from other sources.
An executive dashboard works best with a small set of metrics. A balanced set pairs forecast-related metrics, such as pipeline analysis, with metrics that report results, such as inventory turns.
Budget vs. actual, DSO, and cash flow belong on an executive dashboard too, and our guide to CFO dashboards in NSAW covers those financial metrics in depth.
The NSAW KPIs below span finance, sales, and operations:
| KPI | Functional or Subject Areas | What It Tells Leadership |
|---|---|---|
|
On-time in-full
|
Sales (sales orders and item fulfillments)
|
Whether orders ship complete and on the promised date
|
|
Inventory turns
|
Inventory, Financials
|
How efficiently inventory converts to sales
|
|
Gross margin by customer or product line
|
Sales, Financials
|
Which customers and product lines drive profit
|
|
Order backlog trend
|
Sales order snapshots
|
Whether demand is building or softening ahead of revenue |
|
Pipeline coverage
|
Opportunity snapshots or connected CRM data
|
Whether open opportunities can support upcoming revenue targets
|
|
Cash conversion cycle
|
Financials, Inventory, Purchases
|
How long cash stays tied up between paying suppliers and collecting from customers
|
NSAW loads NetSuite data into functional areas, including Financials, Sales, Inventory, Purchases, Manufacturing, and Projects and Support Management, that an administrator selects for data transfer, all in one warehouse built on Oracle Analytics Cloud and powered by Oracle Autonomous AI Lakehouse. Each functional area connects to subject areas. A key metric can draw on several subject areas at once. Oracle's prebuilt Inventory Turnover metric, for example, uses the Customer Invoice, Sales Order, Item Fulfillment, Inventory Snapshot, and Inventory Item Location Quantity subject areas.
Business analysts can define key metrics in the key metrics editor. Key metrics are reusable across content, so dashboards that use a key metric share its definition. NSAW includes Sales Order Snapshot and Opportunity Snapshot subject areas. Oracle describes snapshot tables as tracking daily status and amount changes for a transaction type, which supports trend analysis. Opportunity Snapshot belongs to the Sales Snapshot functional area, which an administrator selects for data transfer. In Oracle's prebuilt content, Overview Dashboards drill down to Detail Dashboards. Data actions define the links, so custom dashboards need them configured.
NSAW can load data from sources such as Salesforce and Google Analytics (GA4 properties) through connectors that an NSAW service administrator configures. With a configured Salesforce connection, Salesforce data can be analyzed alongside NetSuite data in NSAW. As of NetSuite 2026.2, Premium and Enterprise users can manage Salesforce data transfer by functional area from the NSAW Data Transfer Setup page. Data from the functional areas an administrator selects is refreshed automatically every 24 hours, and an administrator can start a manual transfer for a specific functional area, so executive dashboards reflect the most recent completed load while NetSuite remains the source for current transaction status. Our post on NSAW data modeling covers mapping custom fields and records into the warehouse.
NetSuite KPI scorecards cover period-over-period executive reporting. KPI scorecards are a NetSuite dashboard feature that an administrator enables from Enable Features on the Analytics subtab. A KPI scorecard compares multiple KPIs across date ranges or accounting periods, supports formulas between KPIs, and each scorecard accepts up to ten custom KPIs built from saved searches that have a date field defined as an available filter (or a period filter, if the scorecard uses periods) and no date filter in the search criteria. A NetSuite executive dashboard built on KPI scorecards and KPI portlets may cover everything a leadership team needs when its key metrics all come from NetSuite.
NSAW fits better when executive metrics span multiple subject areas, depend on historical snapshots, or include data from systems outside NetSuite. NSAW is available as an add-on module for NetSuite, so the decision depends on whether those requirements justify the added cost. Teams weighing an external BI tool can compare NSAW vs. Power BI and NSAW vs. Tableau.
An NSAW executive dashboard can give leaders an agreed-upon set of metrics for operational decisions.
Snapshot helps manufacturers and distributors plan, configure, and extend NSAW around the metrics their leadership teams run the business on. Our NSAW implementation checklist covers each phase from provisioning through adoption.
A NetSuite Analytics Warehouse executive dashboard is a leadership view, built from key metrics in NSAW, that presents the measures leadership reviews. NSAW is a data warehouse and analytics add-on module for NetSuite, built on Oracle Analytics Cloud and powered by Oracle Autonomous AI Lakehouse. Oracle announced at SuiteWorld 2026 that NSAW is now called NetSuite Data Intelligence. Executive dashboards in NSAW are built from key metrics, which can draw on several subject areas. NSAW includes snapshot subject areas and can load third-party data through administrator-configured connectors. In Oracle's prebuilt content, Overview Dashboards drill down to Detail Dashboards.
NSAW includes prebuilt key metrics, dashboards, and detailed analyses across financial, inventory, sales, and other subject areas. Current NSAW documentation refers to KPIs as key metrics, and analysts can extend the prebuilt set with the key metrics editor. Teams can start from prebuilt content and add metrics specific to their business.
NetSuite KPI scorecards can serve as an executive dashboard when every metric comes from NetSuite and leadership needs period-over-period comparisons. Scorecards compare multiple KPIs across date ranges or periods, support formulas, and each scorecard accepts up to ten custom KPIs from saved searches that have a date field defined as an available filter (or a period filter, if the scorecard uses periods) and no date filter in the search criteria. NSAW fits better when metrics combine several subject areas, require historical snapshots, or include CRM, ecommerce, or other outside data. KPI scorecards are a NetSuite dashboard feature that an administrator enables, and NSAW is available as an add-on module.
NSAW includes AI-powered analytics capabilities, including natural language processing, through Oracle Analytics Cloud. Some features, such as AI-enhanced Automated Insights, work with datasets and not directly on subject areas. Oracle introduced the NetSuite AI Connector Service for NetSuite Analytics Warehouse in NetSuite 2026.1 and describes it as connecting external AI platforms such as Claude Desktop, Cline AI, and GitHub Copilot with data maintained in NSAW for analysis, using Model Context Protocol (MCP). Ask Oracle, an AI assistant available within NetSuite as of NetSuite 2026.2, lets users ask natural language questions about their NetSuite data. It is available to customers in the United States and Canada, with additional countries coming soon according to Oracle. Administrators manage access, and access can be enabled by role. Oracle has also announced a NetSuite Data Intelligence Agent that brings conversational analysis of NSAW data into Ask Oracle, but Oracle has not listed it among the capabilities available now.
Data from the functional areas an administrator selects is refreshed automatically every 24 hours, and an administrator can start a manual transfer for a specific functional area, so executive dashboards reflect the most recent completed load. Scheduled refreshes suit trend analysis and leadership reviews, where consistency across a reporting period matters more than minute-by-minute changes. NetSuite dashboards, saved searches, and reports retrieve real-time data from your account, so they remain the place to check current transaction status, such as an order shipping today.
The NetSuite Data Intelligence (NSAW) prebuilt data model gets you started. Here is what NetSuite administrators need to know to extend and govern it.
NetSuite Data Intelligence (NSAW) and Tableau both support reporting decisions. Learn how they compare on pipelines, data models, and fit for...
Learn which inventory, margin, delivery, customer, and seasonal metrics landscape supply reporting should provide and what makes them trustworthy.