Silver-to-Gold Aggregation Agent
Silver-to-Gold Aggregation Agent: Transform data, unlock insights, generate KPIs efficiently.
Publisher
Accenture
Industry Type
Retail & Consumer Goods
Product Details
This agent aggregates cleaned data and generates KPIs, storing the summarized output in the Gold layer. It identifies aggregation opportunities such as count, sum, and average, interprets dataset granularity to choose grouping dimensions, generates the SQL without user prompts, and pushes Gold layer KPIs for BI use.
The agent helps automate and scale data engineering workflows with context-aware source-to-target mapping, reducing manual effort and transformation errors. Built for BI analysts and data warehousing teams in retail, finance, and ecommerce, it speeds up dashboard readiness by 80% and cuts KPI derivation time to minutes. It uses BigQuery for data processing, FastAPI for orchestration, and Vertex AI models for KPI logic and aggregation.
Key Use Cases
Autonomous Medallion Architecture KPI Generation
Analyzes Silver-layer schemas in BigQuery to generate and execute SQL aggregation scripts without manual coding, populating production Gold-layer tables for BI tools.
Automated Retail Analytics Engineering
Leverages Vertex AI and FastAPI orchestration to infer optimal grouping dimensions and derive retail KPIs, reducing dashboard preparation time from days to minutes.
Explore detailed deployment path
Requires Gemini. Access integration prerequisites, specialized agent configuration guides, and implementation documentation.