Demo Sandbox Tips

On this page:

Here you'll find an overview of each of the Demo Projects we've made available in the Demo Sandbox (accessible in the Integrator Portal). For each of these Demo Projects, we've provided a description of the dataset, what you should use the dataset for, a snapshot of the data topics that are contained in each dataset, as well as a sample of what queries you can ask.

Operational Data Demo

What is it?

The Operational Demo is a demo dataset made available to Integrators in our Demo Sandbox environment. This dataset contains data that may typically be found in an enterprise resource planning tool or a cloud accounting software system and is representative of a fictional Plumbing and Electric company.

What should I use this Demo Project for?

Leverage the Operational Demo dataset to showcase AutoQL in action and experience what it’s like to query a database through natural language. Demoing with this dataset enables you to access and analyze data that represents relevant themes and topics that your business users are likely to be familiar with.

What kind of data does this Project contain?

See below for a snapshot of some of the topics/subjects contained in the Operational Demo dataset:

  • Sales
  • Accounts Receivable
  • Invoices
  • Revenue
  • Expenses
  • Accounts Payable
  • Inventory
  • Profits
  • Cash flow
  • Bills
  • Purchase Orders
  • Expenditures

What are some examples of queries can I ask?

Topic

Natural Language Queries You Can Ask

Sales

List all sales from last month 

Average sales per customer per month for the last three months 

Top 5 customers by total revenue this year

Expenses

What are our average expenses per day for the last month?

All expenses over $1000 

Total expenses per month for the last 3 months

Cash Flow

Total cash on hand  

Cash flow by customer by month YTD

Cash flow by month last 6 months

Accounts Receivable

Total accounts receivable by month last 3 months

Accounts receivable by customer

Total outstanding accounts receivable

Accounts Payable

Current AP balance

Show AP by account by vendor

AP by supplier last month

Bills

Total overdue bills by vendor

All vendors with unpaid bills over $1000

Total unpaid bills due by week this month

Invoices

Invoices this year by customer

All outstanding invoices

Average days to pay on invoices over $1000

Inventory

Inventory by month for the last 12 months  

Inventory on hand by item

What are my lowest inventory items?

Purchase Orders

All open purchase orders

Top 5 vendors by purchase orders

Last year’s purchase orders by week

Revenue

Total sales by revenue account

Average monthly revenue per customer this year

Which item brings in the most revenue?

Profits

Gross profit this year

Profit by customer by month this year

Total sales and total profit by customer this year

Expenditures

Total expenditures by vendor this year

Average monthly expenditures

All sales and expenditures by month

Banking Data Demo

What is it?

The Banking Demo is a demo dataset made available to Integrators in our Demo Sandbox environment. It contains transaction-banking data from a fictional bank.

What should I use this Demo Project for?

Leverage the Banking Demo to showcase AutoQL in action and experience what it’s like to query a database through natural language. Demoing with this dataset enables you to access and analyze data that represents relevant banking themes and topics your business users are likely to be familiar with.

What kind of data does this Project contain?

See below for a snapshot of some of the topics/subjects contained in the Banking Demo dataset:

  • Customers
  • Transactions
  • Categories
  • Credit Transactions
  • Products
  • Debit Transactions

Below are some of the value labels that are contained in the Banking Demo dataset:

Tip: We recommend you use these labels/include them in relevant queries when demoing with this dataset to provide a more realistic and relatable experience.

Value Label Types/Topics

Value Labels Contained in Dataset

Customers

Tom Loeza

Lambert Witcher

Kendra Loud

Ciri of Cintra

Triss Merigold

Categories

Personal & Household Expenses

Professional and Financial Services

Retail and Grocery

Transportation

Hotels, Entertainment, and Recreation

Products

Debit Card Accounts

Residential Mortgages

Credit and Charge Cards

GST and Tax Accounts

Transaction Accounts

What are some examples of queries can I ask?

Topic

Natural Language Queries You Can Ask

Customers

All customers that are younger than [age]

All female customers

Phone number for [Customer Name]

Contact details for [Customer Name]

All customers named [Name]

Categories

Which categories has [Customer Name] spent more than $1000 last year

All categories [Customer Name] spent under [dollar amount]

Products

List all products

All products sold to [Customer Name]

All customers who have Debit Card Accounts

Transactions

Number of transactions by customer by month last year

Total weekly transactions amount by customer by category last month

Credits

Last 10 customers with credit transactions

All customers with credit transactions over $5000

Average credit amounts by customer by category by week from January 2019 to April 2019

All customers with credit transactions in transportation

All customers with credit transactions from last month

Debits

Bottom customers with debit transactions from last week

All customers with debit transactions by category

All debit transactions for [Customer Name]

All males with debit transactions by customer name

Stock Market Data Demo

What is it?

The Stock Market Demo is a demo dataset that contains Stock Market data from the S&P 500 Index and is made available to Integrators in our Demo Sandbox environment.

Note: The S&P 500 is a stock market index that measures the stock performance of 500 large companies listed on stock exchanges in the USA.

What should I use this Demo Project for?

Demoing with this dataset enables you to access and analyze data that is continuously evolving or changing in the US stock market. This allows you to showcase how any user could use AutoQL to keep an active pulse on the stock market data that they are interested in tracking and analyzing.

What kind of data does this Project contain?

The Stock Market Demo dataset allows you to query data related to the status of stocks within the S&P 500 Index, including the following topics/subjects:

  • List Index
  • Opening Prices
  • Closing Prices
  • Daily Prices
  • Monthly Prices
  • Volume

What are some examples of queries can I ask?

Topics

Natural Language Queries You Can Ask

Daily

Daily closing price of [Stock Symbol] last week

Daily high price of [Stock Symbol] last month

Daily closing price of [Stock Symbol] [Stock Symbol] and [Stock Symbol] last week

What is the 5 day moving average of [Stock Symbol]

Intraday

Average intraday stock price of [Stock Symbol]

Current intraday price of [Stock Symbol]

Average intraday stock price of [Stock Symbol]

Price

Average price by company by week in 2018

Average price of [Stock Symbol] in October 2020

Lowest price of [Stock Symbol] last month

Bottom 5 companies by average price this year

Price-Volume

Average price and volume by company

Average price and volume of [Stock Symbol] last month

Volume

Average volume for [Stock Symbol] by quarter in 2020

Bottom 10 companies by total volume from last week

How many times did [Stock Symbol] daily volume go below [Total Volume] last month