1
Data Catalog
Select the Data Source

Browse the role-filtered Data Catalog and select the source table. Row counts, descriptions, and sensitivity flags are visible before any query is written.

Actual Data Source Selected
TABLEAU:benmarchbanks-a51194ad16:cae60c48-9da5-452b-b884-5c49082d5b3a:a267f573-dd18-4747-949e-556876b5d590
2
Columns
Choose the Columns in Scope

Select exactly which columns the AI will work with. Only schema metadata is used — no raw data is ever sent to the AI.

Actual Columns Selected
3
Use Case
Define the Business Question

Describe what you need in plain English. The AI validates the request for clarity and SQL suitability.

Actual use case entered
"Tableau view: Superstore / Overview"
4
SQL Generation
AI Generates & Tests the Query

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.

5
Data Quality ✓ Approved
Validate & Approve the Data

Query results are previewed before any visualization is created. A named approver signs off on data quality — this gate is required and tracked.

Actual Approval Recorded
✓ Approved by Ben Marchbanks  ·  2026-04-30
6
Refine & Release
AI Generates the Visualization — Then You Refine It

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.

Actual Refinements Applied
▶ Data Dictionary
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