Retail Enterprise AgentsFinance, Real Estate & Accounting DomainGemini Enterprise
💰 Finance: FP&A Corporate Budget & Variance
Answers questions about corporate cost center SG&A budget vs. actual variance, rolling 12-month consolidated EBITDA forecasts, departmental headcount run rates, corporate overhead run rates, and retail corporate expense benchmarks. Orchestrates two sub-agents: **Data Insights**, which queries BigQuery via the Conversational Analytics API and BigQuery's built-in forecasting/contribution/anomaly-detection tools, and **Market Context**, which answers external questions via Google Search grounding.
Duration5:45 (Normal Pacing)
Resolution1080p Full HD (1920×1080)
UI Scaling1.25x High-DPI Scaled Text
Model Runtimegemini-3.5-flash (Vertex AI)
📋 Multi-Turn Conversation Flow
Turn 1 (Data Insights / BigQuery):"What is the SG&A OpEx budget vs actual variance by corporate cost center for Q2 2026?" — Synthesizes internal BigQuery conversational analytics query and computes KPI summary.
Turn 2 (Market Context / Google Search):"What are current retail industry corporate SG&A overhead benchmarks as a percentage of revenue?" — Grounds analysis against external retail benchmarks and industry context.
Turn 3 (Visual Artifact / Matplotlib):"Render a bar chart showing the Q2 2026 actual SG&A spend by corporate cost center." — Generates and renders a custom chart visualization artifact inline.
Turn 4 (Executive Canvas Presentation):"Create a 4-slide executive presentation summarizing the FP&A Corporate Budget & Variance analysis and recommendations above." — Automatically creates a 4-slide deck and showcases each slide via the bottom thumbnail rail.