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 |
Updated about 22 hours ago