NetSuite Analytics Warehouse (NSAW) is a powerful cloud-based data platform that enables businesses to analyze NetSuite and external data with advanced visualization and reporting capabilities. At the core of NSAW’s data model are Facts, Subject Areas, Dimensions, and Attributes—key components that drive meaningful insights.
Facts are numerical data or measurable business metrics such as sales revenue, order quantity, or invoice amount. These are typically stored in Fact Tables and are the primary values used in reports and dashboards.
Subject Areas group related datasets into meaningful business topics, such as Sales, Finance, Inventory, or Purchasing. Each subject area contains its own facts, dimensions, and attributes, making it easier for users to find and explore relevant data.
Dimensions provide the descriptive context for facts. For example, dimensions like Customer, Product, or Date help users analyze facts from different perspectives. A single fact, like “Total Sales,” can be sliced by dimensions such as region, sales rep, or time.
Attributes are specific fields within a dimension, offering detailed descriptions—for instance, a “Customer Dimension” might include attributes like customer name, industry, and location.
Together, these elements form the semantic layer in NSAW, enabling users to perform robust, self-service analytics with confidence.