Ever wonder how to create a dataset that not only satisfies your users today, but also keeps them happy tomorrow? While NSAW offers great out-of-the-box functionality for standard NetSuite data, most businesses quickly realize that custom segments, fields, and calculated columns are essential for their reporting. With some upfront planning, you can create a dataset that supports multiple workbooks, dashboards, and user groups — all while maintaining just a single source of truth.”
Why a Custom Dataset Matters
• Standard NSAW subject areas cover transactions, items, and customers — but rarely the full picture.
• Business users often need custom dimensions and fields: industry-specific segments, approval flows, calculated KPIs.
• Without a unified dataset, you end up duplicating work across multiple workbooks, each with slightly different logic.
Principles of Good Dataset Design
• Single Source of Truth: One dataset flexible enough to serve multiple teams.
• Grain Awareness: Decide the base level (transaction line vs. invoice vs. customer).
• Governance: Define ownership of key metrics (who approves Gross Margin % definition?).
How NSAW Handles Custom Data
Unlike classic ETL-heavy data warehouses, NSAW brings NetSuite data close to live:
• Loading Custom Fields and Objects: NSAW connectors allow you to bring in NetSuite’s custom segments, fields, lists, and records alongside standard subject areas.
• Data Models: Using data models, you can link multiple objects into one semantic structure, defining relationships (e.g., transactions ↔ custom region segment).
• Data Sequences: These allow you to define the flow of joins and transformations, so the dataset reflects both standard NetSuite logic and your own business-specific calculations.
• Near-live Querying: Since NSAW syncs frequently with NetSuite, users can query the dataset with confidence that it mirrors current operational data.
Best Practice Tip: Model your dataset in a way that balances flexibility with performance. Include only the most commonly used custom segments and metrics at the dataset level; leave one-off logic to workbook calculations.
Delivering Value to Users
• Tables for Analysts: Expose raw data for deeper exploration.
• Visuals for Decision Makers: Build dashboards that roll up custom KPIs (monthly sales by custom segment, margin by channel, etc.).
• Consistency Across the Org: Finance, operations, and sales are all working from the same definitions.
Partnering With Experts
Creating robust models in NSAW requires more than clicking a few boxes — it requires an understanding of NetSuite’s database structure, custom record relationships, and reporting needs across functions.
This is where Promethean can help. With years of experience working inside NetSuite and NSAW, our team helps clients:
• Analyze existing data structures and identify reporting gaps.
• Architect custom datasets that support daily and monthly reporting across multiple departments.
• Simplify complex reporting needs into a single, maintainable dataset that scales with the business.
With the right architecture and guidance, your NSAW dataset becomes more than just a reporting tool — it becomes the foundation for smarter decision-making across your organization.