Agent-ready analytics: Unlocking insights with BigQuery augmented analytics

The useful part

BigQuery now features a suite of augmented analytics Table-Valued Functions (TVFs) designed to automate complex data analysis at scale. Augmented analytics combines AI, ML and statistical methods to automate insight discovery and pattern explanation. These functions allow you to diagnose why metrics changed, uncover underlying trends and relationships across the data, and even isolate the true impact of business decisions.

How it works

• These TVFs run directly where your data lives, which helps speed up analysis and reduces the need to export data into external tools.
• since these functions are compact and yield structured SQL outputs, they can easily be integrated as skills for AI agents, which easily enables automated, conversational data investigation workflows.
• We are introducing six new augmented analytics functions in BigQuery, each created to address a specific analytical challenge: TVF Function.
• Answers AI.KEY_DRIVERS Identifies the top drivers behind an increase or drop in a metric between two time periods or groups.
• AI.CAUSAL_EFFECT Quantifies the impact of an action or event by comparing the observed results to an expected baseline.

Details worth keeping

Why did revenue spike this quarter compared to last quarter?