Home / Projects / Nexus Agro
Data products · Territorial agro-intelligence platform

Nexus Agro

A platform that consolidates Brazil's public agricultural data into territorial intelligence: maps, rankings, traceable diagnostics and a potential score, built to turn official data into decisions.

Domain
Agribusiness · public policy
Source
SIDRA / IBGE (PAM)
Engine
Python ETL + diagnostics
Status
Live · v0.2
Challenge

The problem to solve

Brazil publishes rich agricultural data, but it sits across many portals in formats that are hard to combine and harder to interpret. The value is public, yet effectively locked away from the people who could act on it.

Working system

What we built

A single platform that consolidates official SIDRA/IBGE production data into a territorial intelligence layer. It organizes and normalizes the numbers, then turns them into maps, rankings, reports, a traceable diagnosis for every municipality, and a composite potential score, for consultancies, companies, local governments and market analysts.

By the numbers

What it covers

27
States
5,570
Municipalities
71
Crops
10y
Time series
EST Full dataset target: millions of observations. Current live build: ~3,000 observations, expanding with each ingestion cycle.
Architecture

From public data to intelligence

Official data flows through an automated pipeline into an intelligence layer, then surfaces in an explorable observatory of maps, rankings and reports.

SIDRA/IBGE PAM tables 1612/1613 2014–2024 Intelligence layer diagnostics + IPA index 6 rules · 4-dim composite Observatory maps · rankings · reports + AI assistant (beta) Diagnostics 5,570 IPA Score 0–100 Reports /uf-crop
Platform architecture: public data → intelligence engine → observatory with per-municipality diagnostics.
The platform

What it does

01
Consolidate
Official SIDRA/IBGE data, refreshed monthly by an automated ETL.
02
Diagnose
Six deterministic, traceable rules per municipality, covering volatility, concentration, yield gap, diversity, regional weight and area trend.
03
Score
A 0–100 Agricultural Potential Index over growth, productivity, stability and diversity.
04
Explore
Maps, rankings and reports in the Observatory, down to the municipality.
Intelligence

Stack and methods

SIDRA / IBGE (PAM) Python ETL GitHub Actions Deterministic diagnostics Composite scoring Comex Stat (beta)
Outcome

What it achieved

Brazil's public agricultural data, once scattered across portals, is now a single territorial intelligence platform. Every municipality is readable through maps, rankings, traceable diagnostics and a potential score, with each conclusion tied back to the rule that produced it.

Evidence

Live platform

LIVE

Explore the working platform at nexusagro.vercel.app.

Next

How it can evolve

The platform is growing beyond production data: foreign-trade flows (Comex Stat, in beta), logistics and infrastructure, climate and risk, and an AI assistant that answers questions on what to plant, how to move it and how to sell, grounded in the platform's data and sector documents.

Where systems stop, Nex begins.

Too complex for spreadsheets. Too specific for generic software.

Start a project →