AI Dashboard Builder

AI Configuration
Configure your Google Gemini AI API settings
DuckDB Connector Configuration
Configure the Postgres database connection details
Slug:
duckdb-sales-data
Secret Slug:
postgres-connection
Host:
205.178.182.205
Port:
5432
Database:
sales_demo
User:
sales_user
Password:
sales_password
Project Configuration
Set up your dashboard project details
CARTESIANCATEGORICALCONTENTGEOPIETABLETILETILE_MATRIXTIMESERIES
Database Schema
Available tables and their column definitions

customers

Customer information and account details

customer_idINTEGER
Primary key for customer identification
customer_nameVARCHAR(255)
Full name of the customer or company
emailVARCHAR(255)
Customer email address
phoneVARCHAR(255)
Customer phone number
addressVARCHAR(255)
Customer street address
cityVARCHAR(255)
Customer city
countryVARCHAR(255)
Customer country
country_codeVARCHAR(255)
ISO country code
regionVARCHAR(255)
Geographic region (North America, Europe, etc.)
customer_segmentVARCHAR(255)
Customer segment (Individual, SMB, Enterprise)
registration_dateVARCHAR(255)
Date when customer registered (format: %Y-%m-%d)
is_activeBOOLEAN
Whether the customer account is active

products

Product catalog with pricing and inventory information

product_idINTEGER
Primary key for product identification
product_nameVARCHAR(255)
Name of the product
categoryVARCHAR(255)
Product category
cost_priceINTEGER
Cost price of the product stored in cents
selling_priceINTEGER
Selling price of the product stored in cents
stock_quantityINTEGER
Available stock quantity
supplierVARCHAR(255)
Product supplier name
is_activeBOOLEAN
Whether the product is active in catalog

sales_representatives

Sales team member information and performance data

sales_rep_idINTEGER
Unique identifier for sales representative
rep_nameVARCHAR(255)
Full name of sales representative
emailVARCHAR(255)
Sales representative email address
phoneVARCHAR(255)
Sales representative phone number
regionVARCHAR(255)
Geographic region assigned to representative
hire_dateVARCHAR(255)
Date when representative was hired (format: %Y-%m-%d)
is_activeBOOLEAN
Whether the representative is currently active
performance_multiplierDECIMAL(10,2)
Performance multiplier for commission calculation

sales_transactions

Sales transaction records with detailed financial information

transaction_idINTEGER
Unique transaction identifier
customer_idINTEGER
Foreign key to customers table
product_idINTEGER
Foreign key to products table
sales_rep_idINTEGER
Foreign key to sales_representatives table
transaction_dateVARCHAR(255)
Date of the transaction (format: %Y-%m-%d)
quantityINTEGER
Quantity of products sold
unit_priceINTEGER
Price per unit stored in cents
discount_rateDECIMAL(10,2)
Discount rate applied
discounted_priceINTEGER
Price after discount stored in cents
total_amountINTEGER
Total transaction amount stored in cents
total_costINTEGER
Total cost of goods sold stored in cents
profitINTEGER
Profit from the transaction stored in cents
statusVARCHAR(255)
Transaction status
payment_methodVARCHAR(255)
Method of payment used
shipping_costINTEGER
Cost of shipping stored in cents