What happens between a question and an answer.

An administrator connects QuerySafe to the BigQuery datasets the organization wants it to use.

• › project · demo-analytics
• › datasets · sales, crm, catalog
• › access · read

The question is interpreted: what is being measured, over what period, compared with what, for whom.

• › intent · purchasing decline
• › entity · customer
• › window · 90d vs prior 90d
• › threshold · significant = ≥ 40%

QuerySafe identifies which tables and fields hold the answer, using what it has learned about your data.

• › sales.orders
• › sales.order_items
• › crm.customers

The analysis runs against the relevant data. Results are compared, grouped and checked for what stands out.

• › 1,284,902 rows scanned
• › 4,812 customers compared
• › 327 matched

Numbers become an answer: a plain-language summary, the key figures, a chart and the sources used.

• › summary · 2 sentences
• › metrics · 4
• › chart · weekly orders
• › sources · 3 tables

The conversation continues. Follow-up questions reuse the context of the previous answer.

• › “Which of these were top-20 accounts last year?”