Ask for a dashboard, watch it build: analytics for 400+ warehouses.
A warehousing operator running a network of more than 400 warehouses wanted to see how its operations data, from stock and throughput to capacity and revenue, could answer questions directly. Plexe built an AI analytics workspace: a manager asks for a dashboard in plain English and a Claude agent builds it panel by panel on a governed metrics layer, with forecasts and anomaly checks. It was built as a demo on seeded data shaped like the operator's own; it has not run on live data.
How it fits together
- Operations managerchat and canvas
- Analytics agentClaude, tool use
- Metrics layergoverned SQL
- Analytics serviceforecasts, anomalies
- Warehouse dataPostgreSQL
The challenge
- Operations data spread across inventory, transactions, revenue and capacity
- Each new view of the network needed someone to build a report
- The same figure has to mean the same thing on every dashboard
- Planning needs forecasts with a range, not only a look back
What we built
- A chat and live canvas where dashboards stream in as they are built
- A Claude agent with nine tools to create, change and save dashboards
- A semantic layer that compiles governed metrics into deterministic SQL
- A Python service for forecasts, anomalies and seasonal decomposition
What the workspace is for
A network of more than 400 warehouses produces a lot of operational data: daily inventory snapshots by commodity, inward and outward transactions, daily capacity utilisation and monthly revenue split into storage, handling and insurance charges. The workspace was built to show what it looks like when operations and finance staff can question that data directly. Instead of filing a request for a new report, a manager types what they want to see and gets a working dashboard they can change, save and come back to.
How it works
The screen is split in two: chat on the left, a live canvas on the right. A request such as a six-month revenue projection goes to a Claude agent running a tool-use loop with nine tools, and panels stream onto the canvas as each query or forecast completes. Follow-ups like "add a panel showing the top five warehouses by revenue" or "change panel 2 to a line chart" patch the dashboard in place, and any dashboard can be saved as a report, reopened and updated.
Forecasts come from a separate Python service using Holt-Winters exponential smoothing, and each forecast panel shows 95% confidence intervals so planners can see the range, not just a single line. The same service exposes endpoints for anomaly detection with Isolation Forest, seasonal decomposition and correlation between series. If the service is unavailable, the workspace falls back to a linear regression forecast rather than leaving the panel empty.
Governed numbers, not guessed ones
The agent does not write free-form SQL for the core figures. A semantic layer defines 11 governed metrics, 12 dimensions and 10 time-range presets, and compiles each request into deterministic SQL, so two people asking the same question get the same number. A metrics page shows the full catalogue, which gives finance and operations one place to agree what each figure means. Server-side output guardrails clean every agent response before it reaches the screen.
Where it stands
The workspace was built as a demo and runs on seeded data in a warehousing schema modelled on the operator's network, not on its production systems. It connects to PostgreSQL and includes a schema browser, so pointing it at a real database is a connection change rather than a rebuild. No usage or outcome figures exist yet, because it has not been deployed to the operator's teams.
Under the hood
Stack
- Next.js
- React
- Anthropic Claude
- Python FastAPI
- statsmodels
- scikit-learn
- PostgreSQL