I’ve been exploring a number of AI agents and based on my exploration, Conversational Analytics Agent in Bigquery offers the best results and is the easiest to use.
A number of products:
Gemni Enterprise
Looker Studio Conversational Analytics
Vetex AI
The agent created can be fine tuned, then shared via Looker Studio Pro; or shared directly using API or ADK tools

Bigquery agent (Conversational Analytics)