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?

  <th>
    Natural Language Queries You Can Ask
  </th>
</tr>
  <td>
    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
  </td>
</tr>

<tr>
  <td>
    Expenses
  </td>

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

    All expenses over $1000  

    Total expenses per month for the last 3 months
  </td>
</tr>

<tr>
  <td>
    Cash Flow
  </td>

  <td>
    Total cash on hand   

    Cash flow by customer by month YTD 

    Cash flow by month last 6 months
  </td>
</tr>

<tr>
  <td>
    Accounts Receivable
  </td>

  <td>
    Total accounts receivable by month last 3 months 

    Accounts receivable by customer 

    Total outstanding accounts receivable
  </td>
</tr>

<tr>
  <td>
    Accounts Payable
  </td>

  <td>
    Current AP balance 

    Show AP by account by vendor 

    AP by supplier last month
  </td>
</tr>

<tr>
  <td>
    Bills
  </td>

  <td>
    Total overdue bills by vendor 

    All vendors with unpaid bills over $1000 

    Total unpaid bills due by week this month
  </td>
</tr>

<tr>
  <td>
    Invoices
  </td>

  <td>
    Invoices this year by customer 

    All outstanding invoices  

    Average days to pay on invoices over $1000
  </td>
</tr>

<tr>
  <td>
    Inventory
  </td>

  <td>
    Inventory by month for the last 12 months   

    Inventory on hand by item 

    What are my lowest inventory items?
  </td>
</tr>

<tr>
  <td>
    Purchase Orders
  </td>

  <td>
    All open purchase orders 

    Top 5 vendors by purchase orders 

    Last year’s purchase orders by week
  </td>
</tr>

<tr>
  <td>
    Revenue
  </td>

  <td>
    Total sales by revenue account 

    Average monthly revenue per customer this year 

    Which item brings in the most revenue?
  </td>
</tr>

<tr>
  <td>
    Profits
  </td>

  <td>
    Gross profit this year 

    Profit by customer by month this year 

    Total sales and total profit by customer this year
  </td>
</tr>

<tr>
  <td>
    Expenditures
  </td>

  <td>
    Total expenditures by vendor this year 

    Average monthly expenditures 

    All sales and expenditures by month
  </td>
</tr>
Topic
Sales

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.

  <th>
    Value Labels Contained in Dataset
  </th>
</tr>
  <td>
    Tom Loeza

    Lambert Witcher

    Kendra Loud

    Ciri of Cintra

    Triss Merigold
  </td>
</tr>

<tr>
  <td>
    Categories
  </td>

  <td>
    Personal & Household Expenses

    Professional and Financial Services

    Retail and Grocery

    Transportation

    Hotels, Entertainment, and Recreation
  </td>
</tr>

<tr>
  <td>
    Products
  </td>

  <td>
    Debit Card Accounts

    Residential Mortgages

    Credit and Charge Cards

    GST and Tax Accounts

    Transaction Accounts
  </td>
</tr>
Value Label Types/Topics
Customers

What are some examples of queries can I ask?

  <th>
    Natural Language Queries You Can Ask
  </th>
</tr>
  <td>
    All customers that are younger than this  

    All female customers 

    Phone number for iew of each of  

    Contact details for  made available 

    All customers named ccessi
  </td>
</tr>

<tr>
  <td>
    Categories
  </td>

  <td>
    Which categories has   "title": "On  spent more than $1000 last year 

    All categories w of each of th spent under ts we've made a
  </td>
</tr>

<tr>
  <td>
    Products
  </td>

  <td>
    List all products 

    All products sold to page:"
    }
    [/bloc 

    All customers who have Debit Card Accounts
  </td>
</tr>

<tr>
  <td>
    Transactions
  </td>

  <td>
    Number of transactions by customer by month last year 

    Total weekly transactions amount by customer by category last month
  </td>
</tr>

<tr>
  <td>
    Credits
  </td>

  <td>
    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
  </td>
</tr>

<tr>
  <td>
    Debits
  </td>

  <td>
    Bottom customers with debit transactions from last week 

    All customers with debit transactions by category 

    All debit transactions for  in the Demo Sa 

    All males with debit transactions by customer name
  </td>
</tr>
Topic
Customers

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?

  <th>
    Natural Language Queries You Can Ask
  </th>
</tr>
  <td>
    Daily closing price of "title": "On t last week 

    Daily high price of  find an overv last month 

    Daily closing price of e made availab e in the Demo  and ox (accessible last week 

    What is the 5 day moving average of o Projects, we
  </td>
</tr>

<tr>
  <td>
    Intraday
  </td>

  <td>
    Average intraday stock price of "On this page:

    Current intraday price of d an overview  

    Average intraday stock price of made available
  </td>
</tr>

<tr>
  <td>
    Price
  </td>

  <td>
    Average price by company by week in 2018 

    Average price of ere you'll fin in October 2020 

    Lowest price of rojects we've  last month 

    Bottom 5 companies by average price this year
  </td>
</tr>

<tr>
  <td>
    Price-Volume
  </td>

  <td>
    Average price and volume by company 

    Average price and volume of u'll find an o last month
  </td>
</tr>

<tr>
  <td>
    Volume
  </td>

  <td>
    Average volume for {
      "title": " by quarter in 2020

    Bottom 10 companies by total volume from last week 

    How many times did e available in daily volume go below ssible in the  last month
  </td>
</tr>
Topics
Daily