From raw data to a certified, interactive data product — six governed steps, no code required.
Browse the role-filtered Data Catalog and select the source table. Row counts, descriptions, and sensitivity flags are visible before any query is written.
Select exactly which columns the AI will work with. Only schema metadata is used — no raw data is ever sent to the AI.
Describe what you need in plain English. The AI validates the request for clarity and SQL suitability.
The AI produces a validated SELECT query tailored to the use case. The query is tested against live data before proceeding — only SELECT statements are permitted.
Query results are previewed before any visualization is created. A named approver signs off on data quality — this gate is required and tracked.
The AI recommends the best visualization type and generates the raw program code required for an interactive rendering. Each refinement is a natural language instruction — no code editing required. Every iteration is stored and reusable.
| Column | Definition | Domain | Examples | Synonyms |
|---|---|---|---|---|
| Category | A broad classification that groups similar products or services together based on their type, function, or characteristics to help organize inventory and analyze business performance across product lines. | Operations | Electronics, Furniture, Office Supplies, Clothing, Home & Garden | Product Category, Product Type, Product Line, Product Group, Merchandise Category |
| City | The municipal area or urban center where the customer's delivery address is located. This field specifies the exact city within a state or province for precise geographic identification and logistics planning. | Customer | New York, Los Angeles, Chicago, Houston, Phoenix | Municipality, Urban Area, Metropolitan Area, Town, Delivery City |
| Country/Region | The country or regional territory where a customer order is being delivered or where business operations are conducted. This field identifies the primary geographic location for shipping purposes and regional business analysis. | Operations | United States, Canada, United Kingdom, Germany, Australia | Nation, Territory, Geographic Region, Shipping Country, Delivery Country |
| Customer ID | A unique identifier assigned to each customer in the system to distinguish individual customers and link all their transactions and interactions across different business processes. | Customer | CUST-12345, C-98765, ID-55443, CX-22110, USR-87654 | Client ID, Account Number, Customer Code, Customer Reference, Account ID |
| Customer Name | The full name or business name of the individual or organization that purchased products or services, used to identify and maintain customer relationships and transaction records. | Customer | ABC Corporation, Jane Doe, TechStart Industries, Robert Johnson, Global Solutions LLC | Client Name, Account Name, Buyer Name, Customer Identity, Purchaser Name |
| Discount | The reduction in price offered to customers, typically expressed as a percentage or dollar amount, applied to the original selling price to incentivize purchases or reward customer loyalty. | Sales | 0.15, 0.05, 0.20, 0.10, 0.25 | Price Reduction, Markdown, Rebate, Price Discount, Promotional Discount |
| Order Date | The specific date when a customer placed an order for products or services. This timestamp is used to track when business transactions occurred and for time-based analysis of sales performance. | Sales | 2023-03-15, 2023-07-22, 2023-11-08, 2023-01-30, 2023-09-12 | Purchase Date, Transaction Date, Sale Date, Order Timestamp, Date of Purchase |
| Order ID | A unique identifier assigned to each customer order to track and reference specific transactions throughout the order fulfillment process and for record-keeping purposes. | Operations | ORD-2023-001234, SO-456789, ORDER-987654, TXN-112233, REQ-334455 | Order Number, Transaction ID, Purchase Order ID, Sales Order Number, Reference Number |
| Postal Code | The postal or ZIP code associated with the delivery address or customer location, used for geographic analysis, shipping calculations, and regional business performance tracking. | Customer | 10001, 90210, 60601, 30309, 02101 | ZIP Code, Post Code, Postal Zone, Mail Code, Area Code |
| Product ID | A unique identifier or code assigned to each distinct product in the inventory system. This alphanumeric code serves as a primary reference for tracking, ordering, and managing individual products throughout business operations. | Sales | FUR-BO-10001798, OFF-PA-10002365, TEC-PH-10004664, OFF-BI-10003910, FUR-CH-10000454 | Product Code, SKU, Item Number, Product Reference, Catalog Number |
| Product Name | The specific name or title of an individual product or service offered for sale, providing a clear description that distinguishes it from other items in the product catalog. | Operations | Wireless Bluetooth Headphones, Executive Office Chair, Multi-Function Printer, Smartphone Case, LED Desk Lamp | Item Name, Product Title, Product Description, Item Description, Product Label |
| Profit | The financial gain calculated as the difference between the sales revenue and the total costs associated with producing and selling the product or service for a specific transaction. | Finance | 342.50, 125.75, 890.25, 67.80, 456.30 | Net Profit, Gross Margin, Earnings, Net Income, Profit Margin |
| Quantity | The total number of individual units or items of a specific product that were ordered and purchased in a single transaction. This represents the count of identical products bought together. | Sales | 1, 3, 5, 2, 10 | Units Ordered, Item Count, Product Quantity, Order Volume, Purchase Amount |
| Region | A geographic area or territory used to organize business operations, typically grouping customers, sales activities, or distribution networks by location for management and reporting purposes. | Sales | North America, Europe, Asia Pacific, Latin America, Middle East | Territory, Geographic Area, Sales Region, Market Region, Zone |
| Row ID | A unique numeric identifier assigned to each record or row in the database table to ensure data integrity and provide a reliable way to reference specific entries in the system. | Operations | 1001, 1002, 1003, 1004, 1005 | Record ID, Entry ID, Sequence Number, Primary Key, Record Number |
| Sales | The total monetary value of goods or services sold to customers during a specific transaction or time period. This represents the gross revenue generated before any deductions for costs, discounts, or returns. | Sales | 1250.75, 899.99, 2340.00, 567.25, 1875.50 | Revenue, Gross Sales, Sales Amount, Sales Revenue, Total Sales |
| Sales Person | The name or identifier of the individual sales representative who was responsible for completing a specific sale or managing the customer relationship that led to the transaction. | Sales | John Smith, Sarah Johnson, Mike Chen, Lisa Rodriguez, David Wilson | Sales Rep, Account Executive, Sales Representative, Sales Agent, Account Manager |
| Sales Target | The predetermined monetary goal or quota set for sales performance over a specific time period, used to measure and evaluate the success of sales activities against planned objectives. | Sales | 50000, 125000, 75000, 200000, 90000 | Sales Quota, Revenue Target, Sales Goal, Sales Objective, Revenue Goal |
| Segment | A classification that groups customers based on shared characteristics such as business type, size, purchasing behavior, or other criteria to enable targeted marketing and sales strategies. | Customer | Enterprise, Small Business, Consumer, Government, Education | Customer Segment, Market Segment, Customer Type, Business Segment, Customer Class |
| Ship Date | The specific calendar date when an order was physically dispatched or sent out for delivery to the customer. This represents when the product left the warehouse or fulfillment center to begin its journey to the final destination. | Operations | 2023-03-15, 2023-07-22, 2023-11-08, 2023-05-03, 2023-09-17 | Dispatch Date, Shipment Date, Delivery Start Date, Fulfillment Date, Send Date |
| Ship Mode | The method or service level selected for delivering products to customers. This indicates the speed and type of shipping service used, which affects delivery time and shipping costs. | Operations | Standard Class, Second Class, First Class, Same Day, Express | Shipping Method, Delivery Mode, Shipping Service, Transport Method, Fulfillment Method |
| State/Province | The primary administrative division within a country where the customer's address is located. This represents the state, province, or equivalent regional government subdivision for geographic and regulatory purposes. | Customer | California, Texas, Ontario, New York, Florida | State, Province, Administrative Region, Geographic Division, Regional Territory |
| Sub-Category | A more specific classification within a broader product category that groups similar items with related characteristics or functions. This provides detailed product organization for inventory management and sales analysis. | Sales | Chairs, Storage, Phones, Paper, Binders | Product Sub-Type, Item Classification, Product Segment, Merchandise Group, Product Division |