Data & Analytics
Master NetSuite's powerful data capabilities for querying, reporting, and analytics.
What's Covered
This section covers the tools and techniques for extracting and analyzing data from NetSuite:
SuiteQL
NetSuite's SQL-like query language for powerful, flexible data retrieval:
- SQL Syntax - Use familiar SELECT, JOIN, WHERE, GROUP BY
- Advanced Features - Window functions, CTEs, subqueries, UNION
- N/query Module - SuiteScript integration for automation
- REST API Access - External integrations and applications
Table Reference
Understanding NetSuite's data model - how tables relate and connect:
- Transaction Links - NextTransactionLineLink, PreviousTransactionLineLink for tracing document chains
- Multi-Select Tables -
map_{record}_{field}pattern for multi-select fields - Junction Tables - TransactionLine, TransactionAccountingLine, and other linking tables
- Snapshot Tables - Why addresses and BOMs are copied, not referenced
SuiteAnalytics Workbook
Create interactive reports and dashboards with drag-and-drop functionality:
- Datasets - Define data sources by combining fields and joins without SQL
- Visualizations - Build tables, pivot tables, and charts
- Formula Fields - Create custom calculated fields using SQL functions
- Dashboard Integration - Add workbooks to portlets for real-time insights
Quick Links
SuiteQL
| Topic | Description |
|---|---|
| SuiteQL Introduction | What is SuiteQL and when to use it |
| Fundamentals | Operators, functions, and basic syntax |
| Joins | Combining data from multiple tables |
| Aggregation | GROUP BY and aggregate functions |
| Subqueries | Nested queries for complex logic |
| Dynamic Queries | Building queries programmatically |
| Advanced Techniques | CTEs, window functions, and more |
| N/query Module | Full SuiteScript integration guide |
Table Reference
| Topic | Description |
|---|---|
| Table Reference Overview | Understanding the NetSuite data model |
| Transaction Link Tables | Trace document chains (SO→Invoice→Payment) |
| Multi-Select Tables | Query multi-select custom fields |
| Junction Tables | Common junction table patterns |
| Snapshot Tables | Why addresses/BOMs don't auto-update |
Workbooks
| Topic | Description |
|---|---|
| Workbook Overview | Introduction to SuiteAnalytics Workbook |
| Creating Datasets | Build the foundation for your reports |
| Visualizations | Tables, pivot tables, and charts |
| Formula Fields | Custom calculations and expressions |
| Best Practices | Performance and design optimization |
Coming Soon
Future topics planned for this section:
- SuiteAnalytics Connect - ODBC/JDBC connectivity for external BI tools
- Report Builder - Custom financial and operational reports