Transforming Business Intelligence with Agentic AI for All My Sons

BizCloud Experts partnered with All My Sons to replace analyst-gated reporting with an agentic AI BI platform. Using AWS Bedrock (Claude), a multi-agent pipeline turns plain-English questions into accurate SQL on Amazon Athena and returns decision-ready insights in ~30–120 seconds, expanding access for leaders and operations.

IndustryLogistics

Solution TypeBusiness Intelligence Modernization Self-Service Analytics (NL→SQL) Workflow Modernization

AWS Services Used

Amazon Bedrock (Claude)

Amazon S3

Amazon Athena

Amazon DynamoDB

Amazon ECS

Amazon CloudFormation

Amazon VPC

97%

faster time-to-insight  (from 30–60 min → 30–120 sec)

10×

Adoption (self-serve vs. analyst-only)

60%

Reduction in BI costs

98%

KPI accuracy across 13 standardized metrics

About Client

All My Sons operates branches across the U.S., managing high‑volume logistics data spanning customer interactions, move execution, crew scheduling, finance, and marketing. The business runs on tight margins where timely insights into revenue, labor efficiency, conversions, cancellations, and marketing ROI directly impact profitability.

The Challenge

• Four-agent pipeline (Intent → General SQL → KPI SQL → Insights) on AWS Bedrock
• Amazon Athena on S3 for serverless query execution; WebSockets for real-time delivery
• KPI agent encoding 13 domain metrics for consistent, accurate calculations
• Weaviate for semantic schema discovery to reduce NL→SQL errors
• Observability & logs in Amazon DynamoDB; containerized services on Amazon ECS with least-privilege IAM

The Solution

• Built a four-agent pipeline (Intent → General SQL → KPI SQL → Insights) on AWS Bedrock
• Athena on S3 for serverless query execution; WebSockets for real-time delivery
• Athena on S3 for serverless query execution; WebSockets for real-time delivery
• KPI agent encoded 13 domain metrics for consistent, accurate calculations
• Weaviate for semantic schema discovery to reduce NL→SQL errors
• Observability & logs in DynamoDB; containerized services on ECS with least-privilege IAM

The Result

• ~97% faster time-to-insight (from 30–60 min to ~30–120 sec)
• 10× increase in data-driven users across leaders and operations
• ~98% KPI accuracy across 13 standardized metrics
• Estimated ~60% cost reduction via serverless, pay-per-use, and fewer analyst loops
• Stronger data culture and quicker operational decisions (e.g., branch-level cancellation hot spots)

Want the Full Story?

Get the detailed case study with architecture diagrams, migration approach, and business impact.