Tables 1 and 2 below, show keywords and commands respectively
It understands tenses for regular and irregular verbs.
For example, "is" includes: are, was, were, will be, have, has, had, will have, has got, do, does, did. And "group" includes: grouped and grouping.
Query Pro recognizes and includes singular and plural versions of a word.
Query Pro uses general knowledge to automatically resolve ambiguity. This knowledge is relevant to your business sector and may need to be extended by adding appropriate synonyms.
Query pro (web app) will highlight when it does not believe something is spelt correctly but there are situations when referencing the data such products, people etc where the spelling may be valid and as such it will not be auto corrected.
The header has a number of options and shows who is logged in. There is also carousel showing examples, hint and tips
Favourites
This shows 20 questions that you have marked as favourites.
To add a favourite click the star to the left of the question in the display or history list.
To remove a favourite click the star to the left of the question in the favourite list.
History
Shows your recent questions. To rerun a question you can select it in the list. To add the question to your favourite, click the star to the left of the question.
Examples
To help you get started there are a series of examples questions in the Examples drop down.
Clear Screen
The Clear Screen clears the display and resets the context.
Open google assistant and say 'Ask Query Pro' and you will be connected and prompted to ask a question regarding your data.
You can now start asking questions of your data, should you require some assistance, towards the bottom you will see buttons for examples, measures and dimensions.
You can also see understand what is available to analyse in the dataset by reviewing the dataset overview.
examples
Google assistant will say 'Try some of these examples' and you see a list of example questions that you can select or ask.
measures
Google assistant will say 'What measure would you like to ask about ?' and you see a list of measures that you can select or state
dimensions
Google assistant will say 'What dimension would you like to ask about ?' and you see a list of dimensions that you can select or state
The products that the stores sell are grouped into a family (such as Drink, Food etc), then these are broken down into departments, categories, subcategories, brand names then the product itself.
| Category / Construct | Keywords | |
|---|---|---|
| questions | how, who, whom, which, when, what, where, does | |
| aggregates | total, sum, amount, number, quantity, count, average, most, largest, highest, biggest, greatest, least, fewest, smallest, lowest, littlest | |
| articles | A, an the | |
| blank/empty | blank, empty, null, prefixed with "non" or "non-", empty string, empty text | |
| boolean | True, false | |
| comparisons | vs, versus, compared to, compared with | |
As well as questions you can also use a range of commands
| Commands | Examples |
|---|---|
| Show, Show me, Display | Show me profit by month for the last 10 months |
| Drill down on, Drill on | Drill down on January 2021 |
| Excluding | Which store has the lowest revenues excluding HQ |
| Group by | Group by store state |
| Filter , Filter on | Filter on store state x |
| Add, Remove <measure> | Add profit |
| Compare | Compare the profits of our biggest store with our smallest store |
| Email me | Email me that |
| Clear context | Clear context |
If date hierarchies are not provided we have the following hierarchies:
| Hierarchy | Levels |
|---|---|
| Default: | Year - Quarter - Month - Date |
| Week: | Year - Month - Week - Date |
| Day of Week: | Day of Week |
Context is maintained between questions. If you wish to reset/clear the context this can be done with the command ‘Clear context’ or using the clear screen button within the webapp.
Context will be maintained in the following situations
1. The request is scant (not enough info in itself)
2. There is no time period specified
3. You have used pronouns(pro-forms) in your question
E.g.
Question 1: What is our best selling product at our most profitable store
Question 2: How much profit did we make from selling those there ?
those refers to ‘the best selling product’
there refers to ‘our most profitable store’
If you asked:
How much profit did we make from selling those ? (ie with there)
it would maintain the context of ‘the best selling product’ but not that of the store.
The default time period will be applied to all questions as no time period has been specified.