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 |
Updated almost 4 years ago